So Tired !_! 逆水行舟, 不进则退!

1Mar/16

killing of MySQL processlist(清理mysql所有队列)

mysql> select concat('KILL ',id,';') from information_schema.processlist where user='root' and time > 3 into outfile '/tmp/a.txt';
mysql> source /tmp/a.txt;
anyShare分享到:
Comments (0) Trackbacks (0)

Sorry, the comment form is closed at this time.

Trackbacks are disabled.

site