Jose Pablo Mora JPablomr

mezis / query_finder.sql

Last active May 26, 2024 20:03

Finding long-running queries in MySQL

	SELECT id,state,command,time,left(replace(info,'\n','<lf>'),120)
	FROM information_schema.processlist
	WHERE command <> 'Sleep'
	AND info NOT LIKE '%PROCESSLIST%'
	ORDER BY time DESC LIMIT 50;