Xaprb

Stay curious!

Screenshots of improved MySQL Cacti templates

with 16 comments

I finally have some images to show you what my improved Cacti templates look like.

These aren’t a perfect demo, since for example this server doesn’t have the query cache enabled, but it should show you what I’ve done. Note, for example, that each graph is labeled with the actual values of the images drawn on it. You don’t have to guess what the values are by squinting at the graphs.

You can click on any image to go to a larger version. Enjoy:

InnoDB Buffer Pool Activity InnoDB Buffer Pool InnoDB I/O InnoDB I/O Pending InnoDB Insert Buffer InnoDB Log InnoDB Row Operations InnoDB Semaphores InnoDB Transactions MyISAM Indexes MySQL Binary/Relay Logs MySQL Command Counters MySQL Connections MySQL Files and Tables MySQL Network Traffic MySQL Query Cache MySQL Query Cache Memory MySQL Replication MySQL Select Types MySQL Sorts MySQL Table Locks MySQL Temporary Objects

Enjoy!

Written by Xaprb

May 25th, 2008 at 2:10 pm

Posted in SQL,Sys Admin

Tagged with , , , ,

«
»

16 Responses to 'Screenshots of improved MySQL Cacti templates'

Subscribe to comments with RSS

  1. These are awesome, thanks!

    Todd Troxell

    25 May 08 at 9:19 pm

  2. Where can I get these templates if you don’t mind me asking?

    Jordan Cheng

    27 May 08 at 1:28 pm

  3. just follow the link at the top of the article: http://code.google.com/p/mysql-cacti-templates/

    Xaprb

    27 May 08 at 1:46 pm

  4. I actually have the same setup for ganglia! I could / should release mine as well.

    Dathan Vance Pattishall

    27 May 08 at 6:32 pm

  5. Nice….. I might have to look at porting these to munin.

    Or I could run Cacti as munin is growing old …

    Kevin Burton

    27 May 08 at 8:12 pm

  6. Re: Kevin
    Cacti is kind of a pain for remote systems– I still prefer Munin for now. — been meaning to take a serious look at ganglia though

    Todd Troxell

    27 May 08 at 9:52 pm

  7. Last screenshot isn’t correctly linked. You will be redirected to technorati.com instead of the bigger image.

    Andreas Mauf

    23 Jun 08 at 12:29 pm

  8. That looked like a bug in WordPress or a bug in my plugin. I added another paragraph after the last image link and it worked OK.

    Xaprb

    23 Jun 08 at 1:27 pm

  9. Hm.. might be a stupid question, but how do I get those cacti and rrd thingies to work with mysql?

    Ernst

    28 Jul 08 at 2:35 pm

  10. [...] 监视图片的演示：http://www.xaprb.com/blog/2008/05/25/screenshots-of-improved-mysql-cacti-templates/ [...]

    Cacti的Mysql模板 | FeelAll

    9 Oct 08 at 11:00 am

  11. Thanks for releasing these! Just came across the link to it from the MySQL Host Template thread over in the Cacti forums. A big help!

    Michael

    Michael Biven

    7 Jan 09 at 1:13 am

  12. I see some people thinking about porting these graphs to Munin. Just want to let you know that such a port can be downloaded from http://oierud.name/~kjellm/code/

    Kjell-Magne Øierud

    13 Feb 09 at 11:44 am

  13. That’s great! I have a client who actually asked me about this and I was going to start very soon. Any chance you would be willing to move it to Google Code or similar where we can all work on it together?

    Xaprb

    13 Feb 09 at 12:23 pm

  14. Sure, it would be nice to get more people to work on it. I have moved the code to github: http://github.com/kjellm/munin-mysql/

    Kjell-Magne Øierud

    16 Feb 09 at 1:22 pm

  15. great.but i havn’t got these graphics yet.
    cacti doesn’t works well.

    lottiwang@qq.com

    15 May 09 at 2:34 am

  16. simply excellent graphs !

    Thanks a million

    Art

    Artur Ejsmont

    7 Nov 10 at 1:29 pm

Leave a Reply