Spotlight alarms indicate when the MySQL database exceeds acceptable performance thresholds.
| Alarm | Alarm | Description |
|---|---|---|
| Buffer Pool Hit Rate alarm | The Buffer Pool Hit Rate alarm fires when the proportion of table data that can be found in the InnoDB buffer pool drops below a specified threshold. | |
| CPU Busy alarm (% CPU usage) | The CPU Busy alarm occurs when the total CPU utilization of the system exceeds a threshold. The CPU may encounter a large number of requests, or you may have un-tuned SQL, which unnecessarily uses excessive amounts of CPU. | |
| Inefficient Sort alarm (Merge per Sort) | The Inefficient Sort alarm fires when the number of temporary files created for sorts is high in comparison to the number of sorts performed. | |
| Low Free Physical RAM alarm | The Low Free Physical RAM alarm occurs when the server’s available RAM is low. | |
| Query Cache Hit Rate alarm | The Query Cache Hit Rate alarm fires when the proportion of SQL queries that can be found in the MySQL query cache drops below a specified threshold. |
© 2025 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center
