cacti监控mysql服务

BOoRFGOnZ

脚本位置：http://forums.cacti.net/viewtopic.php?t=11010

# wget http://www.faemalia.net/mysqlUtils/teMySQLcacti-20060810.tar.gz
# cd /data/src/teMySQLcacti
# ./convertXmlTo5minutePollingInterval.sh

These graphs assume a 1-minute Poller cron frequency! If you use the default 5-minute interval, run convertXmlTo5minutePollingInterval.sh, which will make a step=300, heartbeat=600 version of the XML file for you to import.

# cp mysql_stats.php /data/cacti/scripts/
# cp dumpMemcachedStats.php /data/cacti/scripts/

在cacti管理界面导入cacti_host_template_temysql_host-step300-heartbeat600.xml 与cacti_host_template_memcached_host-step300-heartbeat600.xml模板文件。

被监控的msql数据库服务器需要加入以下权限：
mysql> grant process,super on *.* to ‘cacti’@'cacti server ip’ identified by ‘password’;

npcomet

http://lcuc.org.cn/node/1447