The MySQL Graph Collection - Version 2.0!

Templates, scripts for templates, scripts and requests for templates.

Moderators: Moderators, Developers

Post Reply
Author
Message
undertoe
Posts: 10
Joined: Wed May 19, 2004 7:34 pm
Contact:

#166 Post by undertoe » Mon Sep 06, 2010 9:23 am

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.
rixxie wrote: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
Cacti User
Posts: 77
Joined: Wed Apr 23, 2008 11:03 am

Re: The MySQL Graph Collection - Version 2.0!

#167 Post by Heiko » Tue Nov 02, 2010 9:31 am

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
Cacti User
Posts: 77
Joined: Wed Apr 23, 2008 11:03 am

Re: The MySQL Graph Collection - Version 2.0!

#168 Post by Heiko » Wed Nov 03, 2010 6:52 am

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
Attachments
doubles.png
doubles.png (44.75 KiB) Viewed 26168 times

ottob
Cacti User
Posts: 51
Joined: Tue Apr 27, 2004 11:43 am
Location: Duesseldorf, Germany
Contact:

Re: The MySQL Graph Collection - Version 2.0!

#169 Post by ottob » Wed Apr 06, 2011 3:00 pm

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
Posts: 5
Joined: Wed Jun 22, 2011 12:56 pm

Re: The MySQL Graph Collection - Version 2.0!

#170 Post by shanjan » Wed Jun 22, 2011 1:20 pm

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 ?

Post Reply