cacti mysql tempate安装日志

最新推荐文章于 2025-07-26 18:40:52 发布

pwlazy

最新推荐文章于 2025-07-26 18:40:52 发布

阅读量1.5k

点赞数

CC 4.0 BY-SA版权

文章标签： mysql memcached firefox database 文档 graph

本文链接：https://blog.youkuaiyun.com/pwlazy/article/details/3170413

本文详细介绍如何使用Cacti监控MySQL性能指标，包括下载安装文件、配置脚本位置、设置定时任务及导入模板等步骤，并指导用户创建监控图表。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

cd /usr/local/src
wget http://www.faemalia.net/mysqlUtils/teMySQLcacti-20060810.tar.gz
tar xzvf teMySQLcacti-20060810.tar.gz

按照官方文档中的3步
1). Put mysql_stats.php and dumpMemcachedStats.php in cacti/scripts/

本文只拷了mysql_stats
cp teMySQLcacti/mysql_stats.php /var/www/html/cacti/scripts

2）
Either ensure your cacti poller is cron'd every 1 minute, or run the included    BASH shell script to create a 300/600 step/heartbeat version of the XML file.

但其实tar本来就有cacti_host_template_temysql_host-step300-heartbeat600.xml

上面的步骤很多余

3)Import the .XML host using the cacti webinterface. Note,

上面3步安装好后，开始再按照官方文档产生图

GRAPH CREATION
==============

0. Make sure you installed mysql_stats.php and dumpMemcachedStats.php.
1. Go to Management/Devices.
2. Add a new device.
3. Description can be whatever you want.
4. Hostname should resolve to IP of database machine.
5. Host template is teMySQL or memcached Host.
6. Now choose the "Create Graphs" link.
7. Highlight all graphs for the host (assuming you want them all).
8. Choose "Create"
9. A page will come up with several Password/Username pairs, fill them
   all in with the cactipasswd/cactiuser you chose above. Hint: If you're
   using Firefox, the second host you do this for you can just press down-
   arrow twice, then tab, and the value will be filled in automatically
   by the browser. The first time, I suggest typing in the username, copying
   it, then doing a "paste-tab-tab-paste-tab-tab..." key combo until they're
   all filled in, then repeat for the password. Painful, but doable.