Alerts (MySQL)

The Management Pack for MySQL pulls MySQL database health indicators and displays them in vRealize Operations as alerts. The critical levels of each alert are closely mapped from MySQL to vROps. See the table below for the list of alerts available in the Management Pack.

Name	Description	Recommendation
Buffer Pool Wait Free is Higher than Normal	The number of times waiting for a free buffer is higher than normal.	Make sure that the memory buffer is correctly configured for the number of writes being performed.
Number of Aborted Connections is Higher than Normal	The number of aborted connections are higher than normal. It is possible that clients are trying to connect and failing.	Ensure that clients have the right privileges/credentials, and look into possible external attacks on the server.
Number of Spin Loop Rounds are Higher than Normal	rwlock spin loop rounds from exclusive latch request are higher than normal. It is possible that significant CPU resources are being wasted.	Consider reducing the spin delay.
Number of Unused Indexes are Higher than Normal	There are a large number of unused indexes. This can hurt the overall database performance.	Consider removing some of the unused indexes.
Total Wait Times of All Operations Higher than Normal	Total Wait Times of All Operations Higher than Normal	Verify table indexes are appropriate for the current operations.
Read Wait Times are Higher than Normal	Read Wait Times are Higher than Normal	Verify table indexes are appropriate for the current operations.
Write Wait Times are Higher than Normal	Write Wait Times are Higher than Normal	Verify table indexes are appropriate for the current operations.
Fetch Wait Times are Higher than Normal	Fetch Wait Times are Higher than Normal	Verify table indexes are appropriate for the current operations.
Insert Wait Times are Higher than Normal	Insert Wait Times are Higher than Normal	Verify table indexes are appropriate for the current operations.
Update Wait Times are Higher than Normal	Update Wait Times are Higher than Normal	Verify table indexes are appropriate for the current operations.
Delete Wait Times are Higher than Normal	Delete Wait Times are Higher than Normal	Verify table indexes are appropriate for the current operations.