Cacti adding a MySQL monitor template

At first, in the Internet to find a lot of template reference documents, are not suitable for their own environment, their own groping to find out, finally made.

Thank you very much for the 51 technology "YANGZHIMINGG" provided by the monitoring template, suitable for yourself.

First, to "http://down.51cto.com/data/382105" Download the template, download the decompression, the "ss_get_mysql_stats.php" script to upload to the server "/usr/share/cacti/site /"below

sudo cp/tmp/ss_get_mysql_stats.php/usr/share/cacti/site/

Login to cacti Web page, console----Import templates, will be local "cacti_host_template_x_db_server_ht_0.8.6i. XML template import.

After importing, the following information is displayed:

CACTI has imported the following items:

Cdef

[Success] X Negate cdef [new]

Gprint Preset

[Success] X Normal [new]

Data Input Method

[Success] X Get MySQL stats/myisam Indexes IM [new]
[Success] X Get MySQL stats/innodb Buffer Pool IM [new]
[Success] X Get MySQL stats/innodb I/o IM [new]
[Success] X Get MySQL stats/innodb Insert Buffer IM [new]
[Success] X Get MySQL stats/innodb semaphores IM [new]
[Success] X Get MySQL stats/innodb Row Operations IM [new]
[Success] X Get MySQL stats/mysql Table Locks IM [new]
[Success] X Get MySQL stats/mysql Connections IM [new]
[Success] X Get MySQL stats/mysql Replication IM [new]
[Success] X Get MySQL stats/mysql Query Cache IM [new]
[Success] X Get MySQL stats/mysql Query Cache Memory IM [new]
[Success] X Get MySQL stats/mysql Command Counters IM [new]
[Success] X Get MySQL stats/mysql Select Types IM [new]
[Success] X Get MySQL stats/mysql sorts IM [new]
[Success] X Get MySQL stats/mysql temporary Objects IM [new]
[Success] X Get MySQL stats/mysql Network traffic IM [new]
[Success] X Get MySQL stats/innodb Buffer Pool Activity IM [new]
[Success] X Get MySQL stats/innodb I/o Pending IM [new]
[Success] X Get MySQL stats/innodb Log IM [new]
[Success] X Get MySQL stats/mysql binary/relay Logs IM [new]
[Success] X Get MySQL stats/innodb transactions IM [new]
[Success] X Get MySQL stats/mysql Files and Tables IM [new]
[Success] X Get MySQL stats/mysql Threads IM [new]
[Success] X Get MySQL stats/mysql processlist IM [new]
[Success] X Get MySQL stats/mysql Transaction Handler IM [new]
[Success] X Get MySQL stats/mysql handlers IM [new]

。。。。。。

When adding Divice, the template selects "X DB Server HT", the SNMP version is 2, the other does not have to be modified, save saves

Create a graphic: "Create Graphs for this Host" and you will see twenty or thirty options that you can monitor. When "Create" is selected, wait a minute. Check the logs.

If there is an error like the following, and there is no data below the graph

05/02/2015 09:20:02 am-cmdphp:poller[0] host[4] ds[39] Warning:result from CMD not valid. Partial result:could not open input
05/02/2015 09:20:02 am-cmdphp:poller[0] host[4] ds[40] Warning:result from CMD not valid. Partial result:could not open input

Click "Console"---"Settings"----"path" to see if the following "Spine poller File path" is green, if it is red, you did not install the appropriate package, execute "sudo apt-get Install cacti-spine "Installing spine.

After installation, click "Console"---"Settings"----"Poller", find "poller Type", select "Spine", save it.

After five minutes, there will be figures.

Cacti adding a MySQL monitor template