The MySQL Graph Collection - Version 2.0!

[ottob]

Hi,

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

Otto

[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 ), that whould result in using the Make per 5 Minutes CDEF.
yes, I DID study physics
Reinhard

[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

[gandalf]

I was referring to your post

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]

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]

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]

Where do you enter the mysql login information!? i can't find the fields anywhere!

[ottob]

hi,

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

Otto

[wiz8291]

something very wrong here

data sources keep dissapearing on me!

[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]

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


RRDTool Says:

ERROR: invalid y-grid format


Any ideas?

[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]

That worked great, thanks very much!

[BSOD2600]

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]

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