2. Performance Monitoring Options

The preceding chapter discussed how essential it is to follow a well-defined, scientific process when analyzing your MySQL environment. Luckily, many automated tools, reports, and monitors are available that you can use to make your performance analysis and testing as productive and accurate as possible.

This chapter looks at two classes of performance monitoring utilities. The first section reviews MySQL’s own utilities, logs, and reports; the second section surveys operating system–specific tools.

MySQL Tools and Utilities

In the past, administrators typically used character-based tools and utilities to examine their MySQL environment. This software is still available, but ...

Get MySQL® Database Design and Tuning now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.