php自动删除mysql死连接(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 * * * * php /usr/local/sbin/kill-mysql-sleep-proc.php