Chapter 9. Storage Engine Monitoring

Now that you know when your servers are performing well (and when they aren’t), how do you know how well your storage engines are performing? If you are hosting one or more transactional databases or need your storage engine to perform at its peak for fast queries, you will need to monitor the storage engines. In this chapter, we discuss advanced monitoring, focusing on monitoring and improving storage engine performance, by examining the two most popular storage engines: MyISAM and InnoDB.

Having multiple interchangeable storage engines ...

Get MySQL High Availability now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.