Blank MySQL Graphs in Munin

From the Munin FAQ

Q: Why are the graphs for the MySQL plugin blank?

This is due to a bug in a Perl library Munin uses which causes $PATH to be lost. This again causes the plugin to not find the mysqladmin program which it needs to retrive the numbers the needed in the graphs. The solution is to hardcode the path of the program.

First locate the mysqladmin program. On most systems, the command which mysqladmin, type mysqladmin or locate mysqladmin will help you. When you find the path, enter that path in /etc/munin/plugin-conf.d/munin-node.

This is how it might look:

darkstar:~# which mysqladmin /usr/bin/mysqladmin Then, under the [mysql*] section identifier in /etc/munin/plugin-conf.d/munin-node, add the following line:

env.mysqladmin /usr/bin/mysqladmin

Found in the Munin Docs

If you found this post helpful, please consider sharing to your network. I'm also available to help you be successful with your distributed systems! Please reach out if you're interested in working with me, and I'll be happy to schedule a free one-hour consultation.