The Uptime Infrastructure Monitor MySQL Advanced Metrics monitor collects the following performance metrics from a MySQL database:
| Metric | Description |
|---|---|
Uptime | The number of seconds that MySQL has been running. |
Questions | The number of queries that have been sent to the database. |
Slow Queries | The number of queries that take longer than long_query_time to complete. |
Open Tables | The number of database tables that are opened independently by each concurrent thread. |
QPSA | The average number of queries, per second, that must be exceeded before Uptime Infrastructure Monitor generates an alert. |
Bytes Received | The number of bytes received by the server. |
Bytes Sent | The number of bytes sent by the server to all clients. |
Delayed Insert Threads | The number of delayed insert threads that must be exceeded before Uptime Infrastructure Monitor sends an alert. |
Delayed Errors | The number of delayed insert threads that had an error. |
Max Used Connections | The maximum number of connections that have been in simultaneous use because the server was started. |
Threads Connected | The maximum number of clients that can be connected to the database at any one time. |
Threads Running | The number of threads that are running, which can be used to determine whether or not the database is becoming overloaded. |
QCache Inserts | The number of queries added to the query cache. |
QCache Hits | The number of hits to the query cache (qcache_hits) to determine the number of query results taken directly from the cache instead of executing them. |
QCache Lowmem Prunes | The number of QCache_lowmem_prunes that can be deleted from the cache because of low memory. |
QCache Not Cached | The maximum number of queries that are not cached. |
QCache Free Memory | The amount of free memory for the query cache. |
QCache Free Blocks | The number of free memory blocks in query cache. |
QCache Table Blocks | The amount of query cache memory fragmentation. |