Extended Monitoring Guide

1. About

MySqlMonitor provides a method for pulling performance metrics from the MySQL database server directly into Zenoss without requiring the use of an agent. This is accomplished by using the MySQL client library to connect to the database remotely.

The following metrics are collected and graphed for MySQL server:

  • Command Statistics (SELECT, INSERT, UPDATE, DELETE)

  • Select Statistics (Scan, Range Check, Range Join, Full Join)

  • Handler Statistics (Keyed and Unkeyed Reads, Writes, Updates, Deletes)

  • Network Traffic (Received and Sent)