runningnet/masskill.sql

Created December 12, 2014 07:33

Star (0) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Select an option

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/runningnet/8116d92113f4331e8674.js"></script>
Save runningnet/8116d92113f4331e8674 to your computer and use it in GitHub Desktop.

Download ZIP

Kill automatisch Mysql Connections From http://www.percona.com/blog/2009/05/21/mass-killing-of-mysql-connections/

Raw

masskill.sql

	select concat('KILL ',id,';') from information_schema.processlist where user='root' into outfile '/tmp/a.txt';
	source /tmp/a.txt;

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment