|
| PORTAIL | ANNUAIRE | ARTICLES | COMPARATEUR HÉBERGEURS | DEVIS | FORUMS | RÉDUCTEUR D'URL |
|
|
|
|
||||||
 |
|
|
LinkBack | Outils de la discussion |
11/12/2007, 12h40
|
#1 |
Messages: n/a
Hébergeur: |
How to detect mytop long-time queries and kill them
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 |
|
|
11/12/2007, 15h22
|
#2 |
|
Messages: n/a
Hébergeur: |
Re: How to detect mytop long-time queries and kill them
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 much, >--Thomas Thomas, I would write a program (choose your language) that would execute a "Show ProcessList" every 10 seconds or so. I would then examine the results and look for ones that run more than 200 seconds and then issue a Kill command on them. You could allow certain user like "root" to run commands to run longer than 200 seconds. Maybe you want to kill long running commands for only certain users and you can do that too. Mike |
|
|
|
| Outils de la discussion | |
|
|
