Cacti (home)ForumsRepositoryDocumentation
Cacti: offical forums and support
It is currently Fri Oct 24, 2014 5:15 am

All times are UTC - 5 hours




Post new topic Reply to topic  [ 121 posts ]  Go to page 1, 2, 3, 4, 5 ... 9  Next
Author Message
 Post subject: MySQL Host Template -- Updated on 2006-08-10
PostPosted: Sun Dec 18, 2005 8:43 pm 
Offline

Joined: Mon Dec 12, 2005 2:27 pm
Posts: 37
Location: San Francisco, USA
EDIT: 2006.02.01:

This is a tarball containing a host XML template for MySQL stats. Almost all the MySQL stats you could possibly want. Pretty thumbnail. Oooh. So pretty:

Image

Download URL is here: http://www.faemalia.net/mysqlUtils/.

. InnoDB graphs were added 2005-12-23.
. MySQL 5.0 support was added 2006-02-01.
. Graphs are logarithmic. If you don't like that, edit each graph template and uncheck the logarithmic checkbox.
. As of 2005-12-25, all data input methods are DERIVE, not COUNTER, with minimum value of 0. This way when you restart your MySQL, you won't get those ugly spikes that make your graphs useless.
. Took out most Y-axis labels. They're not accurate on almost any graph, and on the ones they are, everyone already knows what the Y-axis means anyway.

Download the file, untar it ("tar -zxvf" on Linux, read this thread for all the various Win32 programs that can deal with it). Read the README included. It's got an important note, especially if you're using polling interval of 300 seconds (you probably are).

_________________
power to the soul
belief to the people


Last edited by philovivero on Thu Aug 10, 2006 4:28 pm, edited 6 times in total.

Top
 Profile  
 
 Post subject:
PostPosted: Mon Dec 19, 2005 7:10 am 
Offline
Cacti User

Joined: Thu Oct 06, 2005 5:03 am
Posts: 298
http://www.faemalia.net/mysqlUtils/Live ... gPaper.pdf
link isnt working

looks really nice - i will try these now!

_________________
cacti rulez!


Top
 Profile  
 
 Post subject:
PostPosted: Mon Dec 19, 2005 11:53 pm 
Offline

Joined: Mon Dec 12, 2005 2:27 pm
Posts: 37
Location: San Francisco, USA
JJX wrote:
http://www.faemalia.net/mysqlUtils/LiveJournalScalingPaper.pdf
link isnt working.


Oh, sorry. Fixed it. It's just a copy of the paper available on the MySQL site about LiveJournal's back-end architecture.

Let me know if you have any input on the Cacti MySQL graphs. I'm excited to see how they work for others. Every time I look at them, I think of something I could improve.

_________________
power to the soul
belief to the people


Top
 Profile  
 
 Post subject:
PostPosted: Tue Dec 20, 2005 2:32 am 
Offline
Cacti User

Joined: Thu Oct 06, 2005 5:03 am
Posts: 298
works really nice!

i installed to 2 pcs and both worked fine

something u can add to the readme:

to make it work you have to remove the snmp community string or it will not work!!!

when i had snmp community string ("public") the host was detected as down and nothing worked.
when i removed it everything worked asap ;)


great work ;)

_________________
cacti rulez!


Top
 Profile  
 
 Post subject:
PostPosted: Wed Dec 21, 2005 12:08 am 
Offline
Cacti User
User avatar

Joined: Sun Dec 04, 2005 3:14 am
Posts: 98
how to install this template ? uncompressed file looks like a binary file instead of XML file.


Top
 Profile  
 
 Post subject:
PostPosted: Wed Dec 21, 2005 12:47 am 
Offline
Cacti User

Joined: Thu Oct 06, 2005 5:03 am
Posts: 298
read the readme ;)

its step-by-step

_________________
cacti rulez!


Top
 Profile  
 
 Post subject:
PostPosted: Wed Dec 21, 2005 3:10 am 
Offline

Joined: Tue Dec 20, 2005 10:44 pm
Posts: 6
Hi,

This template is cool, There are few things which I think could be imporved

- The graphs are missing "max" "average" "current" data for the counters above them which are quite helpful.

- The axis are marked as 1.0e+1 etc (in my case) which is kind of ugly. I have not yet found a way to fix it.

- Innodb data is mixing (yes I know it is inconvenient to dig it from SHOW INNODB STATUS)

- If somehow mysql user info is to be entered only once per host adding it for each graph is inconvenient.


Top
 Profile  
 
 Post subject:
PostPosted: Wed Dec 21, 2005 3:42 am 
Offline
Cacti User
User avatar

Joined: Sun Dec 04, 2005 3:14 am
Posts: 98
JJX wrote:
read the readme ;)

its step-by-step


Where is readme ? uncompress file is only one file call :teMySQL-cacti-20051218


Top
 Profile  
 
 Post subject:
PostPosted: Fri Dec 23, 2005 2:39 pm 
Offline

Joined: Mon Dec 12, 2005 2:27 pm
Posts: 37
Location: San Francisco, USA
RunningWave wrote:
- The graphs are missing "max" "average" "current" data for the counters above them which are quite helpful.


I tried to have those in there, but for some reason, when I put them in, I get no values. Since it's a lot of work to put them in for no values, I didn't put them in. Maybe it's a bug, maybe I did something stupid. Please feel free to add them to one or two graphs, and if it works for you, I'm sure we'd all really appreciate your help. :)

Quote:
- The axis are marked as 1.0e+1 etc (in my case) which is kind of ugly. I have not yet found a way to fix it.


Edit each graph template and uncheck the "logarithmic" checkbox.

Quote:
- Innodb data is mixing (yes I know it is inconvenient to dig it from SHOW INNODB STATUS)


Peter Zaitsev, the MySQL tuning guru, has sent me a patch to mysql_stats.php that parses out the SHOW INNODB STATUS. Now it's on my list of things to do to create graphs for all this data. If you download the current XML file, you'll notice data input methods for the various InnoDB stats! Yay Peter!

Quote:
- If somehow mysql user info is to be entered only once per host adding it for each graph is inconvenient.


It's a limitation of Cacti. I want to edit the mysql_stats.php to have a default username/password, then if your Cacti monitoring username/password is the same everywhere in your cluster, you could just not enter that information and it'd work.

But yes, I find it very annoying that for every host I add (tens) I have to type the same two values over and over. Thank goodness for Firefox and its autocomplete. On the second host and beyond, I just type <downarrow><downarrow><tab> over and over 30 times until I get down to the bottom.

_________________
power to the soul
belief to the people


Top
 Profile  
 
 Post subject:
PostPosted: Fri Dec 23, 2005 2:41 pm 
Offline

Joined: Mon Dec 12, 2005 2:27 pm
Posts: 37
Location: San Francisco, USA
dust2k wrote:
how to install this template ? uncompressed file looks like a binary file instead of XML file.


If you uncompress the file, you have a tar archive. Do "tar -xvf <filename>" or, before uncompressing, do "tar -zxvf <filename>".

_________________
power to the soul
belief to the people


Top
 Profile  
 
 Post subject: MySQL Graphs including InnoDB
PostPosted: Fri Dec 23, 2005 5:30 pm 
Offline

Joined: Mon Dec 12, 2005 2:27 pm
Posts: 37
Location: San Francisco, USA
Again, thanks to Peter Zaitsev, we have InnoDB graphing support!

[EDIT!]Removed info. See thread root post by me for all current info.[/EDIT]

Anyone who knows how to get the Current/Average/Max values onto the graph, PLEASE DO SO! Stick them on, and email me the modified XML or whatever. I'll host the file on my website.

Enjoy.

_________________
power to the soul
belief to the people


Last edited by philovivero on Sun Dec 25, 2005 5:37 pm, edited 2 times in total.

Top
 Profile  
 
 Post subject:
PostPosted: Fri Dec 23, 2005 5:35 pm 
Offline

Joined: Mon Dec 12, 2005 2:27 pm
Posts: 37
Location: San Francisco, USA
JJX wrote:
something u can add to the readme:
to make it work you have to remove the snmp community string or it will not work!!!

when i had snmp community string ("public") the host was detected as down and nothing worked. when i removed it everything worked asap ;)


That isn't necessarily true. It depends on the snmpd.conf of each of your hosts to graph. For example, our snmpd.conf files have an "rocommunity" argument that isn't public, but something else entirely (I think for security purposes).

I think by default, the "public" snmp community is what most snmpd.conf will specify...

Not sure this belongs in the README of my MySQL graphs, though. Perhaps it would be more of a Cacti FAQ.

_________________
power to the soul
belief to the people


Top
 Profile  
 
 Post subject:
PostPosted: Sat Dec 24, 2005 4:46 pm 
Offline
Cacti User

Joined: Thu Oct 06, 2005 5:03 am
Posts: 298
philovivero wrote:
JJX wrote:
something u can add to the readme:
to make it work you have to remove the snmp community string or it will not work!!!

when i had snmp community string ("public") the host was detected as down and nothing worked. when i removed it everything worked asap ;)


That isn't necessarily true. It depends on the snmpd.conf of each of your hosts to graph. For example, our snmpd.conf files have an "rocommunity" argument that isn't public, but something else entirely (I think for security purposes).

I think by default, the "public" snmp community is what most snmpd.conf will specify...

Not sure this belongs in the README of my MySQL graphs, though. Perhaps it would be more of a Cacti FAQ.


- also i have a differenet community set.
if i set any value as community in cacti mysql host seems down and no graph is being graphed!

- using the first version (only) mysql graphs are corrupted (or they should look like that?). any idea why happen this?
[ check attached image ]


Attachments:
maybe_problem.gif
maybe_problem.gif [ 19.5 KiB | Viewed 105112 times ]

_________________
cacti rulez!
Top
 Profile  
 
 Post subject:
PostPosted: Sat Dec 24, 2005 6:09 pm 
Offline
Cacti User

Joined: Thu Oct 06, 2005 5:03 am
Posts: 298
Using the new template i have these data input methods created:

Quote:
Data Input Method
[success] teMySQL - Replication [update]
[success] teMySQL - Volatile Queries [update]
[success] teMySQL - Volatile Handler [update]
[success] teMySQL - Select Queries [update]
[success] teMySQL - Select Handler [update]
[success] teMySQL - Index Usage [update]
[success] teMySQL - Query Cache [update]
[success] teMySQL - Network Usage [update]
[success] teMySQL - Sorts [update]
[success] teMySQL - Locking and Slow [update]
[success] teMySQL - Temporary Objects [update]
[success] teMySQL - Threads/Abends [update]
[success] Get SNMP Data [update]
[success] MySQL - Command statistics [update]
[success] MySQL - Handler statistics [update]
[success] teMySQL - InnoDB Row Operations [update]
[success] teMySQL - InnoDB Buffers [update]
[success] teMySQL - InnoDB Locks [update]
[success] teMySQL - InnoDB File I/O [update]


as u can see cpu & load avergae data input methods are missing (no graphs are created at all)
Also the rest graphs has no data :(

(before adding the new template i deleted the old one - the word "update" is because i added the same template twice to check what happens)

running the sctipts manually i get correct data

_________________
cacti rulez!


Top
 Profile  
 
 Post subject: JJX's Odd-looking Graph
PostPosted: Sun Dec 25, 2005 5:40 pm 
Offline

Joined: Mon Dec 12, 2005 2:27 pm
Posts: 37
Location: San Francisco, USA
That is actually the way it's supposed to look. Since it's a logarithmic graph, and 0's are not plotted (I'd love a special case where 0 was plotted at the same distance below 1e+00 as 1e+0 is plotted below 1e+01), then you get missing graph chunks wherever the result was 0.

So that's actually right.

I don't know how I could fix this. Any pointers welcome.

_________________
power to the soul
belief to the people


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 121 posts ]  Go to page 1, 2, 3, 4, 5 ... 9  Next

All times are UTC - 5 hours


Who is online

Users browsing this forum: No registered users and 6 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