The MySQL Graph Collection - Version 2.0!

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

Moderators: Developers, Moderators

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

Post by ottob »

Hi,

these values are an average of the polling cycle, by default 5 minutes.

Otto
User avatar
gandalf
Developer
Posts: 22383
Joined: Thu Dec 02, 2004 2:46 am
Location: Muenster, Germany
Contact:

Post by gandalf »

Using cacti's defaults, you're polling your targets every 300 sec. Suppose, you'll querying a value of something, giving you the reading of 750. This value will give 750/300=2.5 as per second value (remember the units of all values you are reading!). If you'd like to have a per minute reading, simply apply the Make per Minute CDEF (guess, what it does: multiply by 60!). Others like to have to "original" value (whatever this may be, remember what Heisenberg did say some years ago :wink: ), that whould result in using the Make per 5 Minutes CDEF.
yes, I DID study physics :lol:
Reinhard
moonzar
Posts: 9
Joined: Fri Dec 09, 2005 3:00 pm

Thanks

Post by moonzar »

Suppose, you'll querying a value of something, giving you the reading of 750
Hello,

Thanks for the explanation, but a query giving a value of 750 what ? What this 750 represent in your explanation.

MoonZar
User avatar
gandalf
Developer
Posts: 22383
Joined: Thu Dec 02, 2004 2:46 am
Location: Muenster, Germany
Contact:

Re: Unit

Post by gandalf »

I was referring to your post
moonzar wrote:BTW what is a access units ?

I thought a access units was one select, one delete...

But how could we have decimal like 3.5 access units ? Does this mean a query was a half unit ? Doesn't make sense to me. Or maybe this because some query take more time to run from other ?

You could have a select who take 2.5 access unit and one who take 1 access unit.
e.g. "access units" is the "something". As ottob states above, the decimal values are a result of dividing a counter by 300 sec.
Reinhard
moonzar
Posts: 9
Joined: Fri Dec 09, 2005 3:00 pm

access unit

Post by moonzar »

Okay now i know where the decimal coming from, thanks you.

Then one access unit is really one query after all, right ?

Thanks,

MoonZar
gttommy
Posts: 25
Joined: Thu Oct 06, 2005 6:52 pm
Contact:

Post by gttommy »

Mysql 5.0 has introduced a couple of new keywords.
http://dev.mysql.com/doc/refman/5.0/en/show-status.html

So if you are using this version, you might want to modify the script so that:
SHOW STATUS/VARIABLE --> SHOW GLOBAL STATUS/VARIABLE
wiz8291
Posts: 7
Joined: Thu Mar 16, 2006 7:44 am

Post by wiz8291 »

Where do you enter the mysql login information!? i can't find the fields anywhere!
ottob
Cacti User
Posts: 51
Joined: Tue Apr 27, 2004 11:43 am
Location: Duesseldorf, Germany
Contact:

Post by ottob »

hi,

while creating an new graph, you will be asked. Otherwise you can enter/change them at the data sources.

Otto
wiz8291
Posts: 7
Joined: Thu Mar 16, 2006 7:44 am

Post by wiz8291 »

something very wrong here :(

data sources keep dissapearing on me!
jmeyerdo
Posts: 26
Joined: Mon May 02, 2005 7:11 am
Location: Dortmund, Germany

Post by jmeyerdo »

Hi!

Similar error for me like with wiz8291:

My created graphs were empty. In Debug-log I found:

Code: Select all

03/20/2006 08:05:03 AM - CMDPHP: Poller[0] Host[3] DS[125] WARNING: Result from CMD not valid.  Partial Result: Error: wrong paramet
03/20/2006 08:05:03 AM - CMDPHP: Poller[0] Host[3] DS[125] CMD: /usr/bin/php -q /usr/share/cacti/scripts/mysqli_stats.php status myhost, output: U
I had to add the mysql-user and mysql-pass to Data-Templates.
But for "MySQLi - Connections", "MySQLi - Questions" and "MySQLi - Single statistics" Cacti wants me to add an additional Status Variable.
I tried with "connections" and "questions" from the command-line. Without success.

Has anybody a tipp for me what to add as "Status Variable"?
Thanks,
kind regards,
Jen
lozzd
Posts: 30
Joined: Thu Dec 08, 2005 7:13 pm
Contact:

Post by lozzd »

A couple of the graphs are broken for me on version i.


RRDTool Says:

ERROR: invalid y-grid format


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

Post by ottob »

Hi,

i had the same problem after upgrading to cacti-0.8.6i.

Go to "Graph templates" -> "MySQL ..." and clear the "Unit Grid Value".


cheers,
Otto
lozzd
Posts: 30
Joined: Thu Dec 08, 2005 7:13 pm
Contact:

Post by lozzd »

That worked great, thanks very much!
User avatar
BSOD2600
Cacti Moderator
Posts: 12171
Joined: Sat May 08, 2004 12:44 pm
Location: USA

Post by BSOD2600 »

ottob wrote:i had the same problem after upgrading to cacti-0.8.6i.

Go to "Graph templates" -> "MySQL ..." and clear the "Unit Grid Value".
You should re-release the updated templates, so new users don't run into this problem/bug.
Linuxfreak_be
Posts: 22
Joined: Sun Sep 04, 2005 3:30 am
Location: Belgium

Post by Linuxfreak_be »

BSOD2600 wrote:
ottob wrote:i had the same problem after upgrading to cacti-0.8.6i.

Go to "Graph templates" -> "MySQL ..." and clear the "Unit Grid Value".
You should re-release the updated templates, so new users don't run into this problem/bug.
indeed pretty annoying fixing that yourself
Post Reply

Who is online

Users browsing this forum: No registered users and 3 guests