nimdasx/kill-query-macet.sql

Last active January 14, 2020 08:56

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

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

Download ZIP

kill query mysql macet

Raw

kill-query-macet.sql

	SELECT
	GROUP_CONCAT(CONCAT('KILL ', id, ';') SEPARATOR ' ') KillQuery
	FROM information_schema.processlist
	WHERE user <> 'root'
	AND time >= 100;

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