enable munin to monitor mysql

Posted on 2011-09-28
Medium Priority
Last Modified: 2012-05-12
I red here http://blog.jploh.com/2007/06/14/how-to-install-munin-on-centos/ that

If your root user has a password (or want to use a different user), edit the plugin configuration file in /etc/munin/plugin-conf.d/munin-node and uncomment line 16 by removing the leading hash (#). Then change the parameters that will be used when mysqladmin is run.

this is the file in question - what do I need to change to allow munin to collect that info?

# This file contains configuration options for the plugins. Three
# options are understood by munin-node itself:
#       user <user>         # Set the user to run the plugin as
#       group <group>       # Set the group to run the plugin as
#       command <command>   # Run <command> instead of the plugin. %c
#                             expands to what would normally be run.
#   env.<variable>      # Sets <variable> in the plugin's environment, see the
#                         individual plugins to find out which variables they
#                         care about.

#env.mysqlopts -u someuser

group mail

user root

user root

user root

user root

Open in new window

Question by:ee-gd
1 Comment
LVL 35

Accepted Solution

torimar earned 2000 total points
ID: 36716271

env.mysqlopts -u root -p[password]

Open in new window

Replace [password] by the pass of your MySQL root user.
(Omit the brackets and make sure to not leave a blank space after '-p')

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

In this article, we’ll look at how to deploy ProxySQL.
Article by: Tammy
MySQLTuner is a script written in Perl that allows you to review a MySQL installation quickly and make adjustments to increase performance and stability. The current configuration variables and status data is retrieved and presented in a brief forma…
Learn several ways to interact with files and get file information from the bash shell. ls lists the contents of a directory: Using the -a flag displays hidden files: Using the -l flag formats the output in a long list: The file command gives us mor…
Connecting to an Amazon Linux EC2 Instance from Windows Using PuTTY.

588 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question