Greenguy's Board - Code To Auto Killall Mysqld

Greenguy's Board (http://www.greenguysboard.com/board/index.php)

- Programming & Scripting (http://www.greenguysboard.com/board/forumdisplay.php?f=15)

- - Code To Auto Killall Mysqld (http://www.greenguysboard.com/board/showthread.php?t=35550)

Code To Auto Killall Mysqld

Im looking for a command that will check my server load and run the command 'killall mysqld' if the load is over a certain average. Should I be looking for cron commands to do this?

I would suggest you better check why the mysql load moves that high and find a solution for this or better fix the program which makes the server load :)

I wouldn't condone doing a kill for that as you're likely to leave tables in a crashed state requiring a repair or at least a check before you start.

However, with that said, you could do something like:

Code:

#!/usr/bin/perl



open F,("
($ld,$junk) = split /\./,;

close F;



if ($ld >= 10) {

  `whateveryouwanttorun`;

}

If the 1 minute load average is above 10, it will run that command. Put that in cron and you should be set. However, I'll say again, and I agree with servhot, I think its a bad idea to kill the server.

Perhaps run something like

mysqladmin -uroot -ppassword processlist | mail username@domain.com

or turn on the slow query log, or do a show processlist in the mysql command line interface or phpmyadmin.

Better to find the cause than to treat the effect.