Working with Rules

The MySQL cartridge provides a comprehensive set of preconfigured rules designed to monitor various aspects of MySQL server performance and health. You can modify these rules, including changing default threshold values. For more details, refer to Working with alarms templates or contact Quest Software PSO.

This section describes the following rules:

Authentication Errors

Alerts when the percentage of authentication errors exceeds a defined threshold relative to total connection attempts.

Blocked Transaction Alarm Generator

Alerts when a transaction has been waiting too long to complete.

Concurrent Queries Running

Alerts when the number of active queries exceeds the defined limit.

Database Connectivity

Alerts when a connection to the MySQL database cannot be established.

Galera Cluster Health

Alerts when not all nodes in the Galera cluster are available.

Galera Node Disconnected

Alerts when a MySQL server is disconnected from the Galera cluster.

Galera Node EVS Latency

Alerts when the average EVS latency is too high.

Galera Node Flow Control Paused

Alerts when the percentage of time flow control is paused exceeds acceptable levels.

Galera Node Not Ready

Alerts when a MySQL server is not ready to accept queries.

Galera Overloaded Receive Queue

Alerts when the average size of the Galera receive queue is too high.

Galera Overloaded Send Queue

Alerts when the average size of the Galera send queue is too high.

High Avg Wait Time for Statement

Alerts when the average wait time for a statement instance significantly increases compared to its historical average.

High Percentage of Compression Failures

Alerts when the percentage of compression failures for a specific page size is too high.

High Percentage of Connection Failures

Alerts when the success rate of connections to the MySQL server is too low.

High Percentage of Index Compression Failures

Alerts when the index compression failure rate is too high.

Inefficient Sort

Alerts when query sort operations are inefficient.

InnoDB Buffer Pool Hit Rate

Alerts when the InnoDB Buffer Pool hit rate falls below acceptable levels.

InnoDB Cluster Health

Alerts when one or more nodes in an InnoDB cluster are down, with increasing severity for greater instability.

Key Buffer Hit Rate

Alerts when the key buffer hit rate is too low.

Long Running Query

Alerts for queries that exceed a specified execution time.

MySQL-EmailNotification_Rule_General

Sends email notifications for alarms with specified severities.

MySQL Server Running Out of Disk Space

Alerts when the database server is at risk of running out of disk space based on current growth rates.

Non-Authentication Errors

Alerts when the percentage of non-authentication errors exceeds the defined threshold.

Query Cache Hit Rate

Alerts when the query cache hit rate is too low.

Query Cache Undersized

Alerts when query cache is pruned due to low memory.

Query Waiting For Table Lock

Alerts when queries wait too long for table locks.

Replication Server Times Out of Sync

Alerts when replication servers' clocks are out of sync.

Replication Slave Behind Master

Alerts when a replication slave lags behind the master.

Replication Slave Connection Unavailable

Alerts when a replication slave cannot be reached by the agent.

Replication Slave I/O in Failed State

Alerts when the replication server’s I/O state is reconnecting or waiting to reconnect.

Replication Slave I/O Thread Not Running

Alerts when the I/O thread for a replication slave server is not running.

Replication Slave SQL Thread Not Running

Alerts when the SQL thread for a replication slave server is not running.

Slow Connections

Alerts when connections take too long to establish.

Slow Query Average Execution Time

Alerts when the average execution time for slow queries exceeds acceptable thresholds.

Slow Query Max Execution Time

Alerts when the maximum execution time for slow queries exceeds acceptable thresholds.

Table Scans Excessive

Alerts when the MySQL server does not utilize indexes efficiently.

Tablespace Utilization

Alerts when available tablespace is low in an InnoDB database without auto-extend enabled.

Tablespace Utilization - Basic Table Collection

Alerts for agents using basic table collection when tables do not persist as topology objects.

Tablespace Utilization - Basic Table Collection - Purge Alarms

Removes alarms triggered by basic table collection rules if they are not re-triggered within four hours.

Thread Cache Not Enabled

Alerts when the thread cache is disabled.

Thread Pool Hit Rate

Alerts when the thread pool hit rate is too low.

Too Many Sleeping Connections

Alerts when the server has too many idle connections.

Transaction Purge Lag

Alerts when the transaction purge lag exceeds acceptable levels.

Unflushed Log Buffer

Alerts when the percentage of unflushed log buffer entries is too high.

Used Connections Reaching Limit

Alerts when the percentage of used connections approaches the maximum limit.