Xaprb

Stay curious!

Screenshots of improved MySQL Cacti templates

with 10 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 , , , ,

« MySQL 6.2 is GA, but 5.1 is RC and 6.0 is alpha
Official website launched for High Performance MySQL »

10 Responses to 'Screenshots of improved MySQL Cacti templates'

Subscribe to comments with RSS or TrackBack to 'Screenshots of improved MySQL Cacti templates'.

  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

Leave a Reply