'Monitoring' Tag

• mycheckpoint revision 231 released

  May 23, 2013

  A new release for mycheckpoint: lightweight, SQL oriented MySQL monitoring solution. If you're unfamiliar with mycheckpoint, well, the one minute sales pitch is: it's a free and open source monitoring tool for MySQL, which is extremely easy to install and execute, and which includes custom queries, alerts (via emails), and out of the box HTTP [...]

  posted in MySQL by shlomi

• MySQL monitoring: storing, not caching

  February 22, 2012

  I've followed with interest on Baron's Why don’t our new Nagios plugins use caching? and Sheeri's Caching for Monitoring: Timing is Everything. I wish to present my take on this, from mycheckpoint's point of view. So mycheckpoint works in a completely different way. On one hand, it doesn't bother with caching. On the other hand, [...]

  posted in MySQL by shlomi

• Announcing common_schema: common views & routines for MySQL

  July 13, 2011

  Today I have released common_schema, a utility schema for MySQL which includes many views and functions, and is aimed to be installed on any MySQL server. What does it do? There are views answering for all sorts of useful information: stuff related to schema analysis, data dimensions, monitoring, processes & transactions, security, internals... There are [...]

  posted in MySQL by shlomi

• mycheckpoint (rev 208): aggregation tables, enhanced charting, RPM distribution

  November 8, 2010

  Revision 208 of mycheckpoint, a MySQL monitoring solution, has been released. New and updated in this revision: Aggregation tables: aggregated data makes for fast reports on previously slow queries. Enhanced charting: interactive charts now present time stamps dynamically (see demo); "Zoom in" charts are available (see demo) on mycheckpoint's HTTP server. RPM distribution: a "noarch" [...]

  posted in MySQL by shlomi

• mycheckpoint (rev. 190): HTTP server; interactive charts

  September 7, 2010

  Revision 190 of mycheckpoint, a MySQL monitoring solution, has been released. New and updated in this revision: HTTP server: mycheckpoint can now act as a web server. Point your browser and start browsing through HTML reports. See mock up demo. Interactive charts: HTML line charts are now interactive, presenting with accurate data as you move [...]

  posted in MySQL by shlomi

• mycheckpoint (rev. 170): improved custom queries; local charting; page/swap I/O monitoring; improved HTML reports

  July 16, 2010

  Revision 170 of mycheckpoint, a MySQL monitoring solution, has been released. New and updated in this revision: Improved custom queries: lifting of limitations from previous, introductory revision; better HTML presentation Local, inline charting: no rendering of Google Charts, unless explicitly requested. All charts are now rendered locally using JavaScript. No data is now sent over [...]

  posted in MySQL by shlomi

• mycheckpoint (rev. 132): custom monitoring, custom charts, process list dump

  June 4, 2010

  Revision 132 of mycheckpoint has been released. New and updated in this revision: Custom monitoring: monitoring & charting for user defined queries HTML reports for custom monitoring Process list dump upon alert notifications Custom monitoring & charts Custom monitoring allows the user to supply with a query, the results of which will be monitored. That [...]

  posted in MySQL by shlomi

• mycheckpoint (Rev. 118): alerts, email notifications and more

  March 25, 2010

  Revision 118 of mycheckpoint has been released. New and updated in this revision: Conditional alerts Email notifications Revised HTML reports, including 24/7 reports. Updated documentation With this new revision mycheckpoint turns into a monitoring solution for MySQL. One can now: Store measure metrics Query for raw, aggregated or digested metrics Generate charts for selected metrics [...]

  posted in MySQL by shlomi

• Things to monitor on MySQL, the user's perspective

  March 10, 2010

  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. [...]

  posted in MySQL by shlomi

• Static charts vs. interactive charts

  March 2, 2010

  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 [...]

  posted in MySQL by shlomi