• questions or queries?

    November 13, 2009

    I've hit a recent change which took me by surprise. I was used to checking for the 'questions' global status variables to see the total amount of queries the server performs. So, for example, I could run com_select/questions to learn the SELECT ratio out of all queries. Apparently, as of 5.0.72-5.0.76 & 5.1.31 this has […]

  • Performance analysis with mycheckpoint

    November 12, 2009

    mycheckpoint (see announcement) allows for both graph presentation and quick SQL access to monitored & analyzed data. I'd like to show the power of combining them both. InnoDB performance Taking a look at one of the most important InnoDB metrics: the read hit ratio (we could get the same graph by looking at the HTML […]

  • Replication analysis with mycheckpoint

    November 11, 2009

    I would like to show how mycehckpoint (see announcement) can be put to use for analyzing various replication metrics. Lagging slaves A slave has been monitored. Monitoring started at a time when it was way behind master (about two days lag), but it has since caught up. This can be easily verified by the following […]

  • Announcing mycheckpoint: lightweight, SQL oriented monitoring for MySQL

    November 10, 2009

    I'm proud to announce mycheckpoint, a monitoring utility for MySQL, with strong emphasis on user accessibility to monitored data. mycheckpoint is a different kind of monitoring tool. It leaves the power in the user's hand. It's power is not with script-based calculations of recorded data. It's with the creation of a view hierarchy, which allows […]

  • SQL multi line chart

    November 3, 2009

    Time for another charting SQL query. I wish to present a single-query generated multi-line/area chart. I'll walk through some of the steps towards making this happen. By the end of this post I'll present some real-data charts, area charts and colored charts. +---------+-----------------------------------------------------------------------------------+ | y_scale | chart                                                                             | +---------+-----------------------------------------------------------------------------------+ | 1       | ****---------#######----------------------------------------*******--------###### | | […]

 
Powered by Wordpress and MySQL. Theme by openark.org