Re: [munin-users] mysql not showing some graphs

[Bjørn R. <bj...@ru...>]

On 12/20/2013 02:10 PM, Chad Meyers wrote:
> Yet again, another person not getting mysql graphs.  I have spend about
> a week trying to fix this, but to no avail.  That was about 3 weeks ago,
> I'd like to try again.  I can't remember all that I did, but it had a
> lot to do with editing users etc.  It should be running (but not
> working) in the default setup.
>
> All the mysql2 graphs show up with data, but all but 1 mysql graphs are
> just a 404 not found for the PNG.
>
> The graph that works it titled:  MySQL "mysql" isam/myisam table-space
> usage but all data is 0
>
> A few that do not (and are the ones I really want to see);
> - MySQL "ourshore-ca" isam/myisam table-space usage
> - MySQL "summervillefire-ca" isam/myisam table-space usage
> - MySQL "starlingdesign-ca-piwik" isam/myisam table-space usage
>
> Last I remember, checking log files, the mysql user was able to connect
> etc. (user is debian-sys-maint on localhost with ALL PRIVILEGES)
>
> This is on Ubuntu 12.04 server, Munin version 1.4.6, I also run
> Virtualmin 4.04 if that makes a difference.
>

To increase your chances of submitting a useful error report, please 
read the following articles:
http://munin-monitoring.org/wiki/HowToGetHelp
http://munin-monitoring.org/wiki/PluginDebugging
http://munin.readthedocs.org/en/latest/plugin/writing.html#debugging-the-plugin

It'd be useful if you gave some information about your setup in general, 
and also the plugins - did it come from the munin-node package, or 
elsewhere? Did you install munin and munin-node from packages, or from 
source? Do other plugins than the MySQL plugins work OK?

Do the MySQL plugins give sane results on the munin-node itself? Debug 
with munin-run, and possibly munin-run --debug as well.

Example (with munin_innodb_bpool; replace with one of your troublesome 
plugins and show the different outputs):

# munin-run mysql_innodb_bpool
# munin-run mysql_innodb_bpool config
# munin-run --debug mysql_innodb_bpool
# munin-run --debug mysql_innodb_bpool config


-- 
Bjørn