MySQL Expert Ronald Bradford shares valuable input in MySQL Performance Tuning, MySQL Scalability and general MySQL Help from his
two decades of working with MySQL, Oracle, Ingres and development technologies.
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:
This entry was posted
on Wednesday, April 22nd, 2009 at 7:18 pm and is filed under Databases, General, MySQL, MySQL User Conferences, Professional, mysqluc09.
You can follow any responses to this entry through the RSS 2.0 feed.
You can skip to the end and leave a response. Pinging is currently not allowed.
Leave a Reply
Thanks for the session, Ronald, I have enjoyed it.
Hi Ronald,
Can I please have the slide presentation.?
–syed
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.)
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!