Integration Plumbers // Docs

Documentation for Integration Plumbers products.

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 as metrics-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_running returns Yes or No, while replica_sql_running returns true or false. 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    

MySQL Plug-in documentation