MySql sleep kill
Linux/MySql : 2012/05/04 17:31
1. sleep.php
<?
define('MAX_SLEEP_TIME', 120);
$hostname = "localhost";
$username = "root";
$password = "password";
$connect = mysql_connect($hostname, $username, $password);
$result = mysql_query("SHOW PROCESSLIST", $connect);
while ($proc = mysql_fetch_assoc($result)) {
if ($proc["Command"] == "Sleep" && $proc["Time"] > MAX_SLEEP_TIME) {
@mysql_query("KILL " . $proc["Id"], $connect);
}
}
mysql_close($connect);
?>
2. sleep
#!/bin/bash
cd /home/path/cron
php -q ./sleep.php
3. crontab
*/5 * * * * /home/path/cron/sleep > /dev/null 2>&1
Trackback Address :: http://jjangu.pe.kr/blog/trackback/620
