• Welcome to The Network People Support Forums. Please login or sign up.

Pulling data from MySQL

Started by Marc, May 05, 2005, 01:50:37 PM

Previous topic - Next topic

Marc

Hey there!

Trying to get rrdutil to make pretty graphs for MySQL (everything else works) but not having much luck.

mysqlstatus.pl seems to be functional

/usr/local/sbin/mysqlstatus.pl "type"
mysql_select:3549449:mysql_changedb:729590:mysql_update:9733 55:mysql_insert:257844:mysql_delete:213606

/usr/local/sbin/mysqlstatus.pl "queries"
mysql_queriessec:33509946:mysql_connections:740738:mysql_slo wqueries:12

but, no result on the graph side. This is as root.

Can someone point me at what I'm missing from this info?

Thanks!
Marc

Marc

Doh! Just popped to life!

I set perms on the root .my.cnf to 744. What user is it looking to run as if not root?

Sure looks like it's running as root.
184 root       2   0  4112K  2976K select   8:12  0.00%  0.00% snmpd
root  63301 41.7  2.4 12860 12380  p0  R+    8:26PM   0:01.35 /usr/bin/perl

Thanks!
Marc

danone