Working on mycheckpoint, I have the intention of adding custom monitoring. That is, letting the user define things to monitor. I have my own thoughts, I would be grateful to get more input!
What would the user want to monitor?
Monitoring for the number of SELECT statements per second, InnoDB locks, slave replication lag etc. is very [...]
I’m having my usual fun with charts. Working on mycheckpoint, I’ve generated monitoring charts using the Google Chars API. But I’ve also had chance to experiment and deploy interactive charts, JavaScript based. In particular, I used and tweaked dygraphs.
I’d like to note some differences in using charts of both kinds. And I think it makes [...]
Revision #88 of mycheckpoint is released. In this revision:
Disk space monitoring
Improved charting
Enhanced auto-deploy
And more…
Disk space monitoring
mycheckpoint now monitors (on Linux only) three mount points:
The “/” (root) mount point
The datadir mount point
The tmpdir mount point
It may well be the case that two of the above (or perhaps all three of them) share the same mount point. [...]
Revision 76 of mycheckpoint comes with quite a few improvements, including:
OS monitoring (CPU, load average, memory)
Auto-deploy
Improved charting
Brief HTML reports
24/7 charts
OS Monitoring
When monitoring the local machine, mycheckpoint now monitors CPU utilization, load average, memory and swap space.
This only applies to the Linux operating system; there is currently no plan to work this out for other operating [...]
Rev. 57 of mycheckpoint has been released and is available for download.
New and updated in this revision:
Remote host monitoring
Improved charting
Flexible charting
Fix to questions vs. queries issues
Remote host monitoring
It is now possible to monitor one host, while writing into another. Either or both could be remote hosts:
mycheckpoint –host=localhost –monitored-host=192.168.10.178
The above monitors the MySQL server on 192.168.10.178, [...]
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 changed. A [...]
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 report):
SELECT innodb_read_hit_percent [...]
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 chart:
The above [...]
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 the [...]