Measures to be taken when MySQL graphs are not displayed in Munin

It was good until I relocated the new server, but when I notice itMuninIt turns out that only MySQL relation is not displayed at all in the graph rendered with. If you look closely you can not get the values ​​themselves, the date and time on the bottom right of the graph has not been updated ......

I wrote it before.Measures in articlesI will not take any action at all and it was a bit frustrating but I finally succeeded in displaying the MySQL graph at the end of the struggle.

So, how to display the graph of MySQL is explained below.
The content of each plugin is just a script fileso,"/ Usr / share / munin / plugins /There is. After following the process of opening MySQL related plug-in file in this directory and obtaining MySQL value, it turned out that basically it got the value by throwing the following command.

Mysqladmin extended-status

However, even if you enter this command after logging in with SSH, an error occurrence and value can not be acquired. As a result of examination, it turned out that it required a user name and password.

Display the status of MySQL server: MySQL reverse lookup reference

Usage example (when password is set)
Mysqladmin extended-status -u user name-p

So, if the user name is "root" and the password is "hogehoge", it becomes as follows.

Mysqladmin extended-status -u root-phogehoge

Then there was no error and I was able to get the value properly. In other words, you can set this command to be thrown by MySQL plugin. "/etc/munin/plugin-conf.d/munin-nodeOpen and set as follows.

[Mysql *]
Env.mysqlopts -u root-phogehoge

Complete by restarting Munin by entering the following command.

/etc/init.d/munin-node restart

In the control panelCPanel and WHMIf you are using Munin from, it seems that the graph will be displayed if you set it like the following article.

Fix for Munin MySQL Monitoring Plugin Graph Not Showing or Blank >> My Digital Life

Munin can also run munin - node on Windows by running the following software.

Jory's Website

HowToMonitorWindows - Munin - Trac

It is really useful ....