Metrics reference
This chapter explains how to read the generated metrics reference. Topics: 6.1 Where the reference is · 6.2 How to read a metric group · 6.3 Naming conventions
6.1 Where the reference is
The plug-in’s metric documentation is generated from the plug-in’s own target metadata, for the exact build you deploy, rather than written by hand — so it cannot drift from what the plug-in actually collects.
For this build it is the reference below, shipped alongside this guide. It covers all 116 metric groups: 105 on MySQL Database, 8 on MySQL Cluster and 3 on MySQL ClusterSet, each with its collection schedule, its columns, their display labels and units, and the default thresholds that ship. Where this guide and the reference differ on a column name, a unit or a threshold, the reference is authoritative (1.4).
Note: The reference accompanies this guide: in the repository as
user-guide-metrics-reference.md, on the documentation site asmetrics-reference.md. Either way, use the copy that matches the build you are running.
6.2 How to read a metric group
Every entry in the reference has the same shape, so once you can read one you can read all of them.
The heading gives the group’s display name, its internal name in parentheses — the name EM CLI, thresholds and the metric browser use — and its collection schedule, for example collected every 5 Min. One sentence underneath says what the group collects and where the values come from. Then comes the column table:
| Column | What it tells you |
|---|---|
| Column | The column’s internal name, in the form EM CLI and threshold commands take. A (key) marker means the column is part of the group’s key, so the group returns one row per distinct key value — per channel, per member, per table, per digest — rather than a single row. A group with no key column returns exactly one row per collection. |
| Label | The display name shown in the console. |
| Unit | The unit Enterprise Manager labels the value with, for example MICROSEC, BYTE, SECOND or PERCENTAGE. NA means the value carries no unit — a count, a state or a string. |
| Warning / Critical | The default threshold that ships for the column, with its operator. A blank cell means no default threshold, which is the normal case: 19 curated thresholds ship (7.1), and the reference also shows the three availability Status conditions, so 22 columns in the reference tables carry a default. A blank cell is not an omission and it does not stop you setting your own (7.2). |
Groups marked configuration snapshot in their heading behave differently from the rest. They collect on a 24-hour schedule into Enterprise Manager’s configuration history rather than into the metric tables, which is what makes a MySQL server’s settings comparable over time and against other servers under Enterprise → Configuration, and what the compliance rules in chapter 9 evaluate. They carry no thresholds and raise no alerts, and a (key) column in one of them means the snapshot holds several rows — one per account, for example — rather than one row of settings.
6.3 Naming conventions
Column names follow a few conventions consistently, so the name usually tells you what kind of number you are looking at.
| Suffix or pattern | Meaning |
|---|---|
_delta |
The difference since the previous collection. The server counter behind the column is cumulative since startup; the _delta column reports the activity in the interval instead, which is what a threshold can be set against. |
_pct |
A percentage, on a 0–100 scale. |
_rate |
A ratio expressed as a percentage — the buffer pool hit rates, for example, which the plug-in normalizes to percent at one decimal place. It is not a per-second figure. |
_per_sec |
A per-second rate. |
_us |
Microseconds. Statement and wait latencies are reported in microseconds throughout. |
d_ prefix |
A per-interval delta on the wait and statement digest groups, the keyed equivalent of _delta. |
*Live group |
A real-time mirror of the configuration snapshot group of the same name — the same server variables, read on demand for the console’s configuration side panels (5.1) instead of on the daily configuration schedule. Same values, different freshness. |
Note: The replication metric group reports two different boolean vocabularies.
replica_io_runningreturnsYesorNo, whilereplica_sql_runningreturnstrueorfalse. The shipped thresholds match those forms exactly (7.1); a custom threshold, compliance rule or script that reads both columns must not assume a single format.
Generated from the plug-in’s target metadata for build 24.1.9.9.0. Each metric group lists its columns, display labels, units, and the default warning/critical thresholds that ship (blank = no default threshold). Configuration snapshots are RAW metrics collected for configuration history; they do not carry thresholds. See the User Guide, chapter 6, for how to read this file.
MySQL Database (ip_mysql_database_beta)
Response (Response) — collected every 1 Min
Availability. EM derives the target’s Up/Down state from the Status column; a Status below 1 raises the target-down event.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
Status |
Status (up/down) | NA | < 1 |
Instance Info (InstanceInfo) — collected every 15 Min
Server version and installation directories (version, base directory, data directory, temp directory), read from global system variables.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
version |
Version | NA | ||
basedir |
Base Directory | NA | ||
datadir |
Data Directory | NA | ||
tmpdir |
Temp Directory | NA |
Replication Source Config (ReplicationSource) — collected every 1 Hr
Source-role replication configuration — auto-increment offsets, GTID mode, and semi-sync source settings — read from the server’s global variables. One row per server.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
auto_increment_increment |
Auto Increment Increment | NA | ||
auto_increment_offset |
Auto Increment Offset | NA | ||
enforce_gtid_consistency |
Enforce GTID Consistency | NA | ||
gtid_executed |
GTID Executed | NA | ||
gtid_executed_compression_period |
GTID Executed Compression Period | NA | ||
gtid_mode |
GTID Mode | NA | ||
gtid_next |
GTID Next | NA | ||
gtid_owned |
GTID Owned | NA | ||
gtid_purged |
GTID Purged | NA | ||
server_uuid |
Server UUID | NA | ||
rpl_semi_sync_source_enabled |
Semi-Sync Source Enabled | NA | ||
rpl_semi_sync_source_timeout |
Semi-Sync Source Timeout | NA | ||
rpl_semi_sync_source_trace_level |
Semi-Sync Source Trace Level | NA | ||
rpl_semi_sync_source_wait_no_replica |
Semi-Sync Source Wait No Replica | NA | ||
server_id |
Server ID | NA | ||
source_verify_checksum |
Source Verify Checksum | NA |
Replication Source Activity (ReplicationSourceActivity) — collected every 5 Min
Source-role replication activity — binary log cache usage, semi-sync source counters, and the current binary log file, position, and executed GTID set.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
binlog_cache_disk_use |
Binary Log Cache Disk Use | NA | ||
binlog_cache_use |
Binary Log Cache Use | NA | ||
rpl_semi_sync_source_clients |
Semi-Sync Source Clients | NA | ||
rpl_semi_sync_source_net_avg_wait_time |
Semi-Sync Source Net Avg Wait Time | MICROSEC | ||
rpl_semi_sync_source_net_waits |
Semi-Sync Source Net Waits | NA | ||
rpl_semi_sync_source_net_wait_time |
Semi-Sync Source Net Wait Time | MICROSEC | ||
rpl_semi_sync_source_no_times |
Semi-Sync Source No Times | NA | ||
rpl_semi_sync_source_no_tx |
Semi-Sync Source No Transactions | NA | ||
rpl_semi_sync_source_status |
Semi-Sync Source Status | NA | ||
rpl_semi_sync_source_timefunc_failures |
Semi-Sync Source Timefunc Failures | NA | ||
rpl_semi_sync_source_tx_avg_wait_time |
Semi-Sync Source Tx Avg Wait Time | MICROSEC | ||
rpl_semi_sync_source_tx_waits |
Semi-Sync Source Tx Waits | NA | ||
rpl_semi_sync_source_tx_wait_time |
Semi-Sync Source Tx Wait Time | MICROSEC | ||
rpl_semi_sync_source_wait_pos_backtraverse |
Semi-Sync Source Wait Pos Backtraverse | NA | ||
rpl_semi_sync_source_wait_sessions |
Semi-Sync Source Wait Sessions | NA | ||
rpl_semi_sync_source_yes_tx |
Semi-Sync Source Yes Transactions | NA | ||
com_show_binary_log_status |
Com Show Binary Log Status | NA | ||
com_show_replicas |
Com Show Replicas | NA | ||
file |
Binary Log File | NA | ||
position |
Binary Log Position | NA | ||
executed_gtid_set |
Executed GTID Set | NA |
Replication Replica Config (ReplicationReplica) — collected every 1 Hr
Replica-role replication configuration for each replication channel — source connection details, SSL settings, filters, and relay log configuration.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
channel_name (key) |
Channel Name | NA | ||
auto_position |
Auto Position | NA | ||
connect_retry |
Connect Retry | NA | ||
source_bind |
Source Bind | NA | ||
source_host |
Source Host | NA | ||
source_info_file |
Source Info File | NA | ||
source_port |
Source Port | NA | ||
source_retry_count |
Source Retry Count | NA | ||
source_server_id |
Source Server ID | NA | ||
source_uuid |
Source UUID | NA | ||
source_ssl_allowed |
Source SSL Allowed | NA | ||
source_ssl_ca_file |
Source SSL CA File | NA | ||
source_ssl_ca_path |
Source SSL CA Path | NA | ||
source_ssl_cert |
Source SSL Cert | NA | ||
source_ssl_cipher |
Source SSL Cipher | NA | ||
source_ssl_crl |
Source SSL CRL | NA | ||
source_ssl_crl_path |
Source SSL CRL Path | NA | ||
source_ssl_key |
Source SSL Key | NA | ||
source_ssl_verify_server_cert |
Source SSL Verify Server Cert | NA | ||
source_user |
Source User | NA | ||
replicate_do_db |
Replicate Do DB | NA | ||
replicate_do_table |
Replicate Do Table | NA | ||
replicate_ignore_db |
Replicate Ignore DB | NA | ||
replicate_ignore_server_ids |
Replicate Ignore Server IDs | NA | ||
replicate_ignore_table |
Replicate Ignore Table | NA | ||
replicate_wild_do_table |
Replicate Wild Do Table | NA | ||
replicate_wild_ignore_table |
Replicate Wild Ignore Table | NA | ||
skip_counter |
Skip Counter | NA | ||
sql_delay |
SQL Delay | NA | ||
until_condition |
Until Condition | NA | ||
until_log_file |
Until Log File | NA | ||
until_log_pos |
Until Log Position | NA | ||
replicate_rewrite_db |
Replicate Rewrite DB | NA | ||
replica_allow_batching |
Replica Allow Batching | NA | ||
replica_checkpoint_group |
Replica Checkpoint Group | NA | ||
replica_checkpoint_period |
Replica Checkpoint Period | NA | ||
replica_exec_mode |
Replica Exec Mode | NA | ||
gtid_mode |
GTID Mode | NA | ||
init_replica |
Init Replica | NA | ||
replica_load_tmpdir |
Replica Load Tmpdir | NA | ||
log_replica_updates |
Log Replica Updates | NA | ||
replica_max_allowed_packet |
Replica Max Allowed Packet | NA | ||
max_relay_log_size |
Max Relay Log Size | NA | ||
replica_net_timeout |
Replica Net Timeout | NA | ||
replica_parallel_type |
Replica Parallel Type | NA | ||
replica_parallel_workers |
Replica Parallel Workers | NA | ||
replica_pending_jobs_size_max |
Replica Pending Jobs Size Max | BYTE | ||
replica_preserve_commit_order |
Replica Preserve Commit Order | NA | ||
read_only |
Read Only | NA | ||
relay_log |
Relay Log | NA | ||
relay_log_basename |
Relay Log Basename | NA | ||
relay_log_index |
Relay Log Index | NA | ||
relay_log_info_file |
Relay Log Info File | NA | ||
relay_log_purge |
Relay Log Purge | NA | ||
relay_log_recovery |
Relay Log Recovery | NA | ||
relay_log_space_limit |
Relay Log Space Limit | NA | ||
report_host |
Report Host | NA | ||
report_port |
Report Port | NA | ||
report_user |
Report User | NA | ||
rpl_semi_sync_replica_enabled |
Semi-Sync Replica Enabled | NA | ||
rpl_semi_sync_replica_trace_level |
Semi-Sync Replica Trace Level | NA | ||
server_id |
Server ID | NA | ||
replica_skip_errors |
Replica Skip Errors | NA | ||
replica_sql_verify_checksum |
Replica SQL Verify Checksum | NA | ||
sync_source_info |
Sync Source Info | NA | ||
sync_relay_log |
Sync Relay Log | NA | ||
sync_relay_log_info |
Sync Relay Log Info | NA | ||
replica_transaction_retries |
Replica Transaction Retries | NA | ||
replica_type_conversions |
Replica Type Conversions | NA |
Replication Replica Activity (ReplicationReplicaActivity) — collected every 5 Min
Replica-role replication activity per channel — I/O and SQL thread state, lag, and the most recent error. Note that replica_io_running reports Yes/No while replica_sql_running reports true/false; write any custom rule against both columns accordingly.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
channel_name (key) |
Channel Name | NA | ||
replica_io_state |
Replica IO State | NA | ||
source_log_file |
Source Log File | NA | ||
read_source_log_pos |
Read Source Log Position | NA | ||
relay_log_file |
Relay Log File | NA | ||
relay_log_pos |
Relay Log Position | NA | ||
relay_source_log_file |
Relay Source Log File | NA | ||
replica_io_running |
Replica IO Running | NA | = No | |
replica_sql_running |
Replica SQL Running | NA | = false | |
last_errno |
Last Error Number | NA | ||
last_error |
Last Error | NA | ||
relay_log_space |
Relay Log Space | BYTE | ||
last_io_errno |
Last IO Error Number | NA | ||
last_io_error |
Last IO Error | NA | ||
last_sql_errno |
Last SQL Error Number | NA | ||
last_sql_error |
Last SQL Error | NA | ||
skip_counter |
Skip Counter | NA | ||
exec_source_log_pos |
Exec Source Log Position | NA | ||
seconds_behind_source |
Seconds Behind Source | SECOND | > 30 | > 300 |
sql_remaining_delay |
SQL Remaining Delay | SECOND | ||
replica_sql_running_state |
Replica SQL Running State | NA | ||
retrieved_gtid_set |
Retrieved GTID Set | NA | ||
executed_gtid_set |
Executed GTID Set | NA | ||
source_host |
Source Host | NA | ||
com_change_replication_source |
Com Change Replication Source | NA | ||
com_replica_start |
Com Replica Start | NA | ||
com_replica_stop |
Com Replica Stop | NA | ||
com_show_replica_status |
Com Show Replica Status | NA | ||
rpl_semi_sync_replica_status |
Semi-Sync Replica Status | NA | ||
replica_heartbeat_period |
Replica Heartbeat Period | NA | ||
replica_open_temp_tables |
Replica Open Temp Tables | NA | ||
replica_received_heartbeats |
Replica Received Heartbeats | NA | ||
replica_retried_transactions |
Replica Retried Transactions | NA | ||
replica_running |
Replica Running | NA | ||
relay_log_purge |
Relay Log Purge | NA |
Log IO Latency (LogIOLatency) — collected every 5 Min
Binary log I/O volume and latency, aggregated from performance_schema.file_summary_by_event_name for binlog file events.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
log_bytes_written |
Log Bytes Written | BYTE | ||
file_io_latency |
File IO Latency | MILLISECONDS |
Replication Connection Status (ReplicationConnStatus) — collected every 5 Min
Per-channel replication connection heartbeat status, from performance_schema.replication_connection_status.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
channel_name (key) |
Channel Name | NA | ||
count_received_heartbeats |
Received Heartbeats | NA | ||
last_heartbeat_timestamp |
Last Heartbeat Timestamp | NA |
Replication Connection Config (ReplicationConnectionConfig) — collected every 1 Hr
Per-channel replication connection configuration — auto-positioning, retry interval and count, and heartbeat interval — from performance_schema.replication_connection_configuration.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
channel_name (key) |
Channel Name | NA | ||
auto_positioning_enabled |
Auto Positioning Enabled | NA | ||
connection_retry_interval |
Connection Retry Interval | NA | ||
connection_retry_count |
Connection Retry Count | NA | ||
heartbeat_interval |
Heartbeat Interval | NA | ||
bound_network_interface |
Bound Network Interface | NA | ||
source_info_storage |
Source Info Storage | NA |
Replication By Coordinator (ReplicationByCoordinator) — collected every 5 Min
Per-channel applier coordinator thread state and the most recent applier error, from performance_schema.replication_applier_status_by_coordinator.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
channel_name (key) |
Channel Name | NA | ||
thread_id |
Thread ID | NA | ||
service_state |
Service State | NA | ||
last_error_number |
Last Error Number | NA | ||
last_error_timestamp |
Last Error Timestamp | NA |
Replication By Worker (ReplicationByWorker) — collected every 5 Min
Per-channel, per-worker applier thread state and the most recent applier error, from performance_schema.replication_applier_status_by_worker.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
channel_name (key) |
Channel Name | NA | ||
worker_id (key) |
Worker ID | NA | ||
thread_id |
Thread ID | NA | ||
service_state |
Service State | NA | ||
last_error_message |
Last Error Message | NA | ||
last_error_number |
Last Error Number | NA | ||
last_applied_transaction |
Last Applied Transaction | NA |
InnoDB Activity (InnodbActivity) — collected every 5 Min
InnoDB engine activity counters — buffer pool traffic, data file I/O, log I/O, double-write, and row operations — from the server’s InnoDB status counters.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
innodb_buffer_pool_bytes_data |
Buffer Pool Bytes Data | BYTE | ||
innodb_buffer_pool_bytes_dirty |
Buffer Pool Bytes Dirty | BYTE | ||
innodb_buffer_pool_dump_status |
Buffer Pool Dump Status | NA | ||
innodb_buffer_pool_load_status |
Buffer Pool Load Status | NA | ||
innodb_buffer_pool_pages_data |
Buffer Pool Pages Data | NA | ||
innodb_buffer_pool_pages_dirty |
Buffer Pool Pages Dirty | NA | ||
innodb_buffer_pool_pages_flushed |
Buffer Pool Pages Flushed | NA | ||
innodb_buffer_pool_pages_free |
Buffer Pool Pages Free | NA | ||
innodb_buffer_pool_pages_misc |
Buffer Pool Pages Misc | NA | ||
innodb_buffer_pool_pages_total |
Buffer Pool Pages Total | NA | ||
innodb_buffer_pool_read_ahead |
Buffer Pool Read Ahead | NA | ||
innodb_buffer_pool_read_ahead_evicted |
Buffer Pool Read Ahead Evicted | NA | ||
innodb_buffer_pool_read_requests |
Buffer Pool Read Requests | NA | ||
innodb_buffer_pool_reads |
Buffer Pool Reads | NA | ||
innodb_buffer_pool_resize_status |
Buffer Pool Resize Status | NA | ||
innodb_buffer_pool_wait_free |
Buffer Pool Wait Free | NA | ||
innodb_buffer_pool_write_requests |
Buffer Pool Write Requests | NA | ||
innodb_data_fsyncs |
Data Fsyncs | NA | ||
innodb_data_pending_fsyncs |
Data Pending Fsyncs | NA | ||
innodb_data_pending_reads |
Data Pending Reads | NA | ||
innodb_data_pending_writes |
Data Pending Writes | NA | ||
innodb_data_read |
Data Read | NA | ||
innodb_data_reads |
Data Reads | NA | ||
innodb_data_writes |
Data Writes | NA | ||
innodb_data_written |
Data Written | NA | ||
innodb_dblwr_pages_written |
Dblwr Pages Written | NA | ||
innodb_dblwr_writes |
Dblwr Writes | NA | ||
innodb_log_waits |
Log Waits | NA | ||
innodb_log_write_requests |
Log Write Requests | NA | ||
innodb_log_writes |
Log Writes | NA | ||
innodb_os_log_fsyncs |
OS Log Fsyncs | NA | ||
innodb_os_log_pending_fsyncs |
OS Log Pending Fsyncs | NA | ||
innodb_os_log_pending_writes |
OS Log Pending Writes | NA | ||
innodb_os_log_written |
OS Log Written | NA | ||
innodb_pages_created |
Pages Created | NA | ||
innodb_page_size |
Page Size | BYTE | ||
innodb_pages_read |
Pages Read | NA | ||
innodb_pages_written |
Pages Written | NA | ||
innodb_row_lock_current_waits |
Row Lock Current Waits | NA | ||
innodb_row_lock_time |
Row Lock Time | MILLISECONDS | ||
innodb_row_lock_time_avg |
Row Lock Time Avg | NA | ||
innodb_row_lock_time_max |
Row Lock Time Max | NA | ||
innodb_row_lock_waits |
Row Lock Waits | NA | ||
innodb_rows_deleted |
Rows Deleted | NA | ||
innodb_rows_inserted |
Rows Inserted | NA | ||
innodb_rows_read |
Rows Read | NA | ||
innodb_rows_updated |
Rows Updated | NA | ||
innodb_truncated_status_writes |
Truncated Status Writes | NA | ||
uptime |
Uptime | SECOND |
InnoDB Buffer Pool (InnodbBufferPool) — collected every 5 Min
InnoDB buffer pool sizing and effectiveness — hit rates and page allocation from INFORMATION_SCHEMA.INNODB_BUFFER_POOL_STATS.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
innodb_bp_total_alloc |
BP Total Alloc | NA | ||
innodb_bp_dictionary_alloc |
BP Dictionary Alloc | NA | ||
innodb_bp_size |
BP Size | BYTE | ||
innodb_bp_free_buffers |
BP Free Buffers | NA | ||
innodb_bp_db_pages |
BP Db Pages | NA | ||
innodb_bp_old_db_pages |
BP Old Db Pages | NA | ||
innodb_bp_modified_pages |
BP Modified Pages | NA | ||
innodb_bp_pending_pages |
BP Pending Pages | NA | ||
innodb_bp_pending_writes_lru |
BP Pending Writes LRU | NA | ||
innodb_bp_pending_writes_flush_list |
BP Pending Writes Flush List | NA | ||
innodb_bp_pending_writes_single_page |
BP Pending Writes Single Page | NA | ||
innodb_bp_pages_young |
BP Pages Young | NA | ||
innodb_bp_pages_not_young |
BP Pages Not Young | NA | ||
innodb_bp_pages_young_per_sec |
BP Pages Young per sec | SECOND | ||
innodb_bp_pages_not_young_per_sec |
BP Pages Not Young per sec | SECOND | ||
innodb_bp_pages_read |
BP Pages Read | NA | ||
innodb_bp_pages_created |
BP Pages Created | NA | ||
innodb_bp_pages_written |
BP Pages Written | NA | ||
innodb_bp_reads_per_sec |
BP Reads per sec | SECOND | ||
innodb_bp_created_per_sec |
BP Created per sec | SECOND | ||
innodb_bp_written_per_sec |
BP Written per sec | SECOND | ||
innodb_bp_hit_rate |
BP Hit Rate | PERCENTAGE | < 95 | < 90 |
innodb_bp_young_hit_rate |
BP Young Hit Rate | PERCENTAGE | ||
innodb_bp_not_young_hit_rate |
BP Not Young Hit Rate | PERCENTAGE | ||
innodb_bp_pages_read_ahead_per_sec |
BP Pages Read Ahead per sec | SECOND | ||
innodb_bp_pages_evicted_no_access_per_sec |
BP Pages Evicted No Access per sec | SECOND | ||
innodb_bp_pages_random_read_ahead_per_sec |
BP Pages Random Read Ahead per sec | SECOND | ||
innodb_bp_lru_len |
BP LRU Len | NA | ||
innodb_bp_unzip_lru_len |
BP Unzip LRU Len | NA | ||
innodb_bp_io_sum_pages |
BP IO Sum Pages | NA | ||
innodb_bp_io_cur_pages |
BP IO Cur Pages | NA | ||
innodb_bp_io_unzip_sum_pages |
BP IO Unzip Sum Pages | NA | ||
innodb_bp_io_unzip_cur_pages |
BP IO Unzip Cur Pages | NA | ||
compress_seconds |
Compress Seconds | SECOND | ||
uncompress_seconds |
Uncompress Seconds | SECOND |
InnoDB Log (InnodbLog) — collected every 5 Min
InnoDB redo log position and capacity — sequence, flushed, and checkpoint LSNs plus log capacity used — parsed from the InnoDB engine status output.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
innodb_log_sequence_lsn |
Log Sequence LSN | NA | ||
innodb_log_flushed_lsn |
Log Flushed LSN | NA | ||
innodb_log_pages_flushed_lsn |
Log Pages Flushed LSN | NA | ||
innodb_log_checkpoint_lsn |
Log Checkpoint LSN | NA | ||
innodb_log_capacity |
Log Capacity | NA | ||
innodb_log_capacity_used |
Log Capacity Used | NA | ||
innodb_log_io_total |
Log IO Total | NA | ||
innodb_log_io_per_sec |
Log Io per sec | SECOND |
InnoDB Transactions (InnodbTransaction) — collected every 5 Min
InnoDB transaction state — counts of running, lock-waiting, committing, and rolling-back transactions, plus row-lock memory and wait totals — combining the InnoDB engine status output with INFORMATION_SCHEMA.INNODB_TRX.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
innodb_trx_id_counter_str |
Trx Id Counter Str | NA | ||
innodb_trx_purge_done |
Trx Purge Done | NA | ||
innodb_trx_history_list_length |
Trx History List Length | NA | > 100000 | > 1000000 |
running_count |
Running Count | NA | ||
lock_wait_count |
Lock Wait Count | NA | ||
committing_count |
Committing Count | NA | ||
rolling_back_count |
Rolling Back Count | NA | ||
lock_memory_bytes_total |
Lock Memory Bytes Total | BYTE | ||
rows_locked_total |
Rows Locked Total | NA | ||
rows_modified_total |
Rows Modified Total | NA | ||
row_locks_current_waits |
Row Locks Current Waits | NA |
InnoDB I/O (InnodbIO) — collected every 5 Min
InnoDB file I/O activity — OS-level reads, writes, fsyncs, and pending operations — parsed from the InnoDB engine status output.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
innodb_io_os_file_reads |
IO OS File Reads | NA | ||
innodb_io_os_file_writes |
IO OS File Writes | NA | ||
innodb_io_os_file_fsyncs |
IO OS File Fsyncs | NA | ||
innodb_io_pending_reads |
IO Pending Reads | NA | ||
innodb_io_pending_writes |
IO Pending Writes | NA | ||
innodb_io_pending_flush_log |
IO Pending Flush Log | NA | ||
innodb_io_pending_flush_bp |
IO Pending Flush BP | NA | ||
innodb_bytes_per_read |
Bytes Per Read | BYTE | ||
innodb_reads_per_sec |
Reads per sec | SECOND | ||
innodb_writes_per_sec |
Writes per sec | SECOND | ||
innodb_io_syncs_per_sec |
IO Syncs per sec | SECOND | ||
innodb_num_open_files |
Num Open Files | NA |
InnoDB Row Operations (InnodbRow) — collected every 5 Min
InnoDB row operation counts and rates — inserts, updates, deletes, and reads — parsed from the InnoDB engine status output.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
innodb_row_queries_inside |
Row Queries Inside | NA | ||
innodb_row_queries_queue |
Row Queries Queue | NA | ||
innodb_rows_inserted |
Rows Inserted | NA | ||
innodb_rows_updated |
Rows Updated | NA | ||
innodb_rows_deleted |
Rows Deleted | NA | ||
innodb_rows_read |
Rows Read | NA | ||
innodb_rows_inserted_per_sec |
Rows Inserted per sec | SECOND | ||
innodb_rows_updated_per_sec |
Rows Updated per sec | SECOND | ||
innodb_rows_deleted_per_sec |
Rows Deleted per sec | SECOND | ||
innodb_rows_read_per_sec |
Rows Read per sec | SECOND |
InnoDB Insert Buffer (InnodbInsertBuffer) — collected every 5 Min
InnoDB change buffer (insert buffer) size and merge/discard activity, parsed from the InnoDB engine status output.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
innodb_ibuf_size |
Ibuf Size | NA | ||
innodb_ibuf_free_list_len |
Ibuf Free List Len | NA | ||
innodb_ibuf_seg_size |
Ibuf Seg Size | NA | ||
innodb_cbuf_insert_merges |
Cbuf Insert Merges | NA | ||
innodb_cbuf_delete_mark_merges |
Cbuf Delete Mark Merges | NA | ||
innodb_cbuf_delete_merges |
Cbuf Delete Merges | NA | ||
innodb_cbuf_insert_discarded |
Cbuf Insert Discarded | NA | ||
innodb_cbuf_delete_mark_discarded |
Cbuf Delete Mark Discarded | NA | ||
innodb_cbuf_delete_discarded |
Cbuf Delete Discarded | NA |
InnoDB Adaptive Hash (InnodbAdaptiveHash) — collected every 5 Min
InnoDB adaptive hash index size and search rates, parsed from the InnoDB engine status output.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
innodb_hash_table_size |
Hash Table Size | NA | ||
innodb_hash_node_heap |
Hash Node Heap | NA | ||
innodb_hash_searches_per_sec |
Hash Searches per sec | SECOND | ||
innodb_non_hash_searches_per_sec |
Non Hash Searches per sec | SECOND |
InnoDB Threads (InnodbThread) — collected every 5 Min
InnoDB background (main) thread loop counters and current state, parsed from the InnoDB engine status output.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
innodb_main_thd_loops_srv_active |
Main Thd Loops Srv Active | NA | ||
innodb_main_thd_loops_srv_shutdown |
Main Thd Loops Srv Shutdown | NA | ||
innodb_main_thd_loops_srv_idle |
Main Thd Loops Srv Idle | NA | ||
innodb_main_thd_log_flush_writes |
Main Thd Log Flush Writes | NA | ||
innodb_row_state |
Row State | NA |
InnoDB Semaphores (InnodbSemaphore) — collected every 5 Min
InnoDB internal synchronization activity — mutex and rw-lock spin, rounds, and OS wait counts — parsed from the InnoDB engine status output.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
innodb_sem_os_reservation_count |
Sem OS Reservation Count | NA | ||
innodb_sem_os_signal_count |
Sem OS Signal Count | NA | ||
innodb_sem_shared_spins |
Sem Shared Spins | NA | ||
innodb_sem_shared_rounds |
Sem Shared Rounds | NA | ||
innodb_sem_shared_os_waits |
Sem Shared OS Waits | NA | ||
innodb_sem_rw_excl_spins |
Sem RW Excl Spins | NA | ||
innodb_sem_rw_excl_rounds |
Sem RW Excl Rounds | NA | ||
innodb_sem_rw_excl_os_waits |
Sem RW Excl OS Waits | NA | ||
innodb_sem_rw_sx_spins |
Sem RW SX Spins | NA | ||
innodb_sem_rw_sx_rounds |
Sem RW SX Rounds | NA | ||
innodb_sem_rw_sx_os_waits |
Sem RW SX OS Waits | NA | ||
innodb_sem_spins_per_wait_rw_shared |
Sem Spins Per Wait RW Shared | NA | ||
innodb_sem_spins_per_wait_rw_excl |
Sem Spins Per Wait RW Excl | NA | ||
innodb_sem_spins_per_wait_rw_sx |
Sem Spins Per Wait RW SX | NA |
Admin Statement Activity (AdminStatementActivity) — collected every 5 Min
Counts of Admin Statement Activity statements executed, collected as deltas between collections so the values show activity in the interval rather than since server start.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
com_admin_commands |
Com Admin Commands | NA | ||
com_analyze |
Com Analyze | NA | ||
com_assign_to_keycache |
Com Assign To Keycache | NA | ||
com_binlog |
Com Binlog | NA | ||
com_change_replication_source |
Com Change Replication Source | NA | ||
com_check |
Com Check | NA | ||
com_checksum |
Com Checksum | NA | ||
com_flush |
Com Flush | NA | ||
com_install_plugin |
Com Install Plugin | NA | ||
com_kill |
Com Kill | NA | ||
com_optimize |
Com Optimize | NA | ||
com_preload_keys |
Com Preload Keys | NA | ||
com_purge |
Com Purge | NA | ||
com_purge_before_date |
Com Purge Before Date | NA | ||
com_repair |
Com Repair | NA | ||
com_replica_start |
Com Replica Start | NA | ||
com_replica_stop |
Com Replica Stop | NA | ||
com_uninstall_plugin |
Com Uninstall Plugin | NA |
DDL Statement Activity (DdlStatementActivity) — collected every 5 Min
Counts of DDL Statement Activity statements executed, collected as deltas between collections so the values show activity in the interval rather than since server start.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
com_alter_db |
Com Alter Db | NA | ||
com_alter_event |
Com Alter Event | NA | ||
com_alter_function |
Com Alter Function | NA | ||
com_alter_procedure |
Com Alter Procedure | NA | ||
com_alter_server |
Com Alter Server | NA | ||
com_alter_table |
Com Alter Table | NA | ||
com_alter_tablespace |
Com Alter Tablespace | NA | ||
com_create_db |
Com Create Db | NA | ||
com_create_event |
Com Create Event | NA | ||
com_create_function |
Com Create Function | NA | ||
com_create_index |
Com Create Index | NA | ||
com_create_procedure |
Com Create Procedure | NA | ||
com_create_server |
Com Create Server | NA | ||
com_create_table |
Com Create Table | NA | ||
com_create_trigger |
Com Create Trigger | NA | ||
com_create_udf |
Com Create Udf | NA | ||
com_create_user |
Com Create User | NA | ||
com_create_view |
Com Create View | NA | ||
com_drop_db |
Com Drop Db | NA | ||
com_drop_event |
Com Drop Event | NA | ||
com_drop_function |
Com Drop Function | NA | ||
com_drop_index |
Com Drop Index | NA | ||
com_drop_procedure |
Com Drop Procedure | NA | ||
com_drop_server |
Com Drop Server | NA | ||
com_drop_table |
Com Drop Table | NA | ||
com_drop_trigger |
Com Drop Trigger | NA | ||
com_drop_user |
Com Drop User | NA | ||
com_drop_view |
Com Drop View | NA | ||
com_grant |
Com Grant | NA | ||
com_rename_table |
Com Rename Table | NA | ||
com_rename_user |
Com Rename User | NA | ||
com_truncate |
Com Truncate | NA |
DML Statement Activity (DmlStatementActivity) — collected every 5 Min
Counts of DML Statement Activity statements executed, collected as deltas between collections so the values show activity in the interval rather than since server start.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
com_call_procedure |
Com Call Procedure | NA | ||
com_change_db |
Com Change Db | NA | ||
com_dealloc_sql |
Com Dealloc Sql | NA | ||
com_delete |
Com Delete | NA | ||
com_delete_multi |
Com Delete Multi | NA | ||
com_do |
Com Do | NA | ||
com_empty_query |
Com Empty Query | NA | ||
com_execute_sql |
Com Execute Sql | NA | ||
com_ha_close |
Com HA Close | NA | ||
com_ha_open |
Com HA Open | NA | ||
com_ha_read |
Com HA Read | NA | ||
com_help |
Com Help | NA | ||
com_insert |
Com Insert | NA | ||
com_insert_select |
Com Insert Select | NA | ||
com_load |
Com Load | NA | ||
com_lock_tables |
Com Lock Tables | NA | ||
com_prepare_sql |
Com Prepare Sql | NA | ||
com_replace |
Com Replace | NA | ||
com_replace_select |
Com Replace Select | NA | ||
com_reset |
Com Reset | NA | ||
com_resignal |
Com Resignal | NA | ||
com_select |
Com Select | NA | ||
com_set_option |
Com Set Option | NA | ||
com_signal |
Com Signal | NA | ||
com_stmt_close |
Com Stmt Close | NA | ||
com_stmt_execute |
Com Stmt Execute | NA | ||
com_stmt_fetch |
Com Stmt Fetch | NA | ||
com_stmt_prepare |
Com Stmt Prepare | NA | ||
com_stmt_reprepare |
Com Stmt Reprepare | NA | ||
com_stmt_reset |
Com Stmt Reset | NA | ||
com_stmt_send_long_data |
Com Stmt Send Long Data | NA | ||
com_unlock_tables |
Com Unlock Tables | NA | ||
com_update |
Com Update | NA | ||
com_update_multi |
Com Update Multi | NA |
Show Statement Activity (ShowStatementActivity) — collected every 5 Min
Counts of Show Statement Activity statements executed, collected as deltas between collections so the values show activity in the interval rather than since server start.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
com_show_binlog_events |
Com Show Binlog Events | NA | ||
com_show_binlogs |
Com Show Binlogs | NA | ||
com_show_charsets |
Com Show Charsets | NA | ||
com_show_collations |
Com Show Collations | NA | ||
com_show_create_db |
Com Show Create Db | NA | ||
com_show_create_event |
Com Show Create Event | NA | ||
com_show_create_func |
Com Show Create Func | NA | ||
com_show_create_proc |
Com Show Create Proc | NA | ||
com_show_create_table |
Com Show Create Table | NA | ||
com_show_create_trigger |
Com Show Create Trigger | NA | ||
com_show_databases |
Com Show Databases | NA | ||
com_show_engine_logs |
Com Show Engine Logs | NA | ||
com_show_engine_mutex |
Com Show Engine Mutex | NA | ||
com_show_engine_status |
Com Show Engine Status | NA | ||
com_show_errors |
Com Show Errors | NA | ||
com_show_events |
Com Show Events | NA | ||
com_show_fields |
Com Show Fields | NA | ||
com_show_function_code |
Com Show Function Code | NA | ||
com_show_function_status |
Com Show Function Status | NA | ||
com_show_grants |
Com Show Grants | NA | ||
com_show_keys |
Com Show Keys | NA | ||
com_show_binary_log_status |
Com Show Binary Log Status | NA | ||
com_show_open_tables |
Com Show Open Tables | NA | ||
com_show_plugins |
Com Show Plugins | NA | ||
com_show_privileges |
Com Show Privileges | NA | ||
com_show_procedure_code |
Com Show Procedure Code | NA | ||
com_show_procedure_status |
Com Show Procedure Status | NA | ||
com_show_processlist |
Com Show Processlist | NA | ||
com_show_profile |
Com Show Profile | NA | ||
com_show_profiles |
Com Show Profiles | NA | ||
com_show_relaylog_events |
Com Show Relaylog Events | NA | ||
com_show_replicas |
Com Show Replicas | NA | ||
com_show_replica_status |
Com Show Replica Status | NA | ||
com_show_status |
Com Show Status | NA | ||
com_show_storage_engines |
Com Show Storage Engines | NA | ||
com_show_tables |
Com Show Tables | NA | ||
com_show_table_status |
Com Show Table Status | NA | ||
com_show_triggers |
Com Show Triggers | NA | ||
com_show_variables |
Com Show Variables | NA | ||
com_show_warnings |
Com Show Warnings | NA |
Transaction Statement Activity (TransactionStatementActivity) — collected every 5 Min
Counts of Transaction Statement Activity statements executed, collected as deltas between collections so the values show activity in the interval rather than since server start.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
com_begin |
Com Begin | NA | ||
com_commit |
Com Commit | NA | ||
com_release_savepoint |
Com Release Savepoint | NA | ||
com_rollback |
Com Rollback | NA | ||
com_rollback_to_savepoint |
Com Rollback To Savepoint | NA | ||
com_savepoint |
Com Savepoint | NA | ||
com_xa_commit |
Com XA Commit | NA | ||
com_xa_end |
Com XA End | NA | ||
com_xa_prepare |
Com XA Prepare | NA | ||
com_xa_recover |
Com XA Recover | NA | ||
com_xa_rollback |
Com XA Rollback | NA | ||
com_xa_start |
Com XA Start | NA |
Handler Activity (HandlerActivity) — collected every 5 Min
Storage engine handler call counts — reads, writes, commits, and rollbacks — from the server’s Handler_* status counters.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
handler_commit |
Handler Commit | NA | ||
handler_delete |
Handler Delete | NA | ||
handler_discover |
Handler Discover | NA | ||
handler_external_lock |
Handler External Lock | NA | ||
handler_mrr_init |
Handler Mrr Init | NA | ||
handler_prepare |
Handler Prepare | NA | ||
handler_read_first |
Handler Read First | NA | ||
handler_read_key |
Handler Read Key | NA | ||
handler_read_last |
Handler Read Last | NA | ||
handler_read_next |
Handler Read Next | NA | ||
handler_read_prev |
Handler Read Prev | NA | ||
handler_read_rnd |
Handler Read Rnd | NA | ||
handler_read_rnd_next |
Handler Read Rnd Next | NA | ||
handler_rollback |
Handler Rollback | NA | ||
handler_savepoint |
Handler Savepoint | NA | ||
handler_savepoint_rollback |
Handler Savepoint Rollback | NA | ||
handler_update |
Handler Update | NA | ||
handler_write |
Handler Write | NA | ||
uptime |
Uptime | SECOND |
Instance Activity (InstanceActivity) — collected every 5 Min
General server activity counters — queries served, open files, prepared statements, and uptime — from the server’s status counters.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
acl_cache_items_count |
Acl Cache Items Count | NA | ||
flush_commands |
Flush Commands | NA | ||
opened_files |
Opened Files | NA | ||
open_files |
Open Files | NA | ||
open_streams |
Open Streams | NA | ||
prepared_stmt_count |
Prepared Stmt Count | NA | ||
queries |
Queries | NA | ||
questions |
Questions | NA | ||
uptime |
Uptime | SECOND | ||
uptime_since_flush_status |
Uptime Since Flush Status | SECOND |
XA Activity (XaActivity) — collected every 5 Min
XA / two-phase-commit transaction coordinator log counters — page size, pages used, and page waits.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
tc_log_max_pages_used |
Tc Log Max Pages Used | NA | ||
tc_log_page_size |
Tc Log Page Size | BYTE | ||
tc_log_page_waits |
Tc Log Page Waits | NA |
Connection Activity (ConnectionActivity) — collected every 5 Min
Connection-level activity counters — aborted clients and connects, bytes transferred, and thread caching — from the server’s status counters; aborted_connects_delta reports the count as a delta between collections.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
aborted_clients |
Aborted Clients | NA | ||
aborted_connects |
Aborted Connects | NA | ||
bytes_received |
Bytes Received | BYTE | ||
bytes_sent |
Bytes Sent | BYTE | ||
connections |
Connections | NA | ||
locked_connects |
Locked Connects | NA | ||
max_execution_time_exceeded |
Max Execution Time Exceeded | NA | ||
max_execution_time_set |
Max Execution Time Set | NA | ||
max_execution_time_set_failed |
Max Execution Time Set Failed | NA | ||
max_used_connections |
Max Used Connections | NA | ||
ongoing_anonymous_transaction_count |
Ongoing Anonymous Transaction Count | NA | ||
threads_cached |
Threads Cached | NA | ||
threads_connected |
Threads Connected | NA | ||
aborted_connects_delta |
Aborted Connects (Delta) | NA | > 10 | > 50 |
Threads Activity (ThreadsActivity) — collected every 5 Min
Thread pool activity and configuration — cached, connected, and running thread counts alongside the configured thread-handling mode and connection limit.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
threads_cached |
Threads Cached | NA | ||
threads_connected |
Threads Connected | NA | ||
threads_created |
Threads Created | NA | ||
threads_running |
Threads Running | NA | ||
slow_launch_threads |
Slow Launch Threads | NA | ||
uptime |
Uptime | SECOND | ||
max_connections |
Max Connections | NA | ||
thread_handling |
Thread Handling | NA | ||
connection_saturation_pct |
Connection Saturation (%) | PERCENTAGE | > 80 | > 95 |
Insert Delayed Activity (InsertDelayedActivity) — collected every 5 Min
INSERT DELAYED activity counters — errors, active delayed-insert threads, and rows not yet flushed — from the server’s status counters.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
delayed_errors |
Delayed Errors | NA | ||
delayed_insert_threads |
Delayed Insert Threads | NA | ||
not_flushed_delayed_rows |
Not Flushed Delayed Rows | NA | ||
delayed_writes |
Delayed Writes | NA |
NDB Activity (NdbActivity) — collected every 5 Min
NDB Cluster storage engine status counters — conflict function usage and data node counts; empty on servers without the NDB storage engine.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
ndb_conflict_fn_max |
Ndb Conflict Fn Max | NA | ||
ndb_conflict_fn_old |
Ndb Conflict Fn Old | NA | ||
ndb_number_of_data_nodes |
Ndb Number Of Data Nodes | NA | ||
ndb_number_of_ready_data_nodes |
Ndb Number Of Ready Data Nodes | NA |
Performance Schema Activity (PerformanceSchemaActivity) — collected every 5 Min
Performance Schema instrumentation loss counters — how many events, instances, or classes the Performance Schema has had to discard because a configured limit was reached.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
performance_schema_cond_classes_lost |
Performance Schema Cond Classes Lost | NA | ||
performance_schema_cond_instances_lost |
Performance Schema Cond Instances Lost | NA | ||
performance_schema_file_classes_lost |
Performance Schema File Classes Lost | NA | ||
performance_schema_file_handles_lost |
Performance Schema File Handles Lost | NA | ||
performance_schema_file_instances_lost |
Performance Schema File Instances Lost | NA | ||
performance_schema_hosts_lost |
Performance Schema Hosts Lost | NA | ||
performance_schema_index_stat_lost |
Performance Schema Index Stat Lost | NA | ||
performance_schema_locker_lost |
Performance Schema Locker Lost | NA | ||
performance_schema_memory_classes_lost |
Performance Schema Memory Classes Lost | NA | ||
performance_schema_metadata_lock_lost |
Performance Schema Metadata Lock Lost | NA | ||
performance_schema_mutex_classes_lost |
Performance Schema Mutex Classes Lost | NA | ||
performance_schema_mutex_instances_lost |
Performance Schema Mutex Instances Lost | NA | ||
performance_schema_nested_statement_lost |
Performance Schema Nested Statement Lost | NA | ||
performance_schema_prepared_statements_lost |
Performance Schema Prepared Statements Lost | NA | ||
performance_schema_program_lost |
Performance Schema Program Lost | NA | ||
performance_schema_rwlock_classes_lost |
Performance Schema Rwlock Classes Lost | NA | ||
performance_schema_rwlock_instances_lost |
Performance Schema Rwlock Instances Lost | NA | ||
performance_schema_session_connect_attrs_longest_seen |
Performance Schema Session Connect Attrs Longest Seen | NA | ||
performance_schema_table_handles_lost |
Performance Schema Table Handles Lost | NA | ||
performance_schema_table_instances_lost |
Performance Schema Table Instances Lost | NA | ||
performance_schema_table_lock_stat_lost |
Performance Schema Table Lock Stat Lost | NA | ||
performance_schema_thread_classes_lost |
Performance Schema Thread Classes Lost | NA | ||
performance_schema_thread_instances_lost |
Performance Schema Thread Instances Lost | NA |
Table Activity (TableActivity) — collected every 5 Min
Table and temporary-table activity — opened tables and definitions, on-disk vs in-memory temporary tables, sorting activity, and table lock waits; created_tmp_tables_delta and created_tmp_disk_tables_delta report those counts as deltas between collections.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
created_tmp_disk_tables |
Created Tmp Disk Tables | NA | ||
created_tmp_files |
Created Tmp Files | NA | ||
created_tmp_tables |
Created Tmp Tables | NA | ||
opened_table_definitions |
Opened Table Definitions | NA | ||
opened_tables |
Opened Tables | NA | ||
open_table_definitions |
Open Table Definitions | NA | ||
open_tables |
Open Tables | NA | ||
sort_merge_passes |
Sort Merge Passes | NA | ||
sort_range |
Sort Range | NA | ||
sort_rows |
Sort Rows | NA | ||
sort_scan |
Sort Scan | NA | ||
table_locks_immediate |
Table Locks Immediate | NA | ||
table_locks_waited |
Table Locks Waited | NA | ||
uptime |
Uptime | SECOND | ||
open_files_limit |
Open Files Limit | NA | ||
table_open_cache |
Table Open Cache | NA | ||
created_tmp_tables_delta |
Created Tmp Tables (Delta) | NA | ||
created_tmp_disk_tables_delta |
Created Tmp Disk Tables (Delta) | NA | ||
disk_tmp_table_pct |
Disk Tmp Table Ratio (%) | PERCENTAGE | > 25 | > 50 |
Secure Connections Activity (SecureConnectionsActivity) — collected every 5 Min
TLS/SSL connection counters and negotiated settings — accepts, renegotiations, session cache activity, cipher, and protocol version.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
ssl_accept_renegotiates |
Ssl Accept Renegotiates | NA | ||
ssl_accepts |
Ssl Accepts | NA | ||
ssl_callback_cache_hits |
Ssl Callback Cache Hits | NA | ||
ssl_cipher |
Ssl Cipher | NA | ||
ssl_cipher_list |
Ssl Cipher List | NA | ||
ssl_client_connects |
Ssl Client Connects | NA | ||
ssl_connect_renegotiates |
Ssl Connect Renegotiates | NA | ||
ssl_ctx_verify_depth |
Ssl Ctx Verify Depth | NA | ||
ssl_ctx_verify_mode |
Ssl Ctx Verify Mode | NA | ||
ssl_default_timeout |
Ssl Default Timeout | NA | ||
ssl_finished_accepts |
Ssl Finished Accepts | NA | ||
ssl_finished_connects |
Ssl Finished Connects | NA | ||
ssl_server_not_after |
Ssl Server Not After | NA | ||
ssl_server_not_before |
Ssl Server Not Before | NA | ||
ssl_session_cache_hits |
Ssl Session Cache Hits | NA | ||
ssl_session_cache_misses |
Ssl Session Cache Misses | NA | ||
ssl_session_cache_mode |
Ssl Session Cache Mode | NA | ||
ssl_session_cache_overflows |
Ssl Session Cache Overflows | NA | ||
ssl_session_cache_size |
Ssl Session Cache Size | NA | ||
ssl_session_cache_timeout |
Ssl Session Cache Timeout | NA | ||
ssl_session_cache_timeouts |
Ssl Session Cache Timeouts | NA | ||
ssl_sessions_reused |
Ssl Sessions Reused | NA | ||
ssl_used_session_cache_entries |
Ssl Used Session Cache Entries | NA | ||
ssl_verify_depth |
Ssl Verify Depth | NA | ||
ssl_verify_mode |
Ssl Verify Mode | NA | ||
ssl_version |
Ssl Version | NA |
Audit Log Activity (AuditLogActivity) — collected every 5 Min
MySQL Enterprise Audit event counters — events written, filtered, and dropped, and audit log size. Requires the Enterprise Audit component; the group collects an empty row when it is not installed.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
audit_log_current_size |
Audit Log Current Size | BYTE | ||
audit_log_direct_writes |
Audit Log Direct Writes | NA | ||
audit_log_event_max_drop_size |
Audit Log Event Max Drop Size | BYTE | ||
audit_log_events |
Audit Log Events | NA | ||
audit_log_events_filtered |
Audit Log Events Filtered | NA | ||
audit_log_events_lost |
Audit Log Events Lost | NA | ||
audit_log_events_written |
Audit Log Events Written | NA | ||
audit_log_total_size |
Audit Log Total Size | BYTE | ||
audit_log_write_waits |
Audit Log Write Waits | NA |
Firewall Activity (FirewallActivity) — collected every 5 Min
MySQL Enterprise Firewall counters — access granted, denied, and flagged as suspicious, and cached firewall entries. Requires the Enterprise Firewall component; the group collects an empty row when it is not installed.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
firewall_access_denied |
Firewall Access Denied | NA | ||
firewall_access_granted |
Firewall Access Granted | NA | ||
firewall_access_suspicious |
Firewall Access Suspicious | NA | ||
firewall_cached_entries |
Firewall Cached Entries | NA |
Sys Schema Status (SysSchemaStatus) — collected every 5 Min
Reports whether the MySQL sys schema is present and recent enough for the plug-in’s Sys Schema metric groups to collect; the other Sys groups collect empty rows when it is not.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
sys_version |
Sys Version | NA | ||
sys_supported |
Sys Supported | NA | < 1 | |
status_message |
Sys Status Message | NA |
Sys Memory By Event (SysMemoryByEvent) — collected every 5 Min
Current and high-water memory allocation per instrumented event, from sys.x$memory_global_by_current_bytes.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
event_name (key) |
Event Name | NA | ||
current_count |
Current Count | NA | ||
current_alloc |
Current Alloc | BYTE | ||
current_avg_alloc |
Current Avg Alloc | BYTE | ||
high_count |
High Count | NA | ||
high_alloc |
High Alloc | BYTE | ||
high_avg_alloc |
High Avg Alloc | BYTE |
Sys IO By Host (SysIoByHost) — collected every 5 Min
File I/O count and latency per connecting host, from sys.x$host_summary_by_file_io.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
host (key) |
Host | NA | ||
ios |
IOs | NA | ||
io_latency |
IO Latency | MICROSEC |
Sys IO By Thread (SysIoByThread) — collected every 5 Min
File I/O count and latency per thread, from sys.x$io_by_thread_by_latency.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
thread_id (key) |
Thread Id | NA | ||
user |
User | NA | ||
total |
Total | NA | ||
total_latency |
Total Latency | MICROSEC | ||
min_latency |
Min Latency | MICROSEC | ||
avg_latency |
Avg Latency | MICROSEC | ||
max_latency |
Max Latency | MICROSEC | ||
processlist_id |
Processlist Id | NA |
Sys IO By File (SysIoByFile) — collected every 5 Min
File I/O count and latency per file, broken down by read/write/misc activity, from sys.x$io_global_by_file_by_latency.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
file (key) |
File | NA | ||
total |
Total | NA | ||
total_latency |
Total Latency | MICROSEC | ||
count_read |
Count Read | NA | ||
read_latency |
Read Latency | MICROSEC | ||
count_write |
Count Write | NA | ||
write_latency |
Write Latency | MICROSEC | ||
count_misc |
Count Misc | NA | ||
misc_latency |
Misc Latency | MICROSEC |
Sys IO By Wait (SysIoByWait) — collected every 5 Min
File I/O count and latency per wait event, from sys.x$io_global_by_wait_by_latency.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
event_name (key) |
Event Name | NA | ||
total |
Total | NA | ||
total_latency |
Total Latency | MICROSEC | ||
avg_latency |
Avg Latency | MICROSEC | ||
max_latency |
Max Latency | MICROSEC | ||
read_latency |
Read Latency | MICROSEC | ||
write_latency |
Write Latency | MICROSEC | ||
misc_latency |
Misc Latency | MICROSEC | ||
count_read |
Count Read | NA | ||
total_read |
Total Read | BYTE | ||
avg_read |
Avg Read | NA | ||
count_write |
Count Write | NA | ||
total_written |
Total Written | BYTE | ||
avg_written |
Avg Written | NA |
Sys Table Statistics (SysTableStatistics) — collected every 5 Min
Per-table I/O and DML activity — rows fetched, inserted, updated, and deleted, and I/O bytes/latency — equivalent to sys.x$schema_table_statistics, read directly from performance_schema for compatibility with least-privilege monitoring accounts.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
table_schema (key) |
Table Schema | NA | ||
table_name (key) |
Table Name | NA | ||
total |
Total | NA | ||
total_latency |
Total Latency | MICROSEC | ||
rows_fetched |
Rows Fetched | NA | ||
fetch_latency |
Fetch Latency | MICROSEC | ||
rows_inserted |
Rows Inserted | NA | ||
insert_latency |
Insert Latency | MICROSEC | ||
rows_updated |
Rows Updated | NA | ||
update_latency |
Update Latency | MICROSEC | ||
rows_deleted |
Rows Deleted | NA | ||
delete_latency |
Delete Latency | MICROSEC | ||
io_read_requests |
IO Read Requests | NA | ||
io_read |
IO Read | BYTE | ||
io_read_latency |
IO Read Latency | MICROSEC | ||
io_write_requests |
IO Write Requests | NA | ||
io_write |
IO Write | BYTE | ||
io_write_latency |
IO Write Latency | MICROSEC | ||
io_misc_requests |
IO Misc Requests | NA | ||
io_misc_latency |
IO Misc Latency | MICROSEC |
Sys User Summary (SysUserSummary) — collected every 5 Min
Per-user activity summary — statements, table scans, file I/O, connections, and memory — from sys.x$user_summary.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
user (key) |
User | NA | ||
statements |
Statements | NA | ||
statement_latency |
Statement Latency | MICROSEC | ||
statement_avg_latency |
Statement Avg Latency | MICROSEC | ||
table_scans |
Table Scans | NA | ||
file_ios |
File IOs | NA | ||
file_io_latency |
File IO Latency | MICROSEC | ||
current_connections |
Current Connections | NA | ||
total_connections |
Total Connections | NA | ||
unique_hosts |
Unique Hosts | NA | ||
current_memory |
Current Memory | BYTE | ||
total_memory_allocated |
Total Memory Allocated | BYTE |
Sys Host Summary (SysHostSummary) — collected every 5 Min
Per-host activity summary — statements, table scans, file I/O, connections, and memory — from sys.x$host_summary.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
host (key) |
Host | NA | ||
statements |
Statements | NA | ||
statement_latency |
Statement Latency | MICROSEC | ||
statement_avg_latency |
Statement Avg Latency | MICROSEC | ||
table_scans |
Table Scans | NA | ||
file_ios |
File IOs | NA | ||
file_io_latency |
File IO Latency | MICROSEC | ||
current_connections |
Current Connections | NA | ||
total_connections |
Total Connections | NA | ||
unique_users |
Unique Users | NA | ||
current_memory |
Current Memory | BYTE | ||
total_memory_allocated |
Total Memory Allocated | BYTE |
Sys Statement By Latency (SysStatementByLatency) — collected every 5 Min
Top 25 statement digests by total execution latency, from sys.x$statement_analysis.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
digest (key) |
Digest | NA | ||
query |
Query | NA | ||
db (key) |
Db | NA | ||
full_scan |
Full Scan | NA | ||
exec_count |
Exec Count | NA | ||
err_count |
Err Count | NA | ||
warn_count |
Warn Count | NA | ||
total_latency |
Total Latency | MICROSEC | ||
max_latency |
Max Latency | MICROSEC | ||
avg_latency |
Avg Latency | MICROSEC | ||
lock_latency |
Lock Latency | MICROSEC | ||
rows_sent |
Rows Sent | NA | ||
rows_examined |
Rows Examined | NA | ||
rows_affected |
Rows Affected | NA | ||
tmp_tables |
Tmp Tables | NA | ||
tmp_disk_tables |
Tmp Disk Tables | NA | ||
first_seen |
First Seen | NA | ||
last_seen |
Last Seen | NA |
Sys Statement By Exec Count (SysStatementByExecCount) — collected every 5 Min
Top 25 statement digests by execution count, from sys.x$statement_analysis.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
digest (key) |
Digest | NA | ||
query |
Query | NA | ||
db (key) |
Db | NA | ||
full_scan |
Full Scan | NA | ||
exec_count |
Exec Count | NA | ||
err_count |
Err Count | NA | ||
warn_count |
Warn Count | NA | ||
total_latency |
Total Latency | MICROSEC | ||
max_latency |
Max Latency | MICROSEC | ||
avg_latency |
Avg Latency | MICROSEC | ||
lock_latency |
Lock Latency | MICROSEC | ||
rows_sent |
Rows Sent | NA | ||
rows_examined |
Rows Examined | NA | ||
rows_affected |
Rows Affected | NA | ||
tmp_tables |
Tmp Tables | NA | ||
tmp_disk_tables |
Tmp Disk Tables | NA | ||
first_seen |
First Seen | NA | ||
last_seen |
Last Seen | NA |
Sys Statement By First Seen (SysStatementByFirstSeen) — collected every 5 Min
Top 25 statement digests by most recent first-seen time, from sys.x$statement_analysis.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
digest (key) |
Digest | NA | ||
query |
Query | NA | ||
db (key) |
Db | NA | ||
full_scan |
Full Scan | NA | ||
exec_count |
Exec Count | NA | ||
err_count |
Err Count | NA | ||
warn_count |
Warn Count | NA | ||
total_latency |
Total Latency | MICROSEC | ||
max_latency |
Max Latency | MICROSEC | ||
avg_latency |
Avg Latency | MICROSEC | ||
lock_latency |
Lock Latency | MICROSEC | ||
rows_sent |
Rows Sent | NA | ||
rows_examined |
Rows Examined | NA | ||
rows_affected |
Rows Affected | NA | ||
tmp_tables |
Tmp Tables | NA | ||
tmp_disk_tables |
Tmp Disk Tables | NA | ||
first_seen |
First Seen | NA | ||
last_seen |
Last Seen | NA |
Sys InnoDB Lock Waits (SysInnodbLockWaits) — collected every 5 Min
Current InnoDB row-lock waits — the waiting and blocking lock, transaction, and session for each — equivalent to sys.x$innodb_lock_waits, read directly from performance_schema for compatibility with least-privilege monitoring accounts.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
waiting_lock_id (key) |
Waiting Lock Id | NA | ||
blocking_lock_id (key) |
Blocking Lock Id | NA | ||
locked_schema |
Locked Schema | NA | ||
locked_table |
Locked Table | NA | ||
locked_index |
Locked Index | NA | ||
locked_type |
Locked Type | NA | ||
waiting_lock_mode |
Waiting Lock Mode | NA | ||
blocking_lock_mode |
Blocking Lock Mode | NA | ||
waiting_pid |
Waiting Pid | NA | ||
blocking_pid |
Blocking Pid | NA | ||
waiting_trx_id |
Waiting Trx Id | NA | ||
blocking_trx_id |
Blocking Trx Id | NA |
Sys Table Lock Waits (SysTableLockWaits) — collected every 5 Min
Current metadata (table) lock waits — pending vs. granted locks and the sessions holding them — equivalent to sys.x$schema_table_lock_waits, read directly from performance_schema for compatibility with least-privilege monitoring accounts.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
object_schema (key) |
Object Schema | NA | ||
object_name (key) |
Object Name | NA | ||
waiting_thread_id (key) |
Waiting Thread Id | NA | ||
waiting_pid |
Waiting Pid | NA | ||
waiting_lock_type |
Waiting Lock Type | NA | ||
waiting_lock_duration |
Waiting Lock Duration | NA | ||
blocking_thread_id |
Blocking Thread Id | NA | ||
blocking_pid |
Blocking Pid | NA | ||
blocking_lock_type |
Blocking Lock Type | NA | ||
blocking_lock_duration |
Blocking Lock Duration | NA |
Sys Processlist (SysProcesslist) — collected every 5 Min
Active, non-idle sessions and their current statement, from sys.x$processlist.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
thd_id (key) |
Thd Id | NA | ||
conn_id |
Conn Id | NA | ||
user |
User | NA | ||
db |
Db | NA | ||
command |
Command | NA | ||
state |
State | NA | ||
time |
Time | SECOND | ||
current_statement |
Current Statement | NA | ||
statement_latency |
Statement Latency | MICROSEC | ||
lock_latency |
Lock Latency | MICROSEC | ||
rows_examined |
Rows Examined | NA | ||
rows_sent |
Rows Sent | NA | ||
rows_affected |
Rows Affected | NA | ||
tmp_tables |
Tmp Tables | NA | ||
tmp_disk_tables |
Tmp Disk Tables | NA | ||
trx_state |
Trx State | NA |
Backup History (BackupHistory) — collected every 1 Hr
Recent backup runs across supported backup tools. Reads MySQL Enterprise Backup’s mysql.backup_history and Percona XtraBackup’s PERCONA_SCHEMA.xtrabackup_history when present; an absent tool is reported as not detected and raises no alert.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
source (key) |
Source | NA | ||
backup_id (key) |
Backup ID | NA | ||
backup_type |
Backup Type | NA | ||
start_time |
Start Time | NA | ||
end_time |
End Time | NA | ||
run_seconds |
Run Time (sec) | SECOND | ||
lock_seconds |
Lock Time (sec) | SECOND | ||
end_lsn |
End LSN | NA | ||
binlog_position |
Binlog Position (PITR) | NA | ||
exit_state |
Exit State | NA | ||
success |
Success (0/1) | NA |
Backup Status (BackupStatus) — collected every 1 Hr
Single-row backup health summary — presence of each backup tool, the most recent backup attempt, and hours since the last success. Reads MySQL Enterprise Backup’s mysql.backup_history and Percona XtraBackup’s PERCONA_SCHEMA.xtrabackup_history when present; an absent tool is reported as not detected and raises no alert.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
meb_present |
MEB Detected (0/1) | NA | ||
pxb_present |
XtraBackup Detected (0/1) | NA | ||
pxb_history_enabled |
XtraBackup History Enabled (0/1) | NA | ||
last_source |
Last Backup Source | NA | ||
last_exit_state |
Last Backup Exit State | NA | ||
last_successful_end_time |
Last Successful Backup | NA | ||
hours_since_last_success |
Hours Since Last Successful Backup | NA | > 26 | > 50 |
last_backup_failed |
Last Backup Failed (0/1) | NA | > 0 | |
never_succeeded |
Never Succeeded (0/1) | NA | > 0 |
Character Set (CharacterSet) — configuration snapshot, collected every 24 Hr
Configuration snapshot of the server’s Character Set settings, captured for configuration history and compliance evaluation.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
CLIENT |
Client | NA | ||
CONNECTION |
Connection | NA | ||
DATABASE |
Database | NA | ||
DIRECTORY |
Directory | NA | ||
FILESYSTEM |
Filesystem | NA | ||
RESULTS |
Results | NA | ||
SERVER |
Server | NA | ||
SYSTEM |
System | NA |
Connection Buffers (ConnectionBuffers) — configuration snapshot, collected every 24 Hr
Configuration snapshot of the server’s Connection Buffers settings, captured for configuration history and compliance evaluation.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
BULK_INSERT_BUFFER_SIZE |
Bulk Insert Buffer Size | NA | ||
JOIN_BUFFER_SIZE |
Join Buffer Size | NA | ||
MAX_ALLOWED_PACKET |
Max Allowed Packet | NA | ||
NET_BUFFER_LENGTH |
Net Buffer Length | NA | ||
PRELOAD_BUFFER_SIZE |
Preload Buffer Size | NA | ||
QUERY_ALLOC_BLOCK_SIZE |
Query Alloc Block Size | NA | ||
QUERY_PREALLOC_SIZE |
Query Prealloc Size | NA | ||
READ_BUFFER_SIZE |
Read Buffer Size | NA | ||
READ_RND_BUFFER_SIZE |
Read Rnd Buffer Size | NA | ||
SORT_BUFFER_SIZE |
Sort Buffer Size | NA | ||
STORED_PROGRAM_CACHE |
Stored Program Cache | NA | ||
THREAD_STACK |
Thread Stack | NA | ||
TRANSACTION_ALLOC_BLOCK_SIZE |
Transaction Alloc Block Size | NA | ||
TRANSACTION_PREALLOC_SIZE |
Transaction Prealloc Size | NA |
Metadata (Metadata) — configuration snapshot, collected every 24 Hr
Configuration snapshot of the server’s Metadata settings, captured for configuration history and compliance evaluation.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
LICENSE |
License | NA | ||
PROTOCOL_VERSION |
Protocol Version | NA | ||
VERSION |
Version | NA | ||
VERSION_COMMENT |
Version Comment | NA | ||
VERSION_COMPILE_MACHINE |
Version Compile Machine | NA | ||
VERSION_COMPILE_OS |
Version Compile OS | NA |
Replication Source Configuration (ReplicationSourceConfig) — configuration snapshot, collected every 24 Hr
Configuration snapshot of the server’s Replication Source Configuration settings, captured for configuration history and compliance evaluation.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
AUTO_INCREMENT_INCREMENT |
Auto Increment Increment | NA | ||
AUTO_INCREMENT_OFFSET |
Auto Increment Offset | NA | ||
ENFORCE_GTID_CONSISTENCY |
Enforce Gtid Consistency | NA | ||
GTID_EXECUTED |
Gtid Executed | NA | ||
GTID_EXECUTED_COMPRESS_PERIOD |
Gtid Executed Compression Period | NA | ||
GTID_MODE |
Gtid Mode | NA | ||
GTID_OWNED |
Gtid Owned | NA | ||
GTID_PURGED |
Gtid Purged | NA | ||
SEMI_SYNC_SOURCE_ENABLED |
Semi Sync Source Enabled | NA | ||
SEMI_SYNC_SOURCE_TIMEOUT |
Semi Sync Source Timeout | NA | ||
SEMI_SYNC_SOURCE_TRACE_LEVEL |
Semi Sync Source Trace Level | NA | ||
SEMI_SYNC_SRC_WAIT_NO_REPLICA |
Semi Sync Source Wait No Replica | NA | ||
SERVER_ID |
Server Id | NA | ||
SOURCE_VERIFY_CHECKSUM |
Source Verify Checksum | NA |
Replication Replica Configuration (ReplicationReplicaConfig) — configuration snapshot, collected every 24 Hr
Configuration snapshot of the server’s Replication Replica Configuration settings, captured for configuration history and compliance evaluation.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
ALLOW_BATCHING |
Allow Batching | NA | ||
CHECKPOINT_GROUP |
Checkpoint Group | NA | ||
CHECKPOINT_PERIOD |
Checkpoint Period | NA | ||
COMPRESSED_PROTOCOL |
Compressed Protocol | NA | ||
EXEC_MODE |
Exec Mode | NA | ||
GTID_MODE |
Gtid Mode | NA | ||
INIT_REPLICA |
Init Replica | NA | ||
LOAD_TMPDIR |
Load Tmpdir | NA | ||
LOG_REPLICA_UPDATES |
Log Replica Updates | NA | ||
MAX_ALLOWED_PACKET |
Max Allowed Packet | NA | ||
MAX_RELAY_LOG_SIZE |
Max Relay Log Size | NA | ||
NET_TIMEOUT |
Net Timeout | NA | ||
PARALLEL_TYPE |
Parallel Type | NA | ||
PARALLEL_WORKERS |
Parallel Workers | NA | ||
PENDING_JOBS_SIZE_MAX |
Pending Jobs Size Max | NA | ||
PRESERVE_COMMIT_ORDER |
Preserve Commit Order | NA | ||
READ_ONLY |
Read Only | NA | ||
RELAY_LOG |
Relay Log | NA | ||
RELAY_LOG_BASENAME |
Relay Log Basename | NA | ||
RELAY_LOG_INDEX |
Relay Log Index | NA | ||
RELAY_LOG_PURGE |
Relay Log Purge | NA | ||
RELAY_LOG_RECOVERY |
Relay Log Recovery | NA | ||
RELAY_LOG_SPACE_LIMIT |
Relay Log Space Limit | NA | ||
REPORT_HOST |
Report Host | NA | ||
REPORT_PORT |
Report Port | NA | ||
REPORT_USER |
Report User | NA | ||
SEMI_SYNC_REPLICA_ENABLED |
Semi Sync Replica Enabled | NA | ||
SEMI_SYNC_REPLICA_TRACE_LEVEL |
Semi Sync Replica Trace Level | NA | ||
SERVER_ID |
Server Id | NA | ||
SKIP_ERRORS |
Skip Errors | NA | ||
SQL_VERIFY_CHECKSUM |
Sql Verify Checksum | NA | ||
SYNC_SOURCE_INFO |
Sync Source Info | NA | ||
SYNC_RELAY_LOG |
Sync Relay Log | NA | ||
SYNC_RELAY_LOG_INFO |
Sync Relay Log Info | NA | ||
TRANSACTION_RETRIES |
Transaction Retries | NA | ||
TYPE_CONVERSIONS |
Type Conversions | NA |
Information Schema Configuration (InformationSchema) — configuration snapshot, collected every 24 Hr
Configuration snapshot of the server’s Information Schema Configuration settings, captured for configuration history and compliance evaluation.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
STATS_EXPIRY |
Stats Expiry | NA |
Data Dictionary Configuration (DataDictionary) — configuration snapshot, collected every 24 Hr
Configuration snapshot of the server’s Data Dictionary Configuration settings, captured for configuration history and compliance evaluation.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
SCHEMA_DEFINITION_CACHE |
Schema Definition Cache | NA | ||
TABLE_DEFINITION_CACHE |
Table Definition Cache | NA | ||
TABLESPACE_DEFINITION_CACHE |
Tablespace Definition Cache | NA | ||
STORED_PROGRAM_DEF_CACHE |
Stored Program Definition Cache | NA |
Binary Logs (BinaryLogs) — configuration snapshot, collected every 24 Hr
Configuration snapshot of the server’s Binary Logs settings, captured for configuration history and compliance evaluation.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
BINLOG_CACHE_SIZE |
Binlog Cache Size | NA | ||
BINLOG_CHECKSUM |
Binlog Checksum | NA | ||
BINLOG_DIRECT_NON_TRX_UPDATES |
Binlog Direct Non Trx Updates | NA | ||
BINLOG_ERROR_ACTION |
Binlog Error Action | NA | ||
BINLOG_EXPIRE_LOGS_SECONDS |
Binlog Expire Logs Seconds | NA | ||
BINLOG_FORMAT |
Binlog Format | NA | ||
BINLOG_GROUP_COMMIT_SYNC_DELAY |
Binlog Group Commit Sync Delay | NA | ||
BINLOG_GROUP_COMMIT_SYNC_NDC |
Binlog Group Commit Sync Ndc | NA | ||
BINLOG_GTID_SIMPLE_RECOVERY |
Binlog Gtid Simple Recovery | NA | ||
BINLOG_MAX_FLUSH_QUEUE_TIME |
Binlog Max Flush Queue Time | NA | ||
BINLOG_ORDER_COMMITS |
Binlog Order Commits | NA | ||
BINLOG_ROW_IMAGE |
Binlog Row Image | NA | ||
BINLOG_ROW_METADATA |
Binlog Row Metadata | NA | ||
BINLOG_ROWS_QUERY_LOG_EVENT |
Binlog Rows Query Log Event | NA | ||
BINLOG_ROW_VALUE_OPTIONS |
Binlog Row Value Options | NA | ||
BINLOG_STMT_CACHE_SIZE |
Binlog Stmt Cache Size | NA | ||
BINLOG_TRX_DEP_HISTORY_SIZE |
Binlog Trx Dep History Size | NA | ||
BINLOG_TRUST_FUNC_CREATORS |
Binlog Trust Func Creators | NA | ||
LOG_BIN_BASENAME |
Log Bin Basename | NA | ||
LOG_BIN |
Log Bin | NA | ||
LOG_BIN_INDEX |
Log Bin Index | NA | ||
MAX_BINLOG_CACHE_SIZE |
Max Binlog Cache Size | NA | ||
MAX_BINLOG_SIZE |
Max Binlog Size | NA | ||
MAX_BINLOG_STMT_CACHE_SIZE |
Max Binlog Stmt Cache Size | NA | ||
SYNC_BINLOG |
Sync Binlog | NA |
Secure Connections (SecureConnections) — configuration snapshot, collected every 24 Hr
Configuration snapshot of the server’s Secure Connections settings, captured for configuration history and compliance evaluation.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
CA |
Ca | NA | ||
CA_PATH |
Ca Path | NA | ||
CERT |
Cert | NA | ||
CIPHER |
Cipher | NA | ||
CRL |
Crl | NA | ||
CRL_PATH |
Crl Path | NA | ||
KEY |
Key | NA | ||
TLS_VERSION |
Tls Version | NA | ||
REQUIRE_SECURE_TRANSPORT |
Require Secure Transport | NA |
Audit Log (AuditLog) — configuration snapshot, collected every 24 Hr
Configuration snapshot of the server’s Audit Log settings, captured for configuration history and compliance evaluation.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
BUFFER_SIZE |
Buffer Size | NA | ||
CONN_POLICY |
Conn Policy | NA | ||
ENABLED_STATE |
Enabled State | NA | ||
EXCLUDE_ACCOUNTS |
Exclude Accounts | NA | ||
AUDIT_LOG_FILE |
Audit Log File | NA | ||
FLUSH |
Flush | NA | ||
FORMAT |
Format | NA | ||
INCLUDE_ACCOUNTS |
Include Accounts | NA | ||
POLICY |
Policy | NA | ||
ROTATE_ON_SIZE |
Rotate On Size | NA | ||
STMT_POLICY |
Stmt Policy | NA | ||
STRATEGY |
Strategy | NA |
Firewall (Firewall) — configuration snapshot, collected every 24 Hr
Configuration snapshot of the server’s Firewall settings, captured for configuration history and compliance evaluation.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
MAX_QUERY_SIZE |
Max Query Size | NA | ||
FIREWALL_MODE |
Firewall Mode | NA | ||
TRACE |
Trace | NA |
Connection (Connection) — configuration snapshot, collected every 24 Hr
Configuration snapshot of the server’s Connection settings, captured for configuration history and compliance evaluation.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
BACK_LOG |
Back Log | NA | ||
CONNECT_TIMEOUT |
Connect Timeout | NA | ||
INIT_CONNECT |
Init Connect | NA | ||
INTERACTIVE_TIMEOUT |
Interactive Timeout | NA | ||
MAX_CONNECT_ERRORS |
Max Connect Errors | NA | ||
MAX_CONNECTIONS |
Max Connections | NA | ||
MAX_USER_CONNECTIONS |
Max User Connections | NA | ||
NET_BUFFER_LENGTH |
Net Buffer Length | NA | ||
NET_READ_TIMEOUT |
Net Read Timeout | NA | ||
NET_RETRY_COUNT |
Net Retry Count | NA | ||
NET_WRITE_TIMEOUT |
Net Write Timeout | NA | ||
OFFLINE_MODE |
Offline Mode | NA | ||
SESSION_TRACK_GTIDS |
Session Track Gtids | NA | ||
SESSION_TRACK_SCHEMA |
Session Track Schema | NA | ||
SESSION_TRACK_STATE_CHANGE |
Session Track State Change | NA | ||
SESSION_TRACK_SYSTEM_VARIABLES |
Session Track System Variables | NA | ||
SKIP_NAME_RESOLVE |
Skip Name Resolve | NA | ||
WAIT_TIMEOUT |
Wait Timeout | NA |
Connection (ConnectionLive) — collected on demand
Real-time mirror of the Connection configuration snapshot — the same connection-related server variables, refreshed on demand instead of on the configuration schedule.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
BACK_LOG |
Back Log | NA | ||
CONNECT_TIMEOUT |
Connect Timeout | NA | ||
INIT_CONNECT |
Init Connect | NA | ||
INTERACTIVE_TIMEOUT |
Interactive Timeout | NA | ||
MAX_CONNECT_ERRORS |
Max Connect Errors | NA | ||
MAX_CONNECTIONS |
Max Connections | NA | ||
MAX_USER_CONNECTIONS |
Max User Connections | NA | ||
NET_BUFFER_LENGTH |
Net Buffer Length | NA | ||
NET_READ_TIMEOUT |
Net Read Timeout | NA | ||
NET_RETRY_COUNT |
Net Retry Count | NA | ||
NET_WRITE_TIMEOUT |
Net Write Timeout | NA | ||
OFFLINE_MODE |
Offline Mode | NA | ||
SESSION_TRACK_GTIDS |
Session Track Gtids | NA | ||
SESSION_TRACK_SCHEMA |
Session Track Schema | NA | ||
SESSION_TRACK_STATE_CHANGE |
Session Track State Change | NA | ||
SESSION_TRACK_SYSTEM_VARIABLES |
Session Track System Variables | NA | ||
SKIP_NAME_RESOLVE |
Skip Name Resolve | NA | ||
WAIT_TIMEOUT |
Wait Timeout | NA |
Environment (Environment) — configuration snapshot, collected every 24 Hr
Configuration snapshot of the server’s Environment settings, captured for configuration history and compliance evaluation.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
BASEDIR |
Basedir | NA | ||
CORE_FILE |
Core File | NA | ||
DATADIR |
Datadir | NA | ||
HOSTNAME |
Hostname | NA | ||
INIT_FILE |
Init File | NA | ||
KEEP_FILES_ON_CREATE |
Keep Files On Create | NA | ||
LARGE_FILES_SUPPORT |
Large Files Support | NA | ||
LARGE_PAGES |
Large Pages | NA | ||
LARGE_PAGE_SIZE |
Large Page Size | NA | ||
LOCKED_IN_MEMORY |
Locked In Memory | NA | ||
LOWER_CASE_FILE_SYSTEM |
Lower Case File System | NA | ||
OPEN_FILES_LIMIT |
Open Files Limit | NA | ||
PERSISTED_GLOBALS_LOAD |
Persisted Globals Load | NA | ||
PID_FILE |
Pid File | NA | ||
PLUGIN_DIR |
Plugin Dir | NA | ||
SKIP_EXTERNAL_LOCKING |
Skip External Locking | NA | ||
SQL_MODE |
Sql Mode | NA | ||
TMPDIR |
Tmpdir | NA |
HostCache (HostCache) — configuration snapshot, collected every 24 Hr
Configuration snapshot of the server’s HostCache settings, captured for configuration history and compliance evaluation.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
HOST_CACHE_SIZE |
Host Cache Size | NA |
Threads (Threads) — configuration snapshot, collected every 24 Hr
Configuration snapshot of the server’s Threads settings, captured for configuration history and compliance evaluation.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
THREAD_CACHE_SIZE |
Thread Cache Size | NA | ||
THREAD_HANDLING |
Thread Handling | NA | ||
SLOW_LAUNCH_TIME |
Slow Launch Time | NA | ||
THREAD_STACK |
Thread Stack | NA |
Threads (ThreadsLive) — collected on demand
Real-time mirror of the Threads configuration snapshot — the same thread-handling server variables, refreshed on demand instead of on the configuration schedule.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
THREAD_CACHE_SIZE |
Thread Cache Size | NA | ||
THREAD_HANDLING |
Thread Handling | NA | ||
SLOW_LAUNCH_TIME |
Slow Launch Time | NA | ||
THREAD_STACK |
Thread Stack | NA |
Transactions (Transactions) — configuration snapshot, collected every 24 Hr
Configuration snapshot of the server’s Transactions settings, captured for configuration history and compliance evaluation.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
AUTOCOMMIT |
Autocommit | NA | ||
COMPLETION_TYPE |
Completion Type | NA | ||
TRANSACTION_ISOLATION |
Transaction Isolation | NA | ||
TRANSACTION_READ_ONLY |
Transaction Read Only | NA |
Networking (Networking) — configuration snapshot, collected every 24 Hr
Configuration snapshot of the server’s Networking settings, captured for configuration history and compliance evaluation.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
BIND_ADDRESS |
Bind Address | NA | ||
PORT |
Port | NA | ||
SKIP_NAME_RESOLVE |
Skip Name Resolve | NA | ||
SKIP_NETWORKING |
Skip Networking | NA | ||
SOCKET |
Socket | NA |
Optimizer (Optimizer) — configuration snapshot, collected every 24 Hr
Configuration snapshot of the server’s Optimizer settings, captured for configuration history and compliance evaluation.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
END_MARKERS_IN_JSON |
End Markers In Json | NA | ||
EQ_RANGE_INDEX_DIVE_LIMIT |
Eq Range Index Dive Limit | NA | ||
HISTOGRAM_GEN_MAX_MEM_SIZE |
Histogram Gen Max Mem Size | NA | ||
MAX_LENGTH_FOR_SORT_DATA |
Max Length For Sort Data | NA | ||
MAX_SEEKS_FOR_KEY |
Max Seeks For Key | NA | ||
MAX_SORT_LENGTH |
Max Sort Length | NA | ||
PRUNE_LEVEL |
Prune Level | NA | ||
RANGE_ALLOC_BLOCK_SIZE |
Range Alloc Block Size | NA | ||
SEARCH_DEPTH |
Search Depth | NA | ||
SWITCH_VALUE |
Switch Value | NA | ||
TRACE |
Trace | NA | ||
TRACE_FEATURES |
Trace Features | NA | ||
TRACE_LIMIT |
Trace Limit | NA | ||
TRACE_MAX_MEM_SIZE |
Trace Max Mem Size | NA | ||
TRACE_OFFSET |
Trace Offset | NA | ||
WINDOWING_USE_HIGH_PRECISION |
Windowing Use High Precision | NA |
Optimizer (OptimizerLive) — collected on demand
Real-time mirror of the Optimizer configuration snapshot — the same query optimizer server variables, refreshed on demand instead of on the configuration schedule.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
END_MARKERS_IN_JSON |
End Markers In Json | NA | ||
EQ_RANGE_INDEX_DIVE_LIMIT |
Eq Range Index Dive Limit | NA | ||
HISTOGRAM_GEN_MAX_MEM_SIZE |
Histogram Gen Max Mem Size | NA | ||
MAX_LENGTH_FOR_SORT_DATA |
Max Length For Sort Data | NA | ||
MAX_SEEKS_FOR_KEY |
Max Seeks For Key | NA | ||
MAX_SORT_LENGTH |
Max Sort Length | NA | ||
PRUNE_LEVEL |
Prune Level | NA | ||
RANGE_ALLOC_BLOCK_SIZE |
Range Alloc Block Size | NA | ||
SEARCH_DEPTH |
Search Depth | NA | ||
SWITCH_VALUE |
Switch Value | NA | ||
TRACE |
Trace | NA | ||
TRACE_FEATURES |
Trace Features | NA | ||
TRACE_LIMIT |
Trace Limit | NA | ||
TRACE_MAX_MEM_SIZE |
Trace Max Mem Size | NA | ||
TRACE_OFFSET |
Trace Offset | NA | ||
WINDOWING_USE_HIGH_PRECISION |
Windowing Use High Precision | NA |
Logging (Logging) — configuration snapshot, collected every 24 Hr
Configuration snapshot of the server’s Logging settings, captured for configuration history and compliance evaluation.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
GENERAL_LOG |
General Log | NA | ||
GENERAL_LOG_FILE |
General Log File | NA | ||
LOG_ERROR |
Log Error | NA | ||
LOG_ERROR_SERVICES |
Log Error Services | NA | ||
LOG_ERROR_VERBOSITY |
Log Error Verbosity | NA | ||
LOG_OUTPUT |
Log Output | NA | ||
LOG_TIMESTAMPS |
Log Timestamps | NA | ||
SQL_LOG_DISABLED |
Sql Log Disabled | NA |
Slow Query Logging (SlowQueryLogging) — configuration snapshot, collected every 24 Hr
Configuration snapshot of the server’s Slow Query Logging settings, captured for configuration history and compliance evaluation.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
LOG_QUERIES_NOT_USING_INDEXES |
Log Queries Not Using Indexes | NA | ||
LOG_SLOW_ADMIN_STMTS |
Log Slow Admin Stmts | NA | ||
LOG_SLOW_QUERIES |
Log Slow Queries | NA | ||
LOG_SLOW_SLAVE_STMTS |
Log Slow Slave Stmts | NA | ||
THROTTLE_STMTS_NOT_INDX |
Throttle Stmts Not Indx | NA | ||
LONG_QUERY_TIME |
Long Query Time | NA | ||
MIN_EXAMINED_ROW_LIMIT |
Min Examined Row Limit | NA | ||
SLOW_QUERY_LOG_FILE |
Slow Query Log File | NA |
Statement Processing (StatementProcessing) — configuration snapshot, collected every 24 Hr
Configuration snapshot of the server’s Statement Processing settings, captured for configuration history and compliance evaluation.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
AUTO_IS_NULL |
Auto Is Null | NA | ||
BIG_SELECTS |
Big Selects | NA | ||
BUFFER_RESULT |
Buffer Result | NA | ||
CTE_MAX_RECURSION_DEPTH |
Cte Max Recursion Depth | NA | ||
DIV_PRECISION_INCREMENT |
Div Precision Increment | NA | ||
GROUP_CONCAT_MAX_LEN |
Group Concat Max Len | NA | ||
INTERNAL_TMP_MEM_STORAGE_ENG |
Internal Tmp Mem Storage Eng | NA | ||
MAX_DIGEST_LENGTH |
Max Digest Length | NA | ||
MAX_ERROR_COUNT |
Max Error Count | NA | ||
MAX_EXECUTION_TIME |
Max Execution Time | NA | ||
MAX_JOIN_SIZE |
Max Join Size | NA | ||
MAX_PREPARED_STMT_COUNT |
Max Prepared Stmt Count | NA | ||
MAX_SP_RECURSION_DEPTH |
Max Sp Recursion Depth | NA | ||
MAX_WRITE_LOCK_COUNT |
Max Write Lock Count | NA | ||
NOTES |
Notes | NA | ||
QUOTE_SHOW_CREATE |
Quote Show Create | NA | ||
SAFE_UPDATES |
Safe Updates | NA | ||
SELECT_LIMIT |
Select Limit | NA | ||
TEMPTABLE_MAX_RAM |
Temptable Max Ram | NA | ||
WARNINGS |
Warnings | NA |
Statement Processing (StatementProcessingLive) — collected on demand
Real-time mirror of the Statement Processing configuration snapshot — the same statement-processing server variables, refreshed on demand instead of on the configuration schedule.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
AUTO_IS_NULL |
Auto Is Null | NA | ||
BIG_SELECTS |
Big Selects | NA | ||
BUFFER_RESULT |
Buffer Result | NA | ||
CTE_MAX_RECURSION_DEPTH |
Cte Max Recursion Depth | NA | ||
DIV_PRECISION_INCREMENT |
Div Precision Increment | NA | ||
GROUP_CONCAT_MAX_LEN |
Group Concat Max Len | NA | ||
INTERNAL_TMP_MEM_STORAGE_ENG |
Internal Tmp Mem Storage Eng | NA | ||
MAX_DIGEST_LENGTH |
Max Digest Length | NA | ||
MAX_ERROR_COUNT |
Max Error Count | NA | ||
MAX_EXECUTION_TIME |
Max Execution Time | NA | ||
MAX_JOIN_SIZE |
Max Join Size | NA | ||
MAX_PREPARED_STMT_COUNT |
Max Prepared Stmt Count | NA | ||
MAX_SP_RECURSION_DEPTH |
Max Sp Recursion Depth | NA | ||
MAX_WRITE_LOCK_COUNT |
Max Write Lock Count | NA | ||
NOTES |
Notes | NA | ||
QUOTE_SHOW_CREATE |
Quote Show Create | NA | ||
SAFE_UPDATES |
Safe Updates | NA | ||
SELECT_LIMIT |
Select Limit | NA | ||
TEMPTABLE_MAX_RAM |
Temptable Max Ram | NA | ||
WARNINGS |
Warnings | NA |
MyISAM (Myisam) — configuration snapshot, collected every 24 Hr
Configuration snapshot of the server’s MyISAM settings, captured for configuration history and compliance evaluation.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
CONCURRENT_INSERT |
Concurrent Insert | NA | ||
DELAY_KEY_WRITE |
Delay Key Write | NA | ||
KEEP_FILES_ON_CREATE |
Keep Files On Create | NA | ||
KEY_BUFFER_SIZE |
Key Buffer Size | NA | ||
KEY_CACHE_AGE_THRESHOLD |
Key Cache Age Threshold | NA | ||
KEY_CACHE_BLOCK_SIZE |
Key Cache Block Size | NA | ||
KEY_CACHE_DIVISION_LIMIT |
Key Cache Division Limit | NA | ||
MYISAM_DATA_POINTER_SIZE |
Myisam Data Pointer Size | NA | ||
MYISAM_MAX_SORT_FILE_SIZE |
Myisam Max Sort File Size | NA | ||
MYISAM_MMAP_SIZE |
Myisam Mmap Size | NA | ||
MYISAM_RECOVER_OPTIONS |
Myisam Recover Options | NA | ||
MYISAM_SORT_BUFFER_SIZE |
Myisam Sort Buffer Size | NA | ||
MYISAM_STATS_METHOD |
Myisam Stats Method | NA | ||
MYISAM_USE_MMAP |
Myisam Use Mmap | NA | ||
SKIP_EXTERNAL_LOCKING |
Skip External Locking | NA |
MyISAM Full-Text (MyisamFullText) — configuration snapshot, collected every 24 Hr
Configuration snapshot of the server’s MyISAM Full-Text settings, captured for configuration history and compliance evaluation.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
BOOLEAN_SYNTAX |
Boolean Syntax | NA | ||
MAX_WORD_LEN |
Max Word Len | NA | ||
MIN_WORD_LEN |
Min Word Len | NA | ||
QUERY_EXPANSION_LIMIT |
Query Expansion Limit | NA | ||
STOPWORD_FILE |
Stopword File | NA |
Table Configuration (TableConfiguration) — configuration snapshot, collected every 24 Hr
Configuration snapshot of the server’s Table Configuration settings, captured for configuration history and compliance evaluation.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
BIG_TABLES |
Big Tables | NA | ||
DEFAULT_STORAGE_ENGINE |
Default Storage Engine | NA | ||
DEFAULT_TMP_STORAGE_ENGINE |
Default Tmp Storage Engine | NA | ||
EXPLICIT_DEFAULT_FOR_TS |
Explicit Default For Ts | NA | ||
FLUSH |
Flush | NA | ||
FLUSH_TIME |
Flush Time | NA | ||
LOCK_WAIT_TIMEOUT |
Lock Wait Timeout | NA | ||
LOWER_CASE_FILE_SYSTEM |
Lower Case File System | NA | ||
LOWER_CASE_TABLE_NAMES |
Lower Case Table Names | NA | ||
LOW_PRIORITY_UPDATES |
Low Priority Updates | NA | ||
MAX_HEAP_TABLE_SIZE |
Max Heap Table Size | NA | ||
OLD_ALTER_TABLE |
Old Alter Table | NA | ||
OPEN_FILES_LIMIT |
Open Files Limit | NA | ||
TABLE_DEFINITION_CACHE |
Table Definition Cache | NA | ||
TABLE_OPEN_CACHE |
Table Open Cache | NA | ||
TABLE_OPEN_CACHE_INSTANCES |
Table Open Cache Instances | NA | ||
TMP_TABLE_SIZE |
Tmp Table Size | NA | ||
UPDATABLE_VIEWS_WITH_LIMIT |
Updatable Views With Limit | NA |
Table Configuration (TableConfigurationLive) — collected on demand
Real-time mirror of the Table Configuration configuration snapshot — the same table-handling server variables, refreshed on demand instead of on the configuration schedule.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
BIG_TABLES |
Big Tables | NA | ||
DEFAULT_STORAGE_ENGINE |
Default Storage Engine | NA | ||
DEFAULT_TMP_STORAGE_ENGINE |
Default Tmp Storage Engine | NA | ||
EXPLICIT_DEFAULT_FOR_TS |
Explicit Default For Ts | NA | ||
FLUSH |
Flush | NA | ||
FLUSH_TIME |
Flush Time | NA | ||
LOCK_WAIT_TIMEOUT |
Lock Wait Timeout | NA | ||
LOWER_CASE_FILE_SYSTEM |
Lower Case File System | NA | ||
LOWER_CASE_TABLE_NAMES |
Lower Case Table Names | NA | ||
LOW_PRIORITY_UPDATES |
Low Priority Updates | NA | ||
MAX_HEAP_TABLE_SIZE |
Max Heap Table Size | NA | ||
OLD_ALTER_TABLE |
Old Alter Table | NA | ||
OPEN_FILES_LIMIT |
Open Files Limit | NA | ||
TABLE_DEFINITION_CACHE |
Table Definition Cache | NA | ||
TABLE_OPEN_CACHE |
Table Open Cache | NA | ||
TABLE_OPEN_CACHE_INSTANCES |
Table Open Cache Instances | NA | ||
TMP_TABLE_SIZE |
Tmp Table Size | NA | ||
UPDATABLE_VIEWS_WITH_LIMIT |
Updatable Views With Limit | NA |
Collation (Collation) — configuration snapshot, collected every 24 Hr
Configuration snapshot of the server’s Collation settings, captured for configuration history and compliance evaluation.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
CONN |
Conn | NA | ||
DATABASE |
Database | NA | ||
SERVER_DEFAULT |
Server Default | NA |
Localization (Localization) — configuration snapshot, collected every 24 Hr
Configuration snapshot of the server’s Localization settings, captured for configuration history and compliance evaluation.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
DEFAULT_WEEK_FORMAT |
Default Week Format | NA | ||
MESSAGES |
Messages | NA | ||
MESSAGES_DIR |
Messages Dir | NA | ||
SYSTEM_TIME_ZONE |
System Time Zone | NA | ||
TIME_NAMES |
Time Names | NA | ||
TIME_ZONE |
Time Zone | NA |
InnoDB Configuration (InnodbConfiguration) — configuration snapshot, collected every 24 Hr
Configuration snapshot of the server’s InnoDB Configuration settings, captured for configuration history and compliance evaluation.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
ADAPTIVE_FLUSHING |
Adaptive Flushing | NA | ||
ADAPTIVE_FLUSHING_LWM |
Adaptive Flushing Lwm | NA | ||
ADAPTIVE_HASH_INDEX |
Adaptive Hash Index | NA | ||
ADAPTIVE_MAX_SLEEP_DELAY |
Adaptive Max Sleep Delay | NA | ||
AUTOEXTEND_INCREMENT |
Autoextend Increment | NA | ||
AUTOINC_LOCK_MODE |
Autoinc Lock Mode | NA | ||
BUFFER_POOL_CHUNK_SIZE |
Buffer Pool Chunk Size | NA | ||
BUFFER_POOL_DUMP_AT_SHUTDOWN |
Buffer Pool Dump At Shutdown | NA | ||
BUFFER_POOL_DUMP_NOW |
Buffer Pool Dump Now | NA | ||
BUFFER_POOL_DUMP_PCT |
Buffer Pool Dump Pct | NA | ||
BUFFER_POOL_FILENAME |
Buffer Pool Filename | NA | ||
BUFFER_POOL_INSTANCES |
Buffer Pool Instances | NA | ||
BUFFER_POOL_LOAD_AT_STARTUP |
Buffer Pool Load At Startup | NA | ||
BUFFER_POOL_LOAD_NOW |
Buffer Pool Load Now | NA | ||
BUFFER_POOL_SIZE |
Buffer Pool Size | NA | ||
CHANGE_BUFFERING |
Change Buffering | NA | ||
CHANGE_BUFFER_MAX_SIZE |
Change Buffer Max Size | NA | ||
CHECKSUM_ALGORITHM |
Checksum Algorithm | NA | ||
COMMIT_CONCURRENCY |
Commit Concurrency | NA | ||
COMPRESSION_LEVEL |
Compression Level | NA | ||
COMPRESSION_PAD_PCT_MAX |
Compression Pad Pct Max | NA | ||
CONCURRENCY_TICKETS |
Concurrency Tickets | NA | ||
DATA_FILE_PATH |
Data File Path | NA | ||
DATA_HOME_DIR |
Data Home Dir | NA | ||
DEDICATED_SERVER |
Dedicated Server | NA | ||
DISABLE_SORT_FILE_CACHE |
Disable Sort File Cache | NA | ||
DOUBLEWRITE |
Doublewrite | NA | ||
FAST_SHUTDOWN |
Fast Shutdown | NA | ||
FILE_PER_TABLE |
File Per Table | NA | ||
FILL_FACTOR |
Fill Factor | NA | ||
FLUSHING_AVG_LOOPS |
Flushing Avg Loops | NA | ||
FLUSH_LOG_AT_TIMEOUT |
Flush Log At Timeout | NA | ||
FLUSH_LOG_AT_TRX_COMMIT |
Flush Log At Trx Commit | NA | ||
FLUSH_METHOD |
Flush Method | NA | ||
FLUSH_NEIGHBORS |
Flush Neighbors | NA | ||
FORCE_LOAD_CORRUPTED |
Force Load Corrupted | NA | ||
FORCE_RECOVERY |
Force Recovery | NA | ||
FOREIGN_KEY_CHECKS |
Foreign Key Checks | NA | ||
IO_CAPACITY |
Io Capacity | NA | ||
IO_CAPACITY_MAX |
Io Capacity Max | NA | ||
LOCK_WAIT_TIMEOUT |
Lock Wait Timeout | NA | ||
LOG_BUFFER_SIZE |
Log Buffer Size | NA | ||
LOG_COMPRESSED_PAGES |
Log Compressed Pages | NA | ||
LOG_FILES_IN_GROUP |
Log Files In Group | NA | ||
LOG_FILE_SIZE |
Log File Size | NA | ||
LOG_GROUP_HOME_DIR |
Log Group Home Dir | NA | ||
LOG_WRITE_AHEAD_SIZE |
Log Write Ahead Size | NA | ||
LRU_SCAN_DEPTH |
Lru Scan Depth | NA | ||
MAX_DIRTY_PAGES_PCT |
Max Dirty Pages Pct | NA | ||
MAX_DIRTY_PAGES_PCT_LWM |
Max Dirty Pages Pct Lwm | NA | ||
MAX_PURGE_LAG |
Max Purge Lag | NA | ||
MAX_PURGE_LAG_DELAY |
Max Purge Lag Delay | NA | ||
MAX_UNDO_LOG_SIZE |
Max Undo Log Size | NA | ||
MONITOR_DISABLE |
Monitor Disable | NA | ||
MONITOR_ENABLE |
Monitor Enable | NA | ||
MONITOR_RESET |
Monitor Reset | NA | ||
MONITOR_RESET_ALL |
Monitor Reset All | NA | ||
OLD_BLOCKS_PCT |
Old Blocks Pct | NA | ||
OLD_BLOCKS_TIME |
Old Blocks Time | NA | ||
ONLINE_ALTER_LOG_MAX_SIZE |
Online Alter Log Max Size | NA | ||
OPEN_FILES |
Open Files | NA | ||
PAGE_CLEANERS |
Page Cleaners | NA | ||
PAGE_SIZE |
Page Size | NA | ||
PRINT_ALL_DEADLOCKS |
Print All Deadlocks | NA | ||
PRINT_DDL_LOGS |
Print Ddl Logs | NA | ||
PURGE_BATCH_SIZE |
Purge Batch Size | NA | ||
PURGE_RSEG_TRUNCATE_FREQUENCY |
Purge Rseg Truncate Frequency | NA | ||
PURGE_THREADS |
Purge Threads | NA | ||
RANDOM_READ_AHEAD |
Random Read Ahead | NA | ||
READ_AHEAD_THRESHOLD |
Read Ahead Threshold | NA | ||
READ_IO_THREADS |
Read Io Threads | NA | ||
READ_ONLY |
Read Only | NA | ||
REDO_LOG_ENCRYPT |
Redo Log Encrypt | NA | ||
ROLLBACK_ON_TIMEOUT |
Rollback On Timeout | NA | ||
SORT_BUFFER_SIZE |
Sort Buffer Size | NA | ||
SPIN_WAIT_DELAY |
Spin Wait Delay | NA | ||
STATS_AUTO_RECALC |
Stats Auto Recalc | NA | ||
STATS_METHOD |
Stats Method | NA | ||
STATS_ON_METADATA |
Stats On Metadata | NA | ||
STATS_PERSISTENT |
Stats Persistent | NA | ||
STATS_PERSISTENT_SAMPLE_PAGES |
Stats Persistent Sample Pages | NA | ||
STRICT_MODE |
Strict Mode | NA | ||
SYNC_ARRAY_SIZE |
Sync Array Size | NA | ||
SYNC_SPIN_LOOPS |
Sync Spin Loops | NA | ||
TABLE_LOCKS |
Table Locks | NA | ||
TEMP_DATA_FILE_PATH |
Temp Data File Path | NA | ||
THREAD_CONCURRENCY |
Thread Concurrency | NA | ||
THREAD_SLEEP_DELAY |
Thread Sleep Delay | NA | ||
UNDO_DIRECTORY |
Undo Directory | NA | ||
UNDO_LOG_ENCRYPT |
Undo Log Encrypt | NA | ||
UNDO_LOG_TRUNCATE |
Undo Log Truncate | NA | ||
UNDO_TABLESPACES |
Undo Tablespaces | NA | ||
UNIQUE_CHECKS |
Unique Checks | NA | ||
USE_NATIVE_AIO |
Use Native Aio | NA | ||
WRITE_IO_THREADS |
Write Io Threads | NA |
InnoDB Configuration (InnodbConfigurationLive) — collected on demand
Real-time mirror of the InnoDB Configuration configuration snapshot — the same InnoDB server variables, refreshed on demand instead of on the configuration schedule.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
ADAPTIVE_FLUSHING |
Adaptive Flushing | NA | ||
ADAPTIVE_FLUSHING_LWM |
Adaptive Flushing Lwm | NA | ||
ADAPTIVE_HASH_INDEX |
Adaptive Hash Index | NA | ||
ADAPTIVE_MAX_SLEEP_DELAY |
Adaptive Max Sleep Delay | NA | ||
AUTOEXTEND_INCREMENT |
Autoextend Increment | NA | ||
AUTOINC_LOCK_MODE |
Autoinc Lock Mode | NA | ||
BUFFER_POOL_CHUNK_SIZE |
Buffer Pool Chunk Size | NA | ||
BUFFER_POOL_DUMP_AT_SHUTDOWN |
Buffer Pool Dump At Shutdown | NA | ||
BUFFER_POOL_DUMP_NOW |
Buffer Pool Dump Now | NA | ||
BUFFER_POOL_DUMP_PCT |
Buffer Pool Dump Pct | NA | ||
BUFFER_POOL_FILENAME |
Buffer Pool Filename | NA | ||
BUFFER_POOL_INSTANCES |
Buffer Pool Instances | NA | ||
BUFFER_POOL_LOAD_AT_STARTUP |
Buffer Pool Load At Startup | NA | ||
BUFFER_POOL_LOAD_NOW |
Buffer Pool Load Now | NA | ||
BUFFER_POOL_SIZE |
Buffer Pool Size | NA | ||
CHANGE_BUFFERING |
Change Buffering | NA | ||
CHANGE_BUFFER_MAX_SIZE |
Change Buffer Max Size | NA | ||
CHECKSUM_ALGORITHM |
Checksum Algorithm | NA | ||
COMMIT_CONCURRENCY |
Commit Concurrency | NA | ||
COMPRESSION_LEVEL |
Compression Level | NA | ||
COMPRESSION_PAD_PCT_MAX |
Compression Pad Pct Max | NA | ||
CONCURRENCY_TICKETS |
Concurrency Tickets | NA | ||
DATA_FILE_PATH |
Data File Path | NA | ||
DATA_HOME_DIR |
Data Home Dir | NA | ||
DEDICATED_SERVER |
Dedicated Server | NA | ||
DISABLE_SORT_FILE_CACHE |
Disable Sort File Cache | NA | ||
DOUBLEWRITE |
Doublewrite | NA | ||
FAST_SHUTDOWN |
Fast Shutdown | NA | ||
FILE_PER_TABLE |
File Per Table | NA | ||
FILL_FACTOR |
Fill Factor | NA | ||
FLUSHING_AVG_LOOPS |
Flushing Avg Loops | NA | ||
FLUSH_LOG_AT_TIMEOUT |
Flush Log At Timeout | NA | ||
FLUSH_LOG_AT_TRX_COMMIT |
Flush Log At Trx Commit | NA | ||
FLUSH_METHOD |
Flush Method | NA | ||
FLUSH_NEIGHBORS |
Flush Neighbors | NA | ||
FORCE_LOAD_CORRUPTED |
Force Load Corrupted | NA | ||
FORCE_RECOVERY |
Force Recovery | NA | ||
FOREIGN_KEY_CHECKS |
Foreign Key Checks | NA | ||
IO_CAPACITY |
Io Capacity | NA | ||
IO_CAPACITY_MAX |
Io Capacity Max | NA | ||
LOCK_WAIT_TIMEOUT |
Lock Wait Timeout | NA | ||
LOG_BUFFER_SIZE |
Log Buffer Size | NA | ||
LOG_COMPRESSED_PAGES |
Log Compressed Pages | NA | ||
LOG_FILES_IN_GROUP |
Log Files In Group | NA | ||
LOG_FILE_SIZE |
Log File Size | NA | ||
LOG_GROUP_HOME_DIR |
Log Group Home Dir | NA | ||
LOG_WRITE_AHEAD_SIZE |
Log Write Ahead Size | NA | ||
LRU_SCAN_DEPTH |
Lru Scan Depth | NA | ||
MAX_DIRTY_PAGES_PCT |
Max Dirty Pages Pct | NA | ||
MAX_DIRTY_PAGES_PCT_LWM |
Max Dirty Pages Pct Lwm | NA | ||
MAX_PURGE_LAG |
Max Purge Lag | NA | ||
MAX_PURGE_LAG_DELAY |
Max Purge Lag Delay | NA | ||
MAX_UNDO_LOG_SIZE |
Max Undo Log Size | NA | ||
MONITOR_DISABLE |
Monitor Disable | NA | ||
MONITOR_ENABLE |
Monitor Enable | NA | ||
MONITOR_RESET |
Monitor Reset | NA | ||
MONITOR_RESET_ALL |
Monitor Reset All | NA | ||
OLD_BLOCKS_PCT |
Old Blocks Pct | NA | ||
OLD_BLOCKS_TIME |
Old Blocks Time | NA | ||
ONLINE_ALTER_LOG_MAX_SIZE |
Online Alter Log Max Size | NA | ||
OPEN_FILES |
Open Files | NA | ||
PAGE_CLEANERS |
Page Cleaners | NA | ||
PAGE_SIZE |
Page Size | NA | ||
PRINT_ALL_DEADLOCKS |
Print All Deadlocks | NA | ||
PRINT_DDL_LOGS |
Print Ddl Logs | NA | ||
PURGE_BATCH_SIZE |
Purge Batch Size | NA | ||
PURGE_RSEG_TRUNCATE_FREQUENCY |
Purge Rseg Truncate Frequency | NA | ||
PURGE_THREADS |
Purge Threads | NA | ||
RANDOM_READ_AHEAD |
Random Read Ahead | NA | ||
READ_AHEAD_THRESHOLD |
Read Ahead Threshold | NA | ||
READ_IO_THREADS |
Read Io Threads | NA | ||
READ_ONLY |
Read Only | NA | ||
REDO_LOG_ENCRYPT |
Redo Log Encrypt | NA | ||
ROLLBACK_ON_TIMEOUT |
Rollback On Timeout | NA | ||
SORT_BUFFER_SIZE |
Sort Buffer Size | NA | ||
SPIN_WAIT_DELAY |
Spin Wait Delay | NA | ||
STATS_AUTO_RECALC |
Stats Auto Recalc | NA | ||
STATS_METHOD |
Stats Method | NA | ||
STATS_ON_METADATA |
Stats On Metadata | NA | ||
STATS_PERSISTENT |
Stats Persistent | NA | ||
STATS_PERSISTENT_SAMPLE_PAGES |
Stats Persistent Sample Pages | NA | ||
STRICT_MODE |
Strict Mode | NA | ||
SYNC_ARRAY_SIZE |
Sync Array Size | NA | ||
SYNC_SPIN_LOOPS |
Sync Spin Loops | NA | ||
TABLE_LOCKS |
Table Locks | NA | ||
TEMP_DATA_FILE_PATH |
Temp Data File Path | NA | ||
THREAD_CONCURRENCY |
Thread Concurrency | NA | ||
THREAD_SLEEP_DELAY |
Thread Sleep Delay | NA | ||
UNDO_DIRECTORY |
Undo Directory | NA | ||
UNDO_LOG_ENCRYPT |
Undo Log Encrypt | NA | ||
UNDO_LOG_TRUNCATE |
Undo Log Truncate | NA | ||
UNDO_TABLESPACES |
Undo Tablespaces | NA | ||
UNIQUE_CHECKS |
Unique Checks | NA | ||
USE_NATIVE_AIO |
Use Native Aio | NA | ||
WRITE_IO_THREADS |
Write Io Threads | NA |
Performance Schema (PerformanceSchema) — configuration snapshot, collected every 24 Hr
Configuration snapshot of the server’s Performance Schema settings, captured for configuration history and compliance evaluation.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
ACCOUNTS_SIZE |
Accounts Size | NA | ||
DIGESTS_SIZE |
Digests Size | NA | ||
ENABLED |
Enabled | NA | ||
ERROR_SIZE |
Error Size | NA | ||
STAGES_HISTORY_LONG_SIZE |
Stages History Long Size | NA | ||
EVENTS_STAGES_HISTORY_SIZE |
Events Stages History Size | NA | ||
STMTS_HISTORY_LONG_SIZE |
Stmts History Long Size | NA | ||
EVENTS_STMTS_HISTORY_SIZE |
Events Stmts History Size | NA | ||
EVENTS_TRXS_HISTORY_LONG_SIZE |
Events Trxs History Long Size | NA | ||
EVENTS_TRXS_HISTORY_SIZE |
Events Trxs History Size | NA | ||
EVENTS_WAITS_HISTORY_LONG_SIZE |
Events Waits History Long Size | NA | ||
EVENTS_WAITS_HISTORY_SIZE |
Events Waits History Size | NA | ||
HOSTS_SIZE |
Hosts Size | NA | ||
MAX_COND_CLASSES |
Max Cond Classes | NA | ||
MAX_COND_INSTANCES |
Max Cond Instances | NA | ||
MAX_DIGEST_LENGTH |
Max Digest Length | NA | ||
MAX_DIGEST_SAMPLE_AGE |
Max Digest Sample Age | NA | ||
MAX_FILE_CLASSES |
Max File Classes | NA | ||
MAX_FILE_HANDLES |
Max File Handles | NA | ||
MAX_FILE_INSTANCES |
Max File Instances | NA | ||
MAX_INDEX_STAT |
Max Index Stat | NA | ||
MAX_MEMORY_CLASSES |
Max Memory Classes | NA | ||
MAX_METADATA_LOCKS |
Max Metadata Locks | NA | ||
MAX_MUTEX_CLASSES |
Max Mutex Classes | NA | ||
MAX_MUTEX_INSTANCES |
Max Mutex Instances | NA | ||
MAX_PREPARED_STMTS_INSTANCES |
Max Prepared Stmts Instances | NA | ||
MAX_PROGRAM_INSTANCES |
Max Program Instances | NA | ||
MAX_RWLOCK_CLASSES |
Max Rwlock Classes | NA | ||
MAX_RWLOCK_INSTANCES |
Max Rwlock Instances | NA | ||
MAX_SOCKET_CLASSES |
Max Socket Classes | NA | ||
MAX_SOCKET_INSTANCES |
Max Socket Instances | NA | ||
MAX_SQL_TEXT_LENGTH |
Max Sql Text Length | NA | ||
MAX_STAGE_CLASSES |
Max Stage Classes | NA | ||
MAX_STMT_CLASSES |
Max Stmt Classes | NA | ||
MAX_STMT_STACK |
Max Stmt Stack | NA | ||
MAX_TABLE_HANDLES |
Max Table Handles | NA | ||
MAX_TABLE_INSTANCES |
Max Table Instances | NA | ||
MAX_TABLE_LOCK_STAT |
Max Table Lock Stat | NA | ||
MAX_THREAD_CLASSES |
Max Thread Classes | NA | ||
MAX_THREAD_INSTANCES |
Max Thread Instances | NA | ||
SESSION_CONNECT_ATTRS_SIZE |
Session Connect Attrs Size | NA | ||
SETUP_ACTORS_SIZE |
Setup Actors Size | NA | ||
SETUP_OBJECTS_SIZE |
Setup Objects Size | NA | ||
USERS_SIZE |
Users Size | NA |
Capabilities (Capabilities) — configuration snapshot, collected every 24 Hr
Configuration snapshot of the server’s Capabilities settings, captured for configuration history and compliance evaluation.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
CAPABILITIES_COMPRESS |
Capabilities Compress | NA | ||
DYNAMIC_LOADING |
Dynamic Loading | NA | ||
GEOMETRY_TYPES |
Geometry Types | NA | ||
PROFILING |
Profiling | NA | ||
QUERY_CACHE |
Query Cache | NA | ||
RTREE_KEYS |
Rtree Keys | NA | ||
STMT_TIMEOUT |
Stmt Timeout | NA | ||
SYMLINK |
Symlink | NA | ||
EVENT_SCHEDULER |
Event Scheduler | NA |
Binary Log Status (BinaryLogStatus) — configuration snapshot, collected every 24 Hr
Configuration snapshot of the server’s Binary Log Status settings, captured for configuration history and compliance evaluation.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
BINLOG_DO_DB |
Binlog Do DB | NA | ||
BINLOG_IGNORE_DB |
Binlog Ignore DB | NA |
Security (Security) — configuration snapshot, collected every 24 Hr
Configuration snapshot of the server’s Security settings, captured for configuration history and compliance evaluation.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
ACTIVATE_ALL_ROLES_ON_LOGIN |
Activate All Roles On Login | NA | ||
AUTO_GENERATE_CERTS |
Auto Generate Certs | NA | ||
AUTOMATIC_SP_PRIVILEGES |
Automatic Sp Privileges | NA | ||
CACHING_SHA2_PASS_PRIVKEY_PATH |
Caching Sha2 Pass Privkey Path | NA | ||
CACHING_SHA2_PASS_PUBKEY_PATH |
Caching Sha2 Pass Pubkey Path | NA | ||
CHECK_PROXY_USERS |
Check Proxy Users | NA | ||
DEFAULT_PASSWORD_LIFETIME |
Default Password Lifetime | NA | ||
DISCONNECT_ON_EXPIRED_PASSWORD |
Disconnect On Expired Password | NA | ||
LOCAL_INFILE |
Local Infile | NA | ||
MANDATORY_ROLES |
Mandatory Roles | NA | ||
MYSQL_NATIVE_PW_PROXY_USERS |
Mysql Native Pw Proxy Users | NA | ||
PASSWORD_HISTORY |
Password History | NA | ||
PASSWORD_REUSE_INTERVAL |
Password Reuse Interval | NA | ||
SECURE_FILE_PRIVILEGES |
Secure File Privileges | NA | ||
SHA256_PW_AUTO_GEN_RSA_KEYS |
Sha256 Pw Auto Gen Rsa Keys | NA | ||
SHA256_PW_PRIVATE_KEY_PATH |
Sha256 Pw Private Key Path | NA | ||
SHA256_PASSWORD_PROXY_USERS |
Sha256 Password Proxy Users | NA | ||
SHA256_PW_PUBLIC_KEY_PATH |
Sha256 Pw Public Key Path | NA | ||
SKIP_SHOW_DATABASE |
Skip Show Database | NA | ||
AUTHENTICATION_POLICY |
Authentication Policy | NA |
Password Validation (PasswordValidation) — configuration snapshot, collected every 24 Hr
Configuration snapshot of the server’s Password Validation settings, captured for configuration history and compliance evaluation.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
DICTIONARY_FILE |
Dictionary File | NA | ||
LENGTH |
Length | NA | ||
MIXED_CASE_COUNT |
Mixed Case Count | NA | ||
NUMBER_COUNT |
Number Count | NA | ||
POLICY |
Policy | NA | ||
SPECIAL_CHAR_COUNT |
Special Char Count | NA |
Security Accounts (SecurityAccounts) — configuration snapshot, collected every 24 Hr
Configuration snapshot of the server’s Security Accounts settings, captured for configuration history and compliance evaluation.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
USER_HOST (key) |
User Host | NA | ||
USER_NAME |
User | NA | ||
HOST |
Host | NA | ||
AUTH_PLUGIN |
Auth Plugin | NA | ||
ACCOUNT_LOCKED |
Account Locked | NA | ||
IS_ANONYMOUS |
Is Anonymous | NA | ||
IS_REMOTE_ROOT |
Is Remote Root | NA | ||
HAS_ALL_PRIVILEGES |
Has All Privileges | NA | ||
HAS_GRANT_OPTION |
Has Grant Option | NA | ||
HAS_FILE_PRIV |
Has File Priv | NA | ||
HAS_PROCESS_PRIV |
Has Process Priv | NA | ||
HAS_SHUTDOWN_PRIV |
Has Shutdown Priv | NA | ||
HAS_SUPER_PRIV |
Has Super Priv | NA | ||
HAS_MYSQL_SCHEMA_WRITE |
Has Mysql Schema Write | NA | ||
HAS_EMPTY_PASSWORD |
Has Empty Password | NA | ||
HAS_LOGIN_LOCKOUT |
Has Login Lockout | NA |
Security Config Ext (SecurityConfigExt) — configuration snapshot, collected every 24 Hr
Configuration snapshot of the server’s Security Config Ext settings, captured for configuration history and compliance evaluation.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
PARTIAL_REVOKES |
Partial Revokes | NA | ||
BINLOG_ENCRYPTION |
Binlog Encryption | NA | ||
DEFAULT_TABLE_ENCRYPTION |
Default Table Encryption | NA | ||
AUDIT_LOG_ENCRYPTION |
Audit Log Encryption | NA | ||
KEYRING_AVAILABLE |
Keyring Available | NA | ||
CONNECTION_CONTROL_INSTALLED |
Connection Control Installed | NA |
InnoDB Fulltext (InnodbFulltext) — configuration snapshot, collected every 24 Hr
Configuration snapshot of the server’s InnoDB Fulltext settings, captured for configuration history and compliance evaluation.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
AUX_TABLE |
Aux Table | NA | ||
CACHE_SIZE |
Cache Size | NA | ||
ENABLE_DIAG_PRINT |
Enable Diag Print | NA | ||
ENABLE_STOPWORD |
Enable Stopword | NA | ||
MAX_TOKEN_SIZE |
Max Token Size | NA | ||
MIN_TOKEN_SIZE |
Min Token Size | NA | ||
NUM_WORD_OPTIMIZE |
Num Word Optimize | NA | ||
OPTIMIZE_FULLTEXT_ONLY |
Optimize Fulltext Only | NA | ||
RESULT_CACHE_LIMIT |
Result Cache Limit | NA | ||
SERVER_STOPWORD_TABLE |
Server Stopword Table | NA | ||
SORT_PLL_DEGREE |
Sort Pll Degree | NA | ||
TOTAL_CACHE_SIZE |
Total Cache Size | NA | ||
USER_STOPWORD_TABLE |
User Stopword Table | NA |
InnoDB Memcached Configuration (InnodbMemcachedConfiguration) — configuration snapshot, collected every 24 Hr
Configuration snapshot of the server’s InnoDB Memcached Configuration settings, captured for configuration history and compliance evaluation.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
BK_COMMIT_INTERVAL |
Bk Commit Interval | NA | ||
DISABLE_ROWLOCK |
Disable Rowlock | NA | ||
ENABLE_BINLOG |
Enable Binlog | NA | ||
ENABLE_MDL |
Enable Mdl | NA | ||
ENGINE_LIB_NAME |
Engine Lib Name | NA | ||
ENGINE_LIB_PATH |
Engine Lib Path | NA | ||
OPTIONS |
Options | NA | ||
READ_BATCH_SIZE |
Read Batch Size | NA | ||
TRX_LEVEL |
Trx Level | NA | ||
WRITE_BATCH_SIZE |
Write Batch Size | NA |
Insert Delayed (InsertDelayed) — configuration snapshot, collected every 24 Hr
Configuration snapshot of the server’s Insert Delayed settings, captured for configuration history and compliance evaluation.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
INSERT_LIMIT |
Insert Limit | NA | ||
INSERT_TIMEOUT |
Insert Timeout | NA | ||
MAX_DELAYED_THREADS |
Max Delayed Threads | NA | ||
QUEUE_SIZE |
Queue Size | NA |
NDB (Ndb) — configuration snapshot, collected every 24 Hr
Configuration snapshot of the server’s NDB settings, captured for configuration history and compliance evaluation.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
ENGINE_CONDITION_PUSHDOWN |
Engine Condition Pushdown | NA | ||
NDB_AUTOINC_PREFETCH |
Ndb Autoinc Prefetch | NA |
Thread Pool (ThreadPool) — configuration snapshot, collected every 24 Hr
Configuration snapshot of the server’s Thread Pool settings, captured for configuration history and compliance evaluation.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
ALGORITHM |
Algorithm | NA | ||
HIGH_PRIORITY_CONN |
High Priority Conn | NA | ||
MAX_UNUSED_THREADS |
Max Unused Threads | NA | ||
PRIO_KICKUP_TIMER |
Prio Kickup Timer | NA | ||
THREAD_POOL_SIZE |
Thread Pool Size | NA | ||
STALL_LIMIT |
Stall Limit | NA |
Wait Profile (Top Waits) (WaitProfile) — collected every 1 Min
Top wait events by time consumed during the collection interval, as deltas from performance_schema.events_waits_summary_global_by_event_name.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
event_name (key) |
Event Name | NA | ||
wait_class |
Wait Class | NA | ||
d_count |
Wait Count | NA | ||
d_time_us |
Wait Time | MICROSEC | ||
avg_wait_us |
Avg Wait | MICROSEC |
Wait Profile Summary (WaitProfileSummary) — collected every 1 Min
Single-row summary of the interval’s wait activity — total wait time, number of active wait events, and the single busiest wait event — rolled up from the Wait Profile data.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
total_wait_time_us |
Total Wait Time | MICROSEC | ||
active_event_count |
Active Wait Events | NA | ||
top_wait_event |
Top Wait Event | NA | ||
top_wait_time_us |
Top Wait Time | MICROSEC | ||
top_wait_class |
Top Wait Class | NA |
Query Analytics (Statement Digest Deltas) (StatementDigestProfile) — collected every 5 Min
Per-statement-digest execution deltas for the collection interval — execution count, latency, rows examined/sent, and index usage — from performance_schema.events_statements_summary_by_digest.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
digest (key) |
Statement Digest | NA | ||
d_exec_count |
Executions | NA | ||
d_total_latency_us |
Total Latency | MICROSEC | ||
d_avg_latency_us |
Average Latency | MICROSEC | ||
d_lock_time_us |
Lock Time | MICROSEC | ||
d_rows_examined |
Rows Examined | NA | ||
d_rows_sent |
Rows Sent | NA | ||
d_rows_examined_per_sent |
Rows Examined per Row Sent | NA | ||
d_no_index_used |
Executions Without an Index | NA |
Query Analytics Summary (StatementDigestProfileSummary) — collected every 5 Min
Single-row summary of the interval’s statement activity — total latency, total executions, number of active digests, and the single busiest digest — rolled up from the Statement Digest Profile data.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
total_latency_us |
Total Statement Latency | MICROSEC | ||
total_exec_count |
Total Executions | NA | ||
active_digest_count |
Active Statement Digests | NA | ||
top_digest |
Top Statement Digest | NA | ||
top_digest_latency_us |
Top Statement Latency | MICROSEC | ||
digest_overflow_active |
Digest Table Overflowing | NA | ||
digest_capacity_pct |
Digest Table Used | PERCENTAGE |
License (License) — collected every 15 Min
Licence state of this plug-in installation, not of the MySQL server — the collection contacts neither the database nor the OMS. Status carries the reason (Active, Expired, Wrong Plug-in, Invalid Signature or License Required); the alert is set on the licensed column, which is 1 only when the licence is active.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
status |
Status | NA | ||
licensed |
Licensed | NA | < 1 | |
days_remaining |
Days Remaining | NA | < 30 | < 7 |
expiration |
Expiration | NA | ||
license_type |
Type | NA | ||
instances |
Instances | NA | ||
customer |
Customer | NA |
MySQL InnoDB Cluster (ip_mysql_cluster_beta)
Response (Response) — collected every 1 Min
Availability. EM derives the target’s Up/Down state from the Status column; a Status below 1 raises the target-down event.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
Status |
Status (up/down) | NA | < 1 |
Group Replication Members (GroupMembers) — collected every 5 Min
Group Replication membership — each member’s host, port, role, state, and version, from performance_schema.replication_group_members.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
member_id (key) |
Member ID | NA | ||
channel_name |
Channel Name | NA | ||
member_host |
Member Host | NA | ||
member_port |
Member Port | NA | ||
member_state |
Member State | NA | ||
member_role |
Member Role | NA | ||
member_version |
Member Version | NA |
Group Replication Member Stats (GroupMemberStats) — collected every 5 Min
Per-member Group Replication certification and applier queue statistics, from performance_schema.replication_group_member_stats.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
member_id (key) |
Member ID | NA | ||
channel_name |
Channel Name | NA | ||
view_id |
View ID | NA | ||
count_transactions_in_queue |
Count Transactions In Queue | NA | > 100 | > 1000 |
count_transactions_checked |
Count Transactions Checked | NA | ||
count_conflicts_detected |
Count Conflicts Detected | NA | ||
count_transactions_rows_validating |
Count Transactions Rows Validating | NA | ||
transactions_committed_all_members |
Transactions Committed All Members | NA | ||
last_conflict_free_transaction |
Last Conflict Free Transaction | NA | ||
count_transactions_remote_in_applier_queue |
Count Transactions Remote In Applier Queue | NA | > 100 | > 1000 |
count_transactions_remote_applied |
Count Transactions Remote Applied | NA | ||
count_transactions_local_proposed |
Count Transactions Local Proposed | NA | ||
count_transactions_local_rollback |
Count Transactions Local Rollback | NA |
Group Replication Summary (GroupSummary) — collected every 5 Min
Single-row rollup of Group Replication membership by state and role — online, recovering, unreachable, and offline member counts, and primary/secondary counts — derived from the group’s membership view.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
member_count |
Member Count | NA | ||
online_count |
Online Count | NA | ||
recovering_count |
Recovering Count | NA | ||
unreachable_count |
Unreachable Count | NA | ||
error_count |
Error Count | NA | ||
offline_count |
Offline Count | NA | ||
primary_count |
Primary Count | NA | ||
secondary_count |
Secondary Count | NA |
Group Replication Consensus (GrConsensus) — collected every 5 Min
Group Replication consensus activity for the connected member, as deltas over the collection interval — proposals, timing, and bytes sent/received — from the server’s Gr_* status counters.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
member_id (key) |
Member ID | NA | ||
consensus_proposals |
Consensus Proposals | NA | ||
consensus_time_total_us |
Consensus Time | MICROSEC | ||
avg_consensus_time_us |
Avg Consensus Time | MICROSEC | > 100000 | > 1000000 |
empty_consensus_proposals |
Empty Consensus Proposals | NA | ||
empty_proposal_pct |
Empty Proposals (%) | PERCENTAGE | ||
extended_consensus_count |
Extended Consensus Rounds | NA | ||
extended_consensus_pct |
Extended Consensus (%) | PERCENTAGE | ||
consensus_bytes_sent |
Consensus Bytes Sent | BYTE | ||
consensus_bytes_received |
Consensus Bytes Received | BYTE | ||
last_consensus_end |
Last Consensus End | NA |
Group Replication Messaging (GrMessaging) — collected every 5 Min
Group Replication messaging activity for the connected member, as deltas over the collection interval — control and data messages sent, bytes transferred, and round-trip time — from the server’s Gr_* status counters.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
member_id (key) |
Member ID | NA | ||
total_messages_sent |
Total Messages Sent | NA | ||
control_messages_sent |
Control Messages Sent | NA | ||
control_messages_bytes |
Control Message Bytes | BYTE | ||
control_roundtrip_time_us |
Control Roundtrip Time | MICROSEC | ||
avg_control_roundtrip_us |
Avg Control Roundtrip | MICROSEC | ||
data_messages_sent |
Data Messages Sent | NA | ||
data_messages_bytes |
Data Message Bytes | BYTE | ||
data_roundtrip_time_us |
Data Roundtrip Time | MICROSEC | ||
avg_data_roundtrip_us |
Avg Data Roundtrip | MICROSEC |
Group Replication Certification (GrCertification) — collected every 5 Min
Group Replication certification and consistency-wait activity for the connected member, as deltas over the collection interval — garbage collection runs and consistency-check timings — from the server’s Gr_* status counters.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
member_id (key) |
Member ID | NA | ||
certification_gc_runs |
Certification GC Runs | NA | ||
certification_gc_time_us |
Certification GC Time | MICROSEC | ||
consistency_before_begin_count |
Consistency Waits (Before Begin) | NA | ||
consistency_before_begin_time_us |
Consistency Wait Time (Before Begin) | MICROSEC | ||
consistency_after_sync_count |
Consistency Waits (After Sync) | NA | ||
consistency_after_sync_time_us |
Consistency Wait Time (After Sync) | MICROSEC | ||
consistency_after_termination_count |
Consistency Waits (After Termination) | NA | ||
consistency_after_termination_time_us |
Consistency Wait Time (After Termination) | MICROSEC |
Backup Source (BackupSource) — collected every 15 Min
Which cluster member the most recent successful backup was taken from, and whether that member is still online in the group. Reads MySQL Enterprise Backup’s mysql.backup_history joined against Group Replication membership; Percona XtraBackup backups are reported without member identity because PERCONA_SCHEMA.xtrabackup_history does not record it.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
source_uuid |
Source Member UUID | NA | ||
source_member |
Source Member | NA | ||
source_state |
Source Member State | NA | ||
source_offline |
Backup Source Offline | NA | > 0 | |
last_success_end_time |
Last Successful Backup End Time | NA | ||
tool |
Backup Tool | NA |
MySQL InnoDB ClusterSet (ip_mysql_clusterset_beta)
Response (Response) — collected every 1 Min
Availability. EM derives the target’s Up/Down state from the Status column; a Status below 1 raises the target-down event.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
Status |
Status (up/down) | NA | < 1 |
ClusterSet Health (ClusterSetHealth) — collected every 5 Min
Single-row alertable ClusterSet health composite. Runs mysqlsh AdminAPI (clusterSet.status) from the agent host; requires mysqlsh on the agent’s PATH. dr_promotion_ready is 1 when the ClusterSet can be failed over and 0 when it cannot; under a network partition the Shell reports HEALTHY with the replication channel CONNECTING, which this metric surfaces as not promotion-ready.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
health_source |
Health Source | NA | ||
fallback_reason |
Fallback Reason | NA | ||
primary_healthy |
Primary Healthy | NA | ||
replica_clusters_healthy |
Replica Clusters Healthy | NA | ||
replication_channel_ok |
Replication Channel OK | NA | ||
gtid_lag |
GTID Lag | NA | ||
errant_gtid_count |
Errant GTID Count | NA | ||
dr_promotion_ready |
DR Promotion Ready | NA | < 1 | |
replica_cluster_count |
Replica Cluster Count | NA | ||
domain_name |
Domain Name | NA | ||
primary_cluster |
Primary Cluster | NA | ||
global_primary_instance |
Global Primary Instance | NA | ||
status |
Status | NA | ||
status_text |
Status Text | NA |
ClusterSet Clusters (ClusterSetClusters) — collected every 5 Min
Per-cluster ClusterSet detail, keyed by cluster name — role, status, replication status, and GTID consistency versus the primary. Runs mysqlsh AdminAPI (clusterSet.status) from the agent host; requires mysqlsh on the agent’s PATH.
| Column | Label | Unit | Warning | Critical |
|---|---|---|---|---|
cluster_name (key) |
Cluster | NA | ||
cluster_role |
Role | NA | ||
global_status |
Global Status | NA | ||
cluster_set_replication_status |
ClusterSet Replication Status | NA | ||
transaction_set_consistency_status |
Transaction Set Consistency | NA | ||
missing_gtid_count |
Missing Transactions | NA | ||
errant_gtid_count |
Errant Transactions | NA | ||
primary_instance |
Primary Instance | NA | ||
missing_gtid_set |
Missing GTID Set | NA | ||
errant_gtid_set |
Errant GTID Set | NA |