Xaprb

Stay curious!

Archive for the ‘graphing’ tag

MySQL Cacti templates version 1.1.1 released

with 13 comments

I’ve released version 1.1.1 of the MySQL Cacti templates I develop. The new templates work around more Cacti limitations, including the limitation on the length of the data returned from the poller script. There’s also a new graph and many other niceties since the last release.

Read the rest of this entry »

Written by Xaprb

October 15th, 2008 at 11:21 pm

Posted in SQL, Tools

Tagged with , , ,

Would Tufte approve of mixing units on a graph?

with 8 comments

I’ve created a set of Cacti templates for graphing stats about MySQL. While these were based on several other people’s work, there are many improvements. One of them in particular I want to bring up, and I’ll go so far as to say it ought to be a “best practice” for graphing. That is, don’t mix units on a graph.

Read the rest of this entry »

Written by Xaprb

October 9th, 2008 at 9:58 pm

Screenshots of improved MySQL Cacti templates

with 15 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