Jobs for Mysql
| Control Center Jobs | Description |
|---|---|
| Availability | |
| Aborted clients | Checks the number of clients not closing the connection properly. |
| Aborted clients | Checks the number of clients not closing the connection properly. |
| Aborted connections | Checks the number of aborted client connections. |
| Aborted connections | Checks the number of aborted client connections. |
| DBMS uptime | Collects uptime statistics for the MySQL instance. |
| DBMS uptime | Collects uptime statistics for the MySQL instance. |
| DBMS uptime | Collects uptime statistics for the MySQL instance. |
| Aborted connects alert | Collects uptime statistics for the MySQL instance. |
| Maximum connections alert | Collects uptime statistics for the MySQL instance. |
| MySQLd process alert | Collects uptime statistics for the MySQL instance. |
| Capacity | |
| Database growth rate | Collects database size and visualizes the growth rate of the server. |
| Database growth rate | Collects detailed growth rate information. |
| Query cache hitrate | Shows the query cache hit rate. |
| Cluster | |
| NDB data memory usage check | NDB data memory usage check |
| NDB data node status | NDB data node status |
| InnoDB cluster status | NDB data node status |
| InnoDB cluster switch | NDB data node status |
| Replica count | NDB data node status |
| Replica delay | NDB data node status |
| Replica state | NDB data node status |
| Maintenance | |
| Framework | dbWatch engine framework job (for internal use only). Used for patching or upgrading of dbWatch engine framework. |
| Performance | |
| Binlog cache check | Checks the number of transactions that used the temporary binary log cache but that exceeded the value of binlog_cache_size and used a temporary file to store statements from the transaction. |
| Binlog cache check | Checks the number of transactions that used the temporary binary log cache but that exceeded the value of binlog_cache_size and used a temporary file to store statements from the transaction. Statistics collected from information_schema.global_status. |
| InnoDB buffer pool check | Checks the hit rate of the innodb buffer pool using performance_schema.global_status. |
| InnoDB buffer pool check | Checks the hit rate of the innodb buffer pool using information_schema.global_status. |
| Instance memory statistics | Collects instance memory statistics. |
| Instance memory statistics | Collects instance memory statistics. |
| Lock statistics | Collects lock statistics |
| Lock statistics | Collects lock statistics |
| MyISAM key cache check | Checks the hit rate of the MyISAM key cache. |
| MyISAM key cache check | Checks the hit rate of the MyISAM key cache. |
| Network statistics | This job collects the number of bytes received and sent from all clients. |
| Network statistics | This job collects the number of bytes received and sent from all clients. |
| Session load | Records the number of active and inactive sessions over time. |
| Session load | Records the number of active and inactive sessions over time. |
| Statement load | This job collects the number of statements executed by the server. Including statements executed within stored programs and statements sent to the server by clients. Values from status variables Queries and Questions (from global_status table) are used. |
| Statement load | This job collects the number of statements executed by the server. Including statements executed within stored programs and statements sent to the server by clients. Values from status variables Queries and Questions (from global_status table) are used. |
| Threads statistics | Checks the number of threads created per minute. |
| Threads statistics | Checks the number of threads created per minute. |
| Temporary table check | Shows percentage of temporary tables written to disk |
| Temporary table check | Shows percentage of temporary tables written to disk |
| Performance_licenced | |
| SQL statistics | Collects performance statistics for SQL statements. |