Cacti adding a MySQL monitor template

Source: Internet
Author: User
Tags mysql query

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

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.