返回
-
标题
What MySQL cartridge Rules are available? -
说明
What MySQL cartridge and agent rules are available out of the box? -
解决办法
Authentication Errors
Alert if the number of authentication errors exceed a defined threshold as a percentage of total connection attempts.
Blocked Transaction Alarm Generator
Alert if a transaction has been waiting for a long time to complete.
Concurrent Queries Running
Alert if there are too many active queries.
Database Connectivity
Alert if a connection to the MySQL database cannot be established.
Galera Cluster Health
Alert if not all nodes in the Galera cluster are available.
Galera Node Disconnected
Alert if the MySQL server is disconnected from the Galera cluster.
Galera Node EVS Latency
Alert if the average EVS latency has been too high.
Galera Node Flow Control Paused
Alert if the percentage of time flow control has been paused on the MySQL server has been too high recently.
Galera Node Not Ready
Alert if the MySQL server has not been ready to accept queries recently.
Galera Overloaded Receive Queue
Alert if the average size of the Galera received queue on the MySQL server has been too high.
Galera Overloaded Send Queue
Alert if the average size of the Galera send queue on the MySQL server has been too high.
High Avg Wait Time for Statement
Alert if the average wait time for an instance of a statement is high compared to its previous average.
High Percentage of Compression Failures
Alert if the percentage of compression failures for a given page size is too high.
High Percentage of Connection Failures
Alert if the percentage of successful connections to the MySQL Server is too low.
High Percentage of Index Compression Failures
Alert if the percentage of compression failures for an index is too high.
Inefficient Sort
Alert if any query sort operations are exhibiting inefficient behavior
InnoDB Buffer Pool Hit Rate
Alert if the InnoDB Buffer Pool hit rate is too low.
InnoDB Cluster Health
Alerts when at least one node is down with increasing severity when cluster stability is in jeopardy.
Key Buffer Hit Rate
Alert if the key buffer hit rate is too low.
Long Running Query
Alert on any long running queries.
MySQL Alarm Email Forwarder
Forwards alarms from the MySQL for Foglight cartridge to email when they fire.
MySQL Cleared Alarm Email Forwarder
Forwards alarms from the MySQL for Foglight cartridge to email when they clear.
MySQL-EmailNotification_Rule_General
Sends email notifications for configured alarm severities.
MySQL Server Running Out of Disk Space
Alert if the database server's host will run out of disk space soon given the current database growth rate.
Non-Authentication Errors
Alert if non-authentication errors exceed a defined threshold as a percentage of total connection attempts.
Query Cache Hit Rate
Alert if the query cache hit rate is too low.
Query Cache Undersized
Alert if there are any query cache low memory prunes.
Query Waiting For Table Lock
Alert on queries waiting for a long time on a table lock.
Replication Server Times Out of Sync
Alert if the clocks on the replication servers monitored by the MySQL server are out of sync.
Replication Slave Behind Master
Alert if a replication slave is falling behind the master.
Replication Slave Connection Unavailable
Alert if a replication slave is unreachable by the Foglight Agent.
Replication Slave I/O in Failed State
Alert if a replication server is either reconnecting or waiting to reconnect after a disconnection event.
Replication Slave I/O Thread Not Running
Alert if the Slave IO Thread for a Replication Slave server is either not running or not connected to a replication master
Replication Slave SQL Thread Not Running
Alert if the Slave SQL Thread for a Replication Slave server is not running.
Replication Slave SQL Thread Not Running
Alert if a slave is falling behind the master.
Slave I/O in Failed State
Alert if the SlaveIOState for the MySQL server is either reconnecting or waiting to reconnect after a disconnection event.
Slave I/O Thread Not Running
Alert if the Slave IO Thread for the MySQL server is either not running or not connected to a replication master.
Slave SQL Thread Not Running
Alert if the Slave SQL Thread for a Slave server is not running.
Slow Connections
Alert if it is taking a long time to connect.
Slow Query Average Execution Time
Alert if the average execution time for queries written to the slow query log is too long.
Slow Query Max Execution Time
Alert if the maximum execution time for queries written to the slow query log is too long.
Table Scans Excessive
Alert if the MySQL server does not appear to be using indexes efficiently.
Tablespace Utilization
Alert if the amount of tablespace left in an InnoDB database that does not have auto extend enabled is low.
Thread Cache Not Enabled
Alert if the Thread Cache is not enabled.
Thread Pool Hit Rate
Alert if the Thread Pool hit rate is too low.
Too Many Sleeping Connections
Alert if the MySQL server has too many sleeping connections.
Transaction Purge Lag
Alert if the Transaction Purge Lag is too high.
Unflushed Log Buffer
Alert if percentage of entries in the log buffer waiting to be flushed to disk is too high.
Used Connections Reaching Limit
Alert if the number of connections currently in use for a MySQL server is too high as a percentage of the maximum connections allowed. -
其他信息
This Knowledgebase article is current as of the 6.0.1.10 MySQL cartridge