MySQL每5分钟一次的监控脚本

admin

#!/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[1]);
}

$log = sprintf("\n%s %s %s %s %s %s %s %s %s", date('H:i'), $data[0], $data[1], $data[2], $data[3], $data[4], $data[5], $data[6], $data[7]);

$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