Solved

enable munin to monitor mysql

Posted on 2011-09-28
1
542 Views
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.
#
#

[mysql*]
#env.mysqlopts -u someuser

[exim*]
group mail

[cps*]
user root

[apt]
user root

[vlan*]
user root

[postfix*]
user root

Open in new window

0
Comment
Question by:ee-gd
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 35

Accepted Solution

by:
torimar earned 500 total points
ID: 36716271
Try:

[mysql*]
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')
0

Featured Post

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Linux users are sometimes dumbfounded by the severe lack of documentation on a topic. Sometimes, the documentation is copious, but other times, you end up with some obscure "it varies depending on your distribution" over and over when searching for …
I. Introduction There's an interesting discussion going on now in an Experts Exchange Group — Attachments with no extension (http://www.experts-exchange.com/discussions/210281/Attachments-with-no-extension.html). This reminded me of questions tha…
Learn how to get help with Linux/Unix bash shell commands. Use help to read help documents for built in bash shell commands.: Use man to interface with the online reference manuals for shell commands.: Use man to search man pages for unknown command…
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

733 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