一次cacti和mysql数据库问题

fortara

  昨天cacti登陆不上，发现硬盘满了，php的log有1.4g，mysql的binlog也很多

1.修改cacti的error_reporting参数

Edit your php.ini and set error_reporting to:
Code:
error_reporting = E_ALL & ~E_DEPRECATED

After that edit /cacti/include/global.php and change line 196 from
Code:
error_reporting(E_ALL);
to
Code:
error_reporting(E_ALL ^ E_DEPRECATED);
Do exactly the same in line 312 of file adodb-time.inc.php located in /cacti/lib/adodb
2.删除mysql的binlog文件，记得删除bin log的index文件，不然会启动不了数据库

3.有张数据库表crash了，修复一下

cd mysql/cacti

/opt/lampp/bin/myisamchk -r poller_output

 

故障解除