'Monitoring' Tag

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

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

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

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

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

  • mycheckpoint (rev. 88): mount points monitoring, improved charting, enhanced auto-deploy

    February 10, 2010

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

  • mycheckpoint rev. 76: OS monitoring, auto deploy, brief HTML and 24/7 reports

    January 5, 2010

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

  • New and noteworthy in mycheckpoint (rev. 57)

    December 16, 2009

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

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

 
Powered by Wordpress and MySQL. Theme by openark.org