How to detect mytop long-time queries and kill them

2007-12-11 Thread thomas Armstrong
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

Re: How to detect mytop long-time queries and kill them

2007-12-11 Thread mos
At 06:40 AM 12/11/2007, you wrote: 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