OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
How to detect mytop long-time queries and kill them

From: thomas Armstrong (tarmstronggmail.com)
Date: Tue Dec 11 2007 - 06:40:17 CST


Hi.

I've been finding some queries by using 'mytop' which takes +200
seconds to be executed. It wastes tons of CPU resources on my server
and would like to detect them automatically and kill them.

Does anybody have experience with this issue? Thank you very much,
--Thomas

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql