I’m sure that most people have at least one of the tools listed in Ronald Bradford’s article: Monitoring MySQL Options. Many of these tools, such as Nagios and Cacti, also monitor the operating system. However, in the same way that a quick look at sar‘s output can give you some insight on the OS, with MySAR you can do the same for the MySQL server. This is especially useful when it is not possible to access a monitoring tool’s graphic interfaces.
What Was Going On Around 2:30pm?
This is a question a customer asked us. To answer it we ran MySAR
for a few days and queried the results for analysis. Looking at
the data, we determined that the number of INSERT
operations was significantly higher than any …