MySQL每5分钟一次的监控脚本
#!/usr/local/bin/php<?php
$dbhost = '127.0.0.1';
$dbuser = 'root';
$dbpass = 'langwan';
$dbname = 'testdb';
$logpath = '/var/logs/db';
$link = mysql_connect($dbhost, $dbuser, $dbpass, $dbname);
$info = explode(' ', mysql_stat($link));
$data = array();
foreach($info as $row) {
$t = explode(': ', $row);
$data[] = trim($t);
}
$log = sprintf("\n%s %s %s %s %s %s %s %s %s", date('H:i'), $data, $data, $data, $data, $data, $data, $data, $data);
$logname = date('Y-m-d');
$logpath .= $logname.'.log';
$fp = fopen($logpath, 'a');
fwrite($fp, $log);
fclose($fp);
echo $log;
?>
执行可以
crontab -e
0,5,10,15,20,25,30,35,40,45,50,55 * * * * /cron/dbStatus.php > /dev/null 2>&1
页:
[1]