Cacti (home)ForumsDocumentation
Cacti: offical forums and support
It is currently Fri Dec 15, 2017 8:39 pm

All times are UTC - 5 hours




Post new topic Reply to topic  [ 33 posts ]  Go to page Previous  1, 2, 3
Author Message
 Post subject: Re: Update The MySQL Graph Collection - Version 2.5.0!
PostPosted: Tue Aug 27, 2013 7:25 am 
Offline

Joined: Sun Nov 28, 2010 7:53 am
Posts: 3
I'm trying to interpret the connections graph. The graph seems to have a Y axis of 0-2. On some servers 0-3. It never goes above that.

Meanwhile, mysqltuner.pl says that Highest connection usage is 100% (20 out of 20).

I know that the Connections query returns a counter, so is the Y axis value on the graph connections per minute? Connections per 600 seconds?

What I'd really like to know is how many of the configured connections are in use at any given time.

All suggestions welcome.

Thanks, Ed Greenberg


Top
 Profile  
 
 Post subject: Re: UpdateÑ The MySQL Graph Collection - Version 2.5.0!
PostPosted: Thu Apr 13, 2017 8:17 am 
Offline
Cacti User
User avatar

Joined: Mon Oct 02, 2006 1:22 pm
Posts: 195
Location: Belgium
Are these still available anywhere ?

_________________
Joris.
http://www.routerjanitor.com


Top
 Profile  
 
 Post subject: Re: UpdateÑ The MySQL Graph Collection - Version 2.5.0!
PostPosted: Sat Oct 21, 2017 4:32 am 
Offline

Joined: Sat Oct 21, 2017 3:54 am
Posts: 1
Hello everyone

I am mounting this collection of graphics for mysql and I am having some problems that I do not know why it is due.
Graphs do not output data.

In the log output this error

Code:
10/21/2017 09:00:02 AM - CMDPHP: Poller[0] Host[3] DS[51] CMD: /usr/bin/php /usr/share/cacti/site/scripts/mysql_stats.php traffic xx.xx.xx.xx:3306 cacti_stats password, output: U
10/21/2017 09:00:02 AM - CMDPHP: Poller[0] Host[3] DS[51] WARNING: Result from CMD not valid. Partial Result: U


and when doing the tests from the console gives me this

Code:
/usr/bin/php /usr/share/cacti/site/scripts/mysql_stats.php thread xx.xx.xx.xx:3306 cacti_stats password
PHP Notice: Undefined offset: 5 in /usr/share/cacti/site/scripts/mysql_stats.php on line 26
PHP Fatal error: Uncaught Error: Call to undefined function mysql_connect() in /usr/share/cacti/site/scripts/mysql_stats.php:28
Stack trace:
#0 {main}
thrown in /usr/share/cacti/site/scripts/mysql_stats.php on line 28


I have reviewed everything and this is correct, I access mysql from the console with the user

Code:
mysql -u cacti_stats -h xx.xx.xx.xx -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2591643
Server version: 5.5.42 MySQL Community Server (GPL)

Copyright (c) 2000, 2014, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>


SHOW STATUS; and SHOW VARIABLES; show data

Cacti Version 0.8.8f

some idea to solve it

Thanks and sorry for my english


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 33 posts ]  Go to page Previous  1, 2, 3

All times are UTC - 5 hours


Who is online

Users browsing this forum: No registered users and 3 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  

Protected by Anti-Spam ACP Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group