MySQL Monitoring 101

At the 2009 MySQL Conference and Expo I presented to a full room on MySQL Monitoring 101.

This presentation focused on the following four goals.

  • Know what to monitor
  • Know how you can monitor
  • Learn practices to diagnose problems
  • Have a foundation of historical information

Updated 09/18/09
You can also find additional materials at:

Comments

  1. says

    I’d like to note LogicMonitor as another ‘additional product’. LogicMonitor provides all the monitoring you mention as desirable – OS, disk, network, MySQL specific (query cache tuning recommendations, index efficiency, innodb and/or myisam specific monitoring – all graphed and alerted on).
    It also provides the “What’s Missing” – application specific metrics.
    (It can easily pull data from any sql query, and graph and/or alert on it – as it can pull data from any web page, or JMX Mbean, or custom script, etc.)

    And, except for the application specific metrics, it’s all configuration free. (It will detect all physical disks, all filesystems, if a database is a slave, etc, etc.)

  2. says

    Another “Additional” product to list – http://www.LogicMonitor.com/ – does complete and automatic monitoring of MySQL (query cache hit rate; detects storage engines in use and monitors appropriately; detects slaves;, etc) but also the rest of the OS, storage, hardware, and all other apps that hit the DB.
    Maybe we’ll see you at the MySQL conference this year!