The MySQL Graph Collection - Version 2.0!

[undertoe]

Just and FYI on mysql 5+ this does the trick, if you don't do this you will see no data for most of the graphs.

If you're using MySQL5, edit mysql_stats.php and replace the following lines

Code: Select all

$result_stat = @mysql_query("SHOW STATUS");

to

Code: Select all

$result_stat = @mysql_query("SHOW GLOBAL STATUS");

and

Code: Select all

$result_var = @mysql_query("SHOW VARIABLES");

to

Code: Select all

$result_var = @mysql_query("SHOW GLOBAL VARIABLES");

This would give your graph a system wide statistics.

[Heiko]

Hi,

after removing the values from "Unit Grid Value" and changing the queries,
everything works fine. Just for understanding, what doe the values mean?

Command statistics show me 2k, are this 2000 command per second?

Connections shows me 100 m, what does that mean?

Handler statistics show 600k, same here?


or should I just ignore the letter and say its 100 connections?

[Heiko]

Hi, i ran into another problem,
When I view a mysql graph i always have a duplicate wich name ends with _apache.
When I look in the console/graph management/ there are no graphs that end with _apache.

see the image for details.


greetings

[ottob]

Hi,
Scott is maintaining these scripts now here: "The MySQL Graph Collection - Version 2.0.1!"
Please don't use this topic anymore. Many thanks! Otto

[shanjan]

Hi ,

I am only able to view graphs for Mysql-single statics and Mysql- Questions which are also blank.

Rest all the graphs shows no image option ..

I am using cacti 0.8.7g version

the script is running fine but i see following in cacti.log file :

....

06/22/2011 11:10:04 AM - CMDPHP: Poller[0] Host[2] DS[70] WARNING: Result from CMD not valid. Partial Result: bles cacti to read m
06/22/2011 11:10:04 AM - CMDPHP: Poller[0] Host[2] DS[71] WARNING: Result from CMD not valid. Partial Result: bles cacti to read m
06/22/2011 11:10:04 AM - CMDPHP: Poller[0] Host[2] DS[72] WARNING: Result from CMD not valid. Partial Result: bles cacti to read m
06/22/2011 11:10:05 AM - SYSTEM STATS: Time:4.1793 Method:cmd.php Processes:1 Threads:N/A Hosts:3 HostsPerProcess:3 DataSources:57 RRDsProcessed:39


Can someone help me on this ?