Skip to content
MySQL plug-in

Metrics reference

View Markdown

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

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 122 metric groups: 110 on MySQL Database, 8 on MySQL InnoDB Cluster and 4 on MySQL InnoDB 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.

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:

ColumnWhat it tells you
ColumnThe 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.
LabelThe display name shown in the console. Where the value’s meaning is not obvious from the name, the label says it: what 1 means for a flag, which values a coded column takes, and the window a computed figure covers (6.3).
UnitThe unit Enterprise Manager labels the value with, for example MICROSEC, BYTE, SECOND, HOURS, DAYS or PERCENTAGE. Every column that has a real unit carries it. NA means the value has no unit: a plain count (a number of statements, rows or connections), a 0/1 flag, a coded setting, an identifier such as a port, a server ID or an error code, or a string. Enterprise Manager’s MCP server shows these as n/a; read what such a column counts from its label.
Warning / CriticalThe default threshold that ships for the column, with its operator. A blank cell means no default threshold, which is the normal case: 22 curated thresholds ship (7.1), and the reference also shows the three availability Status conditions, so 25 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.

Column names follow a few conventions consistently, so the name usually tells you what kind of number you are looking at.

Suffix or patternMeaning
_deltaThe 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.
_pctA percentage, on a 0–100 scale.
_rateA ratio expressed as a percentage (the buffer pool hit rates, for example), normalized to one decimal place. It is not a per-second figure.
_per_secA per-second rate.
_usMicroseconds. Statement and wait latencies are reported in microseconds throughout.
d_ prefixA per-interval delta on the wait and statement digest groups, the keyed equivalent of _delta.
*Live groupA 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.

How labels state what a value means. A label carries what its name cannot:

Label wordingMeaning
(0/1: 1 = ...)A flag. The label says what 1 means; 0 is the opposite.
-1 = unknown / -1 = not assessedThe collector could not measure the value, or no check ran. It is a value of its own and is never a 0: a 0 is always a real measurement (a check that ran, or a count of none). A -1 is never a failure by itself, and the shipped conditions, at their default settings, do not fire on it. dr_promotion_ready spells out 1, 0 and -1 in full in its label.
(ONLINE | RECOVERING | ...)A coded string column. The label lists the values it can take; a trailing ... means the list is abbreviated to fit the console’s 64-character label limit.
(current)A gauge: the value as it is at the moment of the collection.
(setting)A configured value (a server variable), not a measurement. It changes only when someone changes the configuration.
(cumulative since server start)On a group name: every counter in the group is the running total since the server started (or since FLUSH STATUS), so a single value means little; compare two collections, or use the _delta and _per_sec columns where they exist.
since prev. collection (~N min)A figure computed from the change since the previous collection, about N minutes earlier. After a missed cycle the window is longer than N minutes; it is never shorter.
avg since prev. engine-status read, ~5 minAn average per second (or per wait) taken from SHOW ENGINE INNODB STATUS, which the plug-in reads at most every 5 minutes and shares between groups.
cumulative since member joinedGroup Replication counters that restart when the member rejoins the group.

Note: Metric descriptions are console-only. The <Description> text the plug-in ships on a metric group appears in the Enterprise Manager console, but Enterprise Manager’s MCP server does not pass it to an AI agent: an agent asking about an incident, an event or a metric sees the label, the unit and the value, and none of the authored description text. This is why the label carries the meaning of a flag, a coded value or a window itself rather than leaving it to a description.

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.10.0.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.

Response (Response), collected every 1 Min

Section titled “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.

ColumnLabelUnitWarningCritical
StatusStatus (0/1: 1 = up, 0 = down)NA< 1

Instance Info (InstanceInfo), collected every 15 Min

Section titled “Instance Info (InstanceInfo), collected every 15 Min”

Server version and installation directories (version, base directory, data directory, temp directory), read from global system variables.

ColumnLabelUnitWarningCritical
versionVersionNA
basedirBase DirectoryNA
datadirData DirectoryNA
tmpdirTemp DirectoryNA

Replication Source Config (ReplicationSource), collected every 1 Hr

Section titled “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.

ColumnLabelUnitWarningCritical
auto_increment_incrementAuto-Increment StepNA
auto_increment_offsetAuto-Increment Start OffsetNA
enforce_gtid_consistencyEnforce GTID ConsistencyNA
gtid_executedGTID ExecutedNA
gtid_executed_compression_periodGTID Compression Period (transactions)NA
gtid_modeGTID ModeNA
gtid_nextGTID NextNA
gtid_ownedGTID OwnedNA
gtid_purgedGTID PurgedNA
server_uuidServer UUIDNA
rpl_semi_sync_source_enabledSemi-Sync Source EnabledNA
rpl_semi_sync_source_timeoutSemi-Sync Source Timeout (ms)MILLISECONDS
rpl_semi_sync_source_trace_levelSemi-Sync Source Trace Level (bit mask)NA
rpl_semi_sync_source_wait_no_replicaSemi-Sync Source Wait No ReplicaNA
server_idServer ID (this server)NA
source_verify_checksumSource Verify ChecksumNA

Replication Source Activity (ReplicationSourceActivity), collected every 5 Min

Section titled “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.

ColumnLabelUnitWarningCritical
binlog_cache_disk_useBinary Log Cache Disk UseNA
binlog_cache_useBinary Log Cache UseNA
rpl_semi_sync_source_clientsSemi-Sync Source ClientsNA
rpl_semi_sync_source_net_avg_wait_timeSemi-Sync Source Net Avg Wait TimeMICROSEC
rpl_semi_sync_source_net_waitsSemi-Sync Source Net WaitsNA
rpl_semi_sync_source_net_wait_timeSemi-Sync Source Net Wait Time (total)MICROSEC
rpl_semi_sync_source_no_timesSemi-Sync Source No TimesNA
rpl_semi_sync_source_no_txSemi-Sync Source No TransactionsNA
rpl_semi_sync_source_statusSemi-Sync Source Status (true | false)NA
rpl_semi_sync_source_timefunc_failuresSemi-Sync Source Timefunc FailuresNA
rpl_semi_sync_source_tx_avg_wait_timeSemi-Sync Source Tx Avg Wait TimeMICROSEC
rpl_semi_sync_source_tx_waitsSemi-Sync Source Tx WaitsNA
rpl_semi_sync_source_tx_wait_timeSemi-Sync Source Tx Wait Time (total)MICROSEC
rpl_semi_sync_source_wait_pos_backtraverseSemi-Sync Source Wait Pos BacktraverseNA
rpl_semi_sync_source_wait_sessionsSemi-Sync Source Wait SessionsNA
rpl_semi_sync_source_yes_txSemi-Sync Source Yes TransactionsNA
com_show_binary_log_statusSHOW BINARY LOG STATUS CountNA
com_show_replicasSHOW REPLICAS CountNA
fileBinary Log FileNA
positionBinary Log Position (byte offset)NA
executed_gtid_setExecuted GTID SetNA

Replication Replica Config (ReplicationReplica), collected every 1 Hr

Section titled “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.

ColumnLabelUnitWarningCritical
channel_name (key)Channel NameNA
auto_positionAuto PositionNA
connect_retryConnect Retry Interval (sec)SECOND
source_bindSource BindNA
source_hostSource HostNA
source_info_fileSource Info FileNA
source_portSource Port (TCP)NA
source_retry_countSource Retry Count (max attempts)NA
source_server_idSource Server ID (upstream server_id)NA
source_uuidSource UUIDNA
source_ssl_allowedSource SSL AllowedNA
source_ssl_ca_fileSource SSL CA FileNA
source_ssl_ca_pathSource SSL CA PathNA
source_ssl_certSource SSL CertNA
source_ssl_cipherSource SSL CipherNA
source_ssl_crlSource SSL CRLNA
source_ssl_crl_pathSource SSL CRL PathNA
source_ssl_keySource SSL KeyNA
source_ssl_verify_server_certSource SSL Verify Server CertNA
source_userSource UserNA
replicate_do_dbReplicate Do DBNA
replicate_do_tableReplicate Do TableNA
replicate_ignore_dbReplicate Ignore DBNA
replicate_ignore_server_idsReplicate Ignore Server IDsNA
replicate_ignore_tableReplicate Ignore TableNA
replicate_wild_do_tableReplicate Wild Do TableNA
replicate_wild_ignore_tableReplicate Wild Ignore TableNA
skip_counterSkip Counter (events to skip)NA
sql_delaySQL Delay (sec)SECOND
until_conditionUntil ConditionNA
until_log_fileUntil Log FileNA
until_log_posUntil Log Position (byte offset)NA
replicate_rewrite_dbReplicate Rewrite DBNA
replica_allow_batchingReplica Allow BatchingNA
replica_checkpoint_groupReplica Checkpoint Group (transactions)NA
replica_checkpoint_periodReplica Checkpoint Period (ms)MILLISECONDS
replica_exec_modeReplica Exec ModeNA
gtid_modeGTID ModeNA
init_replicaInit ReplicaNA
replica_load_tmpdirReplica Load TmpdirNA
log_replica_updatesLog Replica UpdatesNA
replica_max_allowed_packetReplica Max Allowed Packet (bytes)BYTE
max_relay_log_sizeMax Relay Log Size (bytes)BYTE
replica_net_timeoutReplica Net Timeout (sec)SECOND
replica_parallel_typeReplica Parallel Type (DATABASE | LOGICAL_CLOCK)NA
replica_parallel_workersReplica Parallel Workers (threads)NA
replica_pending_jobs_size_maxReplica Pending Jobs Max Size (bytes)BYTE
replica_preserve_commit_orderReplica Preserve Commit OrderNA
read_onlyRead OnlyNA
relay_logRelay LogNA
relay_log_basenameRelay Log BasenameNA
relay_log_indexRelay Log IndexNA
relay_log_info_fileRelay Log Info FileNA
relay_log_purgeRelay Log PurgeNA
relay_log_recoveryRelay Log RecoveryNA
relay_log_space_limitRelay Log Space Limit (bytes, 0 = no limit)BYTE
report_hostReport HostNA
report_portReport Port (TCP)NA
report_userReport UserNA
rpl_semi_sync_replica_enabledSemi-Sync Replica EnabledNA
rpl_semi_sync_replica_trace_levelSemi-Sync Replica Trace Level (bit mask)NA
server_idServer ID (this server)NA
replica_skip_errorsReplica Skip ErrorsNA
replica_sql_verify_checksumReplica SQL Verify ChecksumNA
sync_source_infoSync Source Info (events)NA
sync_relay_logSync Relay Log (events)NA
sync_relay_log_infoSync Relay Log Info (transactions)NA
replica_transaction_retriesReplica Transaction Retries (max)NA
replica_type_conversionsReplica Type ConversionsNA

Replication Replica Activity (ReplicationReplicaActivity), collected every 5 Min

Section titled “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. replica_io_running reports Yes/No while replica_sql_running reports true/false; write any custom rule against both columns accordingly.

ColumnLabelUnitWarningCritical
channel_name (key)Channel NameNA
replica_io_stateReplica IO StateNA
source_log_fileSource Log FileNA
read_source_log_posRead Source Log PositionNA
relay_log_fileRelay Log FileNA
relay_log_posRelay Log PositionNA
relay_source_log_fileRelay Source Log FileNA
replica_io_runningReplica IO Running (Yes | No | Connecting)NA= No
replica_sql_runningReplica SQL Running (true | false)NA= false
last_errnoLast Error Number (0 = no error)NA
last_errorLast ErrorNA
relay_log_spaceRelay Log Space (bytes)BYTE
last_io_errnoLast IO Error Number (0 = no error)NA
last_io_errorLast IO ErrorNA
last_sql_errnoLast SQL Error Number (0 = no error)NA
last_sql_errorLast SQL ErrorNA
skip_counterSkip Counter (events to skip)NA
exec_source_log_posExec Source Log PositionNA
seconds_behind_sourceSeconds Behind Source (valid if Lag Measured = 1)SECOND> 30> 300
sql_remaining_delaySQL Remaining Delay (sec)SECOND
replica_sql_running_stateReplica SQL Running StateNA
retrieved_gtid_setRetrieved GTID SetNA
executed_gtid_setExecuted GTID SetNA
source_hostSource HostNA
com_change_replication_sourceCHANGE REPLICATION SOURCE CountNA
com_replica_startSTART REPLICA CountNA
com_replica_stopSTOP REPLICA CountNA
com_show_replica_statusSHOW REPLICA STATUS CountNA
rpl_semi_sync_replica_statusSemi-Sync Replica Status (true | false)NA
replica_heartbeat_periodReplica Heartbeat Period (sec)SECOND
replica_open_temp_tablesOpen Temporary Tables (replica SQL thread)NA
replica_received_heartbeatsHeartbeats Received (cumulative)NA
replica_retried_transactionsTransactions Retried (cumulative)NA
replica_runningReplica Running (true | false)NA
relay_log_purgeRelay Log Purge (true | false)NA
lag_measuredLag Measured (0/1: 1 = Seconds Behind Source is real)NA

Log IO Latency (LogIOLatency), collected every 5 Min

Section titled “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.

ColumnLabelUnitWarningCritical
log_bytes_writtenLog Bytes Written (cumulative bytes)BYTE
file_io_latencyFile IO Latency (cumulative ms)MILLISECONDS

Replication Connection Status (ReplicationConnStatus), collected every 5 Min

Section titled “Replication Connection Status (ReplicationConnStatus), collected every 5 Min”

Per-channel replication connection heartbeat status, from performance_schema.replication_connection_status.

ColumnLabelUnitWarningCritical
channel_name (key)Channel NameNA
count_received_heartbeatsReceived Heartbeats (cumulative)NA
last_heartbeat_timestampLast Heartbeat TimestampNA

Replication Connection Config (ReplicationConnectionConfig), collected every 1 Hr

Section titled “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.

ColumnLabelUnitWarningCritical
channel_name (key)Channel NameNA
auto_positioning_enabledAuto Positioning EnabledNA
connection_retry_intervalConnection Retry Interval (sec)SECOND
connection_retry_countConnection Retry Count (max attempts)NA
heartbeat_intervalHeartbeat Interval (sec)SECOND
bound_network_interfaceBound Network InterfaceNA
source_info_storageSource Info StorageNA

Replication By Coordinator (ReplicationByCoordinator), collected every 5 Min

Section titled “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.

ColumnLabelUnitWarningCritical
channel_name (key)Channel NameNA
thread_idThread IDNA
service_stateService State (ON | OFF; OFF is normal on a GR SECONDARY)NA
last_error_numberLast Error Number (0 = no error)NA
last_error_timestampLast Error TimestampNA

Replication By Worker (ReplicationByWorker), collected every 5 Min

Section titled “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.

ColumnLabelUnitWarningCritical
channel_name (key)Channel NameNA
worker_id (key)Worker IDNA
thread_idThread IDNA
service_stateService State (ON | OFF; OFF is normal on a GR SECONDARY)NA
last_error_messageLast Error MessageNA
last_error_numberLast Error Number (0 = no error)NA
last_applied_transactionLast Applied TransactionNA

InnoDB Activity (cumulative since server start) (InnodbActivity), collected every 5 Min

Section titled “InnoDB Activity (cumulative since server start) (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.

ColumnLabelUnitWarningCritical
innodb_buffer_pool_bytes_dataBuffer Pool Bytes Data (current)BYTE
innodb_buffer_pool_bytes_dirtyBuffer Pool Bytes Dirty (current)BYTE
innodb_buffer_pool_dump_statusBuffer Pool Dump StatusNA
innodb_buffer_pool_load_statusBuffer Pool Load StatusNA
innodb_buffer_pool_pages_dataBuffer Pool Pages Data (current)NA
innodb_buffer_pool_pages_dirtyBuffer Pool Pages Dirty (current)NA
innodb_buffer_pool_pages_flushedBuffer Pool Pages FlushedNA
innodb_buffer_pool_pages_freeBuffer Pool Pages Free (current)NA
innodb_buffer_pool_pages_miscBuffer Pool Pages Misc (current)NA
innodb_buffer_pool_pages_totalBuffer Pool Pages Total (current)NA
innodb_buffer_pool_read_aheadBuffer Pool Read AheadNA
innodb_buffer_pool_read_ahead_evictedBuffer Pool Read Ahead EvictedNA
innodb_buffer_pool_read_requestsBuffer Pool Read RequestsNA
innodb_buffer_pool_readsBuffer Pool ReadsNA
innodb_buffer_pool_resize_statusBuffer Pool Resize StatusNA
innodb_buffer_pool_wait_freeBuffer Pool Wait FreeNA
innodb_buffer_pool_write_requestsBuffer Pool Write RequestsNA
innodb_data_fsyncsData FsyncsNA
innodb_data_pending_fsyncsData Pending Fsyncs (current)NA
innodb_data_pending_readsData Pending Reads (current)NA
innodb_data_pending_writesData Pending Writes (current)NA
innodb_data_readData ReadBYTE
innodb_data_readsData ReadsNA
innodb_data_writesData WritesNA
innodb_data_writtenData WrittenBYTE
innodb_dblwr_pages_writtenDblwr Pages WrittenNA
innodb_dblwr_writesDblwr WritesNA
innodb_log_waitsLog WaitsNA
innodb_log_write_requestsLog Write RequestsNA
innodb_log_writesLog WritesNA
innodb_os_log_fsyncsOS Log FsyncsNA
innodb_os_log_pending_fsyncsOS Log Pending Fsyncs (current)NA
innodb_os_log_pending_writesOS Log Pending Writes (current)NA
innodb_os_log_writtenOS Log WrittenBYTE
innodb_pages_createdPages CreatedNA
innodb_page_sizePage Size (setting)BYTE
innodb_pages_readPages ReadNA
innodb_pages_writtenPages WrittenNA
innodb_row_lock_current_waitsRow Lock Current Waits (current)NA
innodb_row_lock_timeRow Lock TimeMILLISECONDS
innodb_row_lock_time_avgRow Lock Time Avg (ms)MILLISECONDS
innodb_row_lock_time_maxRow Lock Time Max (ms, peak)MILLISECONDS
innodb_row_lock_waitsRow Lock WaitsNA
innodb_rows_deletedRows DeletedNA
innodb_rows_insertedRows InsertedNA
innodb_rows_readRows ReadNA
innodb_rows_updatedRows UpdatedNA
innodb_truncated_status_writesTruncated Status WritesNA
uptimeUptimeSECOND

InnoDB Buffer Pool (cumulative since server start) (InnodbBufferPool), collected every 5 Min

Section titled “InnoDB Buffer Pool (cumulative since server start) (InnodbBufferPool), collected every 5 Min”

InnoDB buffer pool sizing and effectiveness: hit rates and page allocation from INFORMATION_SCHEMA.INNODB_BUFFER_POOL_STATS.

ColumnLabelUnitWarningCritical
innodb_bp_total_allocBP Total Alloc (current)BYTE
innodb_bp_dictionary_allocBP Dictionary Alloc (current)BYTE
innodb_bp_sizeBP Size (pages, current)NA
innodb_bp_free_buffersBP Free Buffers (current)NA
innodb_bp_db_pagesBP Db Pages (current)NA
innodb_bp_old_db_pagesBP Old Db Pages (current)NA
innodb_bp_modified_pagesBP Modified Pages (current)NA
innodb_bp_pending_pagesBP Pending Pages (current)NA
innodb_bp_pending_writes_lruBP Pending Writes LRU (current)NA
innodb_bp_pending_writes_flush_listBP Pending Writes Flush List (current)NA
innodb_bp_pending_writes_single_pageBP Pending Writes Single Page (current)NA
innodb_bp_pages_youngBP Pages YoungNA
innodb_bp_pages_not_youngBP Pages Not YoungNA
innodb_bp_pages_young_per_secBP Pages Young/s (avg since prev. engine-status read, ~5 min)SECOND
innodb_bp_pages_not_young_per_secBP Not Young/s (avg since prev. engine-status read, ~5 min)SECOND
innodb_bp_pages_readBP Pages ReadNA
innodb_bp_pages_createdBP Pages CreatedNA
innodb_bp_pages_writtenBP Pages WrittenNA
innodb_bp_reads_per_secBP Reads/s (avg since prev. engine-status read, ~5 min)SECOND
innodb_bp_created_per_secBP Created/s (avg since prev. engine-status read, ~5 min)SECOND
innodb_bp_written_per_secBP Written/s (avg since prev. engine-status read, ~5 min)SECOND
innodb_bp_hit_rateBP Hit Rate (%, last ~5 min)PERCENTAGE< 95< 90
innodb_bp_young_hit_rateBP Young Hit Rate (%, last ~5 min)PERCENTAGE
innodb_bp_not_young_hit_rateBP Not Young Hit Rate (%, last ~5 min)PERCENTAGE
innodb_bp_pages_read_ahead_per_secBP Read Ahead/s (avg since prev. engine-status read, ~5 min)SECOND
innodb_bp_pages_evicted_no_access_per_secBP Evicted Unused/s (avg since prev. engine-status read, ~5 min)SECOND
innodb_bp_pages_random_read_ahead_per_secBP Random R-Ahead/s (avg since prev. engine-status read, ~5 min)SECOND
innodb_bp_lru_lenBP LRU Len (current)NA
innodb_bp_unzip_lru_lenBP Unzip LRU Len (current)NA
innodb_bp_io_sum_pagesBP IO Sum Pages (last ~50 s)NA
innodb_bp_io_cur_pagesBP IO Cur Pages (current)NA
innodb_bp_io_unzip_sum_pagesBP IO Unzip Sum Pages (last ~50 s)NA
innodb_bp_io_unzip_cur_pagesBP IO Unzip Cur Pages (current)NA
compress_secondsCompress SecondsSECOND
uncompress_secondsUncompress SecondsSECOND

InnoDB Log (cumulative since server start) (InnodbLog), collected every 5 Min

Section titled “InnoDB Log (cumulative since server start) (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.

ColumnLabelUnitWarningCritical
innodb_log_sequence_lsnLog Sequence LSNNA
innodb_log_flushed_lsnLog Flushed LSNNA
innodb_log_pages_flushed_lsnLog Pages Flushed LSNNA
innodb_log_checkpoint_lsnLog Checkpoint LSNNA
innodb_log_capacityLog Capacity (current)BYTE
innodb_log_capacity_usedLog Capacity Used (checkpoint age, current)BYTE
innodb_log_io_totalLog IO TotalNA
innodb_log_io_per_secLog Io/s (avg since prev. engine-status read, ~5 min)SECOND

InnoDB Transactions (InnodbTransaction), collected every 5 Min

Section titled “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.

ColumnLabelUnitWarningCritical
innodb_trx_id_counter_strTrx Id Counter StrNA
innodb_trx_purge_doneTrx Purge DoneNA
innodb_trx_history_list_lengthTrx History List Length (current)NA> 100000> 1000000
running_countRunning Count (current)NA
lock_wait_countLock Wait Count (current)NA
committing_countCommitting Count (current)NA
rolling_back_countRolling Back Count (current)NA
lock_memory_bytes_totalLock Memory Bytes Total (current)BYTE
rows_locked_totalRows Locked Total (current)NA
rows_modified_totalRows Modified Total (current)NA
row_locks_current_waitsRow Locks Current Waits (current)NA

InnoDB I/O (cumulative since server start) (InnodbIO), collected every 5 Min

Section titled “InnoDB I/O (cumulative since server start) (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.

ColumnLabelUnitWarningCritical
innodb_io_os_file_readsIO OS File ReadsNA
innodb_io_os_file_writesIO OS File WritesNA
innodb_io_os_file_fsyncsIO OS File FsyncsNA
innodb_io_pending_readsIO Pending Reads (current)NA
innodb_io_pending_writesIO Pending Writes (current)NA
innodb_io_pending_flush_logIO Pending Flush Log (current)NA
innodb_io_pending_flush_bpIO Pending Flush BP (current)NA
innodb_bytes_per_readBytes Per Read (avg since prev. engine-status read, ~5 min)BYTE
innodb_reads_per_secReads/s (avg since prev. engine-status read, ~5 min)SECOND
innodb_writes_per_secWrites/s (avg since prev. engine-status read, ~5 min)SECOND
innodb_io_syncs_per_secIO Syncs/s (avg since prev. engine-status read, ~5 min)SECOND
innodb_num_open_filesNum Open Files (current)NA

InnoDB Row Operations (cumulative since server start) (InnodbRow), collected every 5 Min

Section titled “InnoDB Row Operations (cumulative since server start) (InnodbRow), collected every 5 Min”

InnoDB row operation counts and rates (inserts, updates, deletes, and reads) parsed from the InnoDB engine status output.

ColumnLabelUnitWarningCritical
innodb_row_queries_insideRow Queries Inside (current)NA
innodb_row_queries_queueRow Queries Queue (current)NA
innodb_rows_insertedRows InsertedNA
innodb_rows_updatedRows UpdatedNA
innodb_rows_deletedRows DeletedNA
innodb_rows_readRows ReadNA
innodb_rows_inserted_per_secRows Inserted/s (avg since prev. engine-status read, ~5 min)SECOND
innodb_rows_updated_per_secRows Updated/s (avg since prev. engine-status read, ~5 min)SECOND
innodb_rows_deleted_per_secRows Deleted/s (avg since prev. engine-status read, ~5 min)SECOND
innodb_rows_read_per_secRows Read/s (avg since prev. engine-status read, ~5 min)SECOND

InnoDB Insert Buffer (cumulative since server start) (InnodbInsertBuffer), collected every 5 Min

Section titled “InnoDB Insert Buffer (cumulative since server start) (InnodbInsertBuffer), collected every 5 Min”

InnoDB change buffer (insert buffer) size and merge/discard activity, parsed from the InnoDB engine status output.

ColumnLabelUnitWarningCritical
innodb_ibuf_sizeIbuf Size (pages, current)NA
innodb_ibuf_free_list_lenIbuf Free List Len (pages, current)NA
innodb_ibuf_seg_sizeIbuf Seg Size (pages, current)NA
innodb_cbuf_insert_mergesCbuf Insert MergesNA
innodb_cbuf_delete_mark_mergesCbuf Delete Mark MergesNA
innodb_cbuf_delete_mergesCbuf Delete MergesNA
innodb_cbuf_insert_discardedCbuf Insert DiscardedNA
innodb_cbuf_delete_mark_discardedCbuf Delete Mark DiscardedNA
innodb_cbuf_delete_discardedCbuf Delete DiscardedNA

InnoDB Adaptive Hash (InnodbAdaptiveHash), collected every 5 Min

Section titled “InnoDB Adaptive Hash (InnodbAdaptiveHash), collected every 5 Min”

InnoDB adaptive hash index size and search rates, parsed from the InnoDB engine status output.

ColumnLabelUnitWarningCritical
innodb_hash_table_sizeHash Table Size (cells, current)NA
innodb_hash_node_heapHash Node Heap (buffers, current)NA
innodb_hash_searches_per_secHash Searches/s (avg since prev. engine-status read, ~5 min)SECOND
innodb_non_hash_searches_per_secNon Hash Searches/s (avg since prev. engine-status read, ~5 min)SECOND

InnoDB Threads (cumulative since server start) (InnodbThread), collected every 5 Min

Section titled “InnoDB Threads (cumulative since server start) (InnodbThread), collected every 5 Min”

InnoDB background (main) thread loop counters and current state, parsed from the InnoDB engine status output.

ColumnLabelUnitWarningCritical
innodb_main_thd_loops_srv_activeMain Thd Loops Srv ActiveNA
innodb_main_thd_loops_srv_shutdownMain Thd Loops Srv ShutdownNA
innodb_main_thd_loops_srv_idleMain Thd Loops Srv IdleNA
innodb_main_thd_log_flush_writesMain Thd Log Flush WritesNA
innodb_row_stateRow StateNA

InnoDB Semaphores (cumulative since server start) (InnodbSemaphore), collected every 5 Min

Section titled “InnoDB Semaphores (cumulative since server start) (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.

ColumnLabelUnitWarningCritical
innodb_sem_os_reservation_countSem OS Reservation CountNA
innodb_sem_os_signal_countSem OS Signal CountNA
innodb_sem_shared_spinsSem Shared SpinsNA
innodb_sem_shared_roundsSem Shared RoundsNA
innodb_sem_shared_os_waitsSem Shared OS WaitsNA
innodb_sem_rw_excl_spinsSem RW Excl SpinsNA
innodb_sem_rw_excl_roundsSem RW Excl RoundsNA
innodb_sem_rw_excl_os_waitsSem RW Excl OS WaitsNA
innodb_sem_rw_sx_spinsSem RW SX SpinsNA
innodb_sem_rw_sx_roundsSem RW SX RoundsNA
innodb_sem_rw_sx_os_waitsSem RW SX OS WaitsNA
innodb_sem_spins_per_wait_rw_sharedSpins Per Wait RW Shared (avg since prev. engine-status read)NA
innodb_sem_spins_per_wait_rw_exclSpins Per Wait RW Excl (avg since prev. engine-status read)NA
innodb_sem_spins_per_wait_rw_sxSpins Per Wait RW SX (avg since prev. engine-status read)NA

Admin Statement Activity (cumulative since server start) (AdminStatementActivity), collected every 5 Min

Section titled “Admin Statement Activity (cumulative since server start) (AdminStatementActivity), collected every 5 Min”

Counts of the server’s AdminStatementActivity statements, read as raw SHOW GLOBAL STATUS counters (cumulative since server start; a restart or FLUSH STATUS resets them), so chart a rate or a difference between readings to see activity in an interval.

ColumnLabelUnitWarningCritical
com_admin_commandsCom Admin CommandsNA
com_analyzeCom AnalyzeNA
com_assign_to_keycacheCom Assign To KeycacheNA
com_binlogCom BinlogNA
com_change_replication_sourceCom Change Replication SourceNA
com_checkCom CheckNA
com_checksumCom ChecksumNA
com_flushCom FlushNA
com_install_pluginCom Install PluginNA
com_killCom KillNA
com_optimizeCom OptimizeNA
com_preload_keysCom Preload KeysNA
com_purgeCom PurgeNA
com_purge_before_dateCom Purge Before DateNA
com_repairCom RepairNA
com_replica_startCom Replica StartNA
com_replica_stopCom Replica StopNA
com_uninstall_pluginCom Uninstall PluginNA

DDL Statement Activity (cumulative since server start) (DdlStatementActivity), collected every 5 Min

Section titled “DDL Statement Activity (cumulative since server start) (DdlStatementActivity), collected every 5 Min”

Counts of the server’s DdlStatementActivity statements, read as raw SHOW GLOBAL STATUS counters (cumulative since server start; a restart or FLUSH STATUS resets them), so chart a rate or a difference between readings to see activity in an interval.

ColumnLabelUnitWarningCritical
com_alter_dbCom Alter DbNA
com_alter_eventCom Alter EventNA
com_alter_functionCom Alter FunctionNA
com_alter_procedureCom Alter ProcedureNA
com_alter_serverCom Alter ServerNA
com_alter_tableCom Alter TableNA
com_alter_tablespaceCom Alter TablespaceNA
com_create_dbCom Create DbNA
com_create_eventCom Create EventNA
com_create_functionCom Create FunctionNA
com_create_indexCom Create IndexNA
com_create_procedureCom Create ProcedureNA
com_create_serverCom Create ServerNA
com_create_tableCom Create TableNA
com_create_triggerCom Create TriggerNA
com_create_udfCom Create UdfNA
com_create_userCom Create UserNA
com_create_viewCom Create ViewNA
com_drop_dbCom Drop DbNA
com_drop_eventCom Drop EventNA
com_drop_functionCom Drop FunctionNA
com_drop_indexCom Drop IndexNA
com_drop_procedureCom Drop ProcedureNA
com_drop_serverCom Drop ServerNA
com_drop_tableCom Drop TableNA
com_drop_triggerCom Drop TriggerNA
com_drop_userCom Drop UserNA
com_drop_viewCom Drop ViewNA
com_grantCom GrantNA
com_rename_tableCom Rename TableNA
com_rename_userCom Rename UserNA
com_truncateCom TruncateNA

DML Statement Activity (cumulative since server start) (DmlStatementActivity), collected every 5 Min

Section titled “DML Statement Activity (cumulative since server start) (DmlStatementActivity), collected every 5 Min”

Counts of the server’s DmlStatementActivity statements, read as raw SHOW GLOBAL STATUS counters (cumulative since server start; a restart or FLUSH STATUS resets them), so chart a rate or a difference between readings to see activity in an interval.

ColumnLabelUnitWarningCritical
com_call_procedureCom Call ProcedureNA
com_change_dbCom Change DbNA
com_dealloc_sqlCom Dealloc SqlNA
com_deleteCom DeleteNA
com_delete_multiCom Delete MultiNA
com_doCom DoNA
com_empty_queryCom Empty QueryNA
com_execute_sqlCom Execute SqlNA
com_ha_closeCom HA CloseNA
com_ha_openCom HA OpenNA
com_ha_readCom HA ReadNA
com_helpCom HelpNA
com_insertCom InsertNA
com_insert_selectCom Insert SelectNA
com_loadCom LoadNA
com_lock_tablesCom Lock TablesNA
com_prepare_sqlCom Prepare SqlNA
com_replaceCom ReplaceNA
com_replace_selectCom Replace SelectNA
com_resetCom ResetNA
com_resignalCom ResignalNA
com_selectCom SelectNA
com_set_optionCom Set OptionNA
com_signalCom SignalNA
com_stmt_closeCom Stmt CloseNA
com_stmt_executeCom Stmt ExecuteNA
com_stmt_fetchCom Stmt FetchNA
com_stmt_prepareCom Stmt PrepareNA
com_stmt_reprepareCom Stmt ReprepareNA
com_stmt_resetCom Stmt ResetNA
com_stmt_send_long_dataCom Stmt Send Long DataNA
com_unlock_tablesCom Unlock TablesNA
com_updateCom UpdateNA
com_update_multiCom Update MultiNA

Show Statement Activity (cumulative since server start) (ShowStatementActivity), collected every 5 Min

Section titled “Show Statement Activity (cumulative since server start) (ShowStatementActivity), collected every 5 Min”

Counts of the server’s ShowStatementActivity statements, read as raw SHOW GLOBAL STATUS counters (cumulative since server start; a restart or FLUSH STATUS resets them), so chart a rate or a difference between readings to see activity in an interval.

ColumnLabelUnitWarningCritical
com_show_binlog_eventsCom Show Binlog EventsNA
com_show_binlogsCom Show BinlogsNA
com_show_charsetsCom Show CharsetsNA
com_show_collationsCom Show CollationsNA
com_show_create_dbCom Show Create DbNA
com_show_create_eventCom Show Create EventNA
com_show_create_funcCom Show Create FuncNA
com_show_create_procCom Show Create ProcNA
com_show_create_tableCom Show Create TableNA
com_show_create_triggerCom Show Create TriggerNA
com_show_databasesCom Show DatabasesNA
com_show_engine_logsCom Show Engine LogsNA
com_show_engine_mutexCom Show Engine MutexNA
com_show_engine_statusCom Show Engine StatusNA
com_show_errorsCom Show ErrorsNA
com_show_eventsCom Show EventsNA
com_show_fieldsCom Show FieldsNA
com_show_function_codeCom Show Function CodeNA
com_show_function_statusCom Show Function StatusNA
com_show_grantsCom Show GrantsNA
com_show_keysCom Show KeysNA
com_show_binary_log_statusCom Show Binary Log StatusNA
com_show_open_tablesCom Show Open TablesNA
com_show_pluginsCom Show PluginsNA
com_show_privilegesCom Show PrivilegesNA
com_show_procedure_codeCom Show Procedure CodeNA
com_show_procedure_statusCom Show Procedure StatusNA
com_show_processlistCom Show ProcesslistNA
com_show_profileCom Show ProfileNA
com_show_profilesCom Show ProfilesNA
com_show_relaylog_eventsCom Show Relaylog EventsNA
com_show_replicasCom Show ReplicasNA
com_show_replica_statusCom Show Replica StatusNA
com_show_statusCom Show StatusNA
com_show_storage_enginesCom Show Storage EnginesNA
com_show_tablesCom Show TablesNA
com_show_table_statusCom Show Table StatusNA
com_show_triggersCom Show TriggersNA
com_show_variablesCom Show VariablesNA
com_show_warningsCom Show WarningsNA

Transaction Statement Activity (cumulative since server start) (TransactionStatementActivity), collected every 5 Min

Section titled “Transaction Statement Activity (cumulative since server start) (TransactionStatementActivity), collected every 5 Min”

Counts of the server’s TransactionStatementActivity statements, read as raw SHOW GLOBAL STATUS counters (cumulative since server start; a restart or FLUSH STATUS resets them), so chart a rate or a difference between readings to see activity in an interval.

ColumnLabelUnitWarningCritical
com_beginCom BeginNA
com_commitCom CommitNA
com_release_savepointCom Release SavepointNA
com_rollbackCom RollbackNA
com_rollback_to_savepointCom Rollback To SavepointNA
com_savepointCom SavepointNA
com_xa_commitCom XA CommitNA
com_xa_endCom XA EndNA
com_xa_prepareCom XA PrepareNA
com_xa_recoverCom XA RecoverNA
com_xa_rollbackCom XA RollbackNA
com_xa_startCom XA StartNA

Handler Activity (cumulative since server start) (HandlerActivity), collected every 5 Min

Section titled “Handler Activity (cumulative since server start) (HandlerActivity), collected every 5 Min”

Storage engine handler call counts (reads, writes, commits, and rollbacks) from the server’s Handler_* status counters.

ColumnLabelUnitWarningCritical
handler_commitHandler CommitNA
handler_deleteHandler DeleteNA
handler_discoverHandler DiscoverNA
handler_external_lockHandler External LockNA
handler_mrr_initHandler Mrr InitNA
handler_prepareHandler PrepareNA
handler_read_firstHandler Read FirstNA
handler_read_keyHandler Read KeyNA
handler_read_lastHandler Read LastNA
handler_read_nextHandler Read NextNA
handler_read_prevHandler Read PrevNA
handler_read_rndHandler Read RndNA
handler_read_rnd_nextHandler Read Rnd NextNA
handler_rollbackHandler RollbackNA
handler_savepointHandler SavepointNA
handler_savepoint_rollbackHandler Savepoint RollbackNA
handler_updateHandler UpdateNA
handler_writeHandler WriteNA
uptimeUptimeSECOND

Instance Activity (cumulative since server start) (InstanceActivity), collected every 5 Min

Section titled “Instance Activity (cumulative since server start) (InstanceActivity), collected every 5 Min”

General server activity counters (queries served, open files, prepared statements, and uptime) from the server’s status counters.

ColumnLabelUnitWarningCritical
acl_cache_items_countAcl Cache Items Count (current)NA
flush_commandsFlush CommandsNA
opened_filesOpened FilesNA
open_filesOpen Files (current)NA
open_streamsOpen Streams (current)NA
prepared_stmt_countPrepared Stmt Count (current)NA
queriesQueriesNA
questionsQuestionsNA
uptimeUptimeSECOND
uptime_since_flush_statusUptime Since Flush Status (seconds)SECOND

XA Activity (cumulative since server start) (XaActivity), collected every 5 Min

Section titled “XA Activity (cumulative since server start) (XaActivity), collected every 5 Min”

XA / two-phase-commit transaction coordinator log counters: page size, pages used, and page waits.

ColumnLabelUnitWarningCritical
tc_log_max_pages_usedTc Log Max Pages Used (peak)NA
tc_log_page_sizeTc Log Page Size (setting)BYTE
tc_log_page_waitsTc Log Page WaitsNA

Connection Activity (cumulative since server start) (ConnectionActivity), collected every 5 Min

Section titled “Connection Activity (cumulative since server start) (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.

ColumnLabelUnitWarningCritical
aborted_clientsAborted ClientsNA
aborted_connectsAborted ConnectsNA
bytes_receivedBytes ReceivedBYTE
bytes_sentBytes SentBYTE
connectionsConnectionsNA
locked_connectsLocked ConnectsNA
max_execution_time_exceededMax Execution Time ExceededNA
max_execution_time_setMax Execution Time SetNA
max_execution_time_set_failedMax Execution Time Set FailedNA
max_used_connectionsMax Used Connections (peak)NA
ongoing_anonymous_transaction_countOngoing Anonymous Transaction Count (current)NA
threads_cachedThreads Cached (current)NA
threads_connectedThreads Connected (current)NA
aborted_connects_deltaAborted Connects (per 5-min interval)NA> 10> 50

Threads Activity (cumulative since server start) (ThreadsActivity), collected every 5 Min

Section titled “Threads Activity (cumulative since server start) (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.

ColumnLabelUnitWarningCritical
threads_cachedThreads Cached (current)NA
threads_connectedThreads Connected (current)NA
threads_createdThreads CreatedNA
threads_runningThreads Running (current)NA
slow_launch_threadsSlow Launch ThreadsNA
uptimeUptimeSECOND
max_connectionsMax Connections (setting)NA
thread_handlingThread HandlingNA
connection_saturation_pctConnection Saturation (%, current)PERCENTAGE> 80> 95

Insert Delayed Activity (cumulative since server start) (InsertDelayedActivity), collected every 5 Min

Section titled “Insert Delayed Activity (cumulative since server start) (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.

ColumnLabelUnitWarningCritical
delayed_errorsDelayed ErrorsNA
delayed_insert_threadsDelayed Insert Threads (current)NA
not_flushed_delayed_rowsNot Flushed Delayed Rows (current)NA
delayed_writesDelayed WritesNA

NDB Activity (cumulative since server start) (NdbActivity), collected every 5 Min

Section titled “NDB Activity (cumulative since server start) (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.

ColumnLabelUnitWarningCritical
ndb_conflict_fn_maxNdb Conflict Fn MaxNA
ndb_conflict_fn_oldNdb Conflict Fn OldNA
ndb_number_of_data_nodesNdb Number Of Data Nodes (current)NA
ndb_number_of_ready_data_nodesNdb Number Of Ready Data Nodes (current)NA

Performance Schema Activity (cumulative since server start) (PerformanceSchemaActivity), collected every 5 Min

Section titled “Performance Schema Activity (cumulative since server start) (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.

ColumnLabelUnitWarningCritical
performance_schema_cond_classes_lostPerformance Schema Cond Classes LostNA
performance_schema_cond_instances_lostPerformance Schema Cond Instances LostNA
performance_schema_file_classes_lostPerformance Schema File Classes LostNA
performance_schema_file_handles_lostPerformance Schema File Handles LostNA
performance_schema_file_instances_lostPerformance Schema File Instances LostNA
performance_schema_hosts_lostPerformance Schema Hosts LostNA
performance_schema_index_stat_lostPerformance Schema Index Stat LostNA
performance_schema_locker_lostPerformance Schema Locker LostNA
performance_schema_memory_classes_lostPerformance Schema Memory Classes LostNA
performance_schema_metadata_lock_lostPerformance Schema Metadata Lock LostNA
performance_schema_mutex_classes_lostPerformance Schema Mutex Classes LostNA
performance_schema_mutex_instances_lostPerformance Schema Mutex Instances LostNA
performance_schema_nested_statement_lostPerformance Schema Nested Statement LostNA
performance_schema_prepared_statements_lostPerformance Schema Prepared Statements LostNA
performance_schema_program_lostPerformance Schema Program LostNA
performance_schema_rwlock_classes_lostPerformance Schema Rwlock Classes LostNA
performance_schema_rwlock_instances_lostPerformance Schema Rwlock Instances LostNA
performance_schema_session_connect_attrs_longest_seenPerformance Schema Session Connect Attrs Longest Seen (peak)BYTE
performance_schema_table_handles_lostPerformance Schema Table Handles LostNA
performance_schema_table_instances_lostPerformance Schema Table Instances LostNA
performance_schema_table_lock_stat_lostPerformance Schema Table Lock Stat LostNA
performance_schema_thread_classes_lostPerformance Schema Thread Classes LostNA
performance_schema_thread_instances_lostPerformance Schema Thread Instances LostNA

Table Activity (cumulative since server start) (TableActivity), collected every 5 Min

Section titled “Table Activity (cumulative since server start) (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.

ColumnLabelUnitWarningCritical
created_tmp_disk_tablesCreated Tmp Disk TablesNA
created_tmp_filesCreated Tmp FilesNA
created_tmp_tablesCreated Tmp TablesNA
opened_table_definitionsOpened Table DefinitionsNA
opened_tablesOpened TablesNA
open_table_definitionsOpen Table Definitions (current)NA
open_tablesOpen Tables (current)NA
sort_merge_passesSort Merge PassesNA
sort_rangeSort RangeNA
sort_rowsSort RowsNA
sort_scanSort ScanNA
table_locks_immediateTable Locks ImmediateNA
table_locks_waitedTable Locks WaitedNA
uptimeUptimeSECOND
open_files_limitOpen Files Limit (setting)NA
table_open_cacheTable Open Cache (setting)NA
created_tmp_tables_deltaCreated Tmp Tables (per 5-min interval)NA
created_tmp_disk_tables_deltaCreated Tmp Disk Tables (per 5-min interval)NA
disk_tmp_table_pctDisk Tmp Table Ratio (%, per 5-min interval)PERCENTAGE> 25> 50

Secure Connections Activity (cumulative since server start) (SecureConnectionsActivity), collected every 5 Min

Section titled “Secure Connections Activity (cumulative since server start) (SecureConnectionsActivity), collected every 5 Min”

TLS/SSL connection counters and negotiated settings: accepts, renegotiations, session cache activity, cipher, and protocol version.

ColumnLabelUnitWarningCritical
ssl_accept_renegotiatesSsl Accept RenegotiatesNA
ssl_acceptsSsl AcceptsNA
ssl_callback_cache_hitsSsl Callback Cache HitsNA
ssl_cipherSsl Cipher (current)NA
ssl_cipher_listSsl Cipher List (setting)NA
ssl_client_connectsSsl Client ConnectsNA
ssl_connect_renegotiatesSsl Connect RenegotiatesNA
ssl_ctx_verify_depthSsl Ctx Verify Depth (setting)NA
ssl_ctx_verify_modeSsl Ctx Verify ModeNA
ssl_default_timeoutSsl Default Timeout (setting)SECOND
ssl_finished_acceptsSsl Finished AcceptsNA
ssl_finished_connectsSsl Finished ConnectsNA
ssl_server_not_afterSsl Server Not After (current)NA
ssl_server_not_beforeSsl Server Not Before (current)NA
ssl_session_cache_hitsSsl Session Cache HitsNA
ssl_session_cache_missesSsl Session Cache MissesNA
ssl_session_cache_modeSsl Session Cache Mode (setting)NA
ssl_session_cache_overflowsSsl Session Cache OverflowsNA
ssl_session_cache_sizeSsl Session Cache Size (setting)NA
ssl_session_cache_timeoutSsl Session Cache Timeout (setting)SECOND
ssl_session_cache_timeoutsSsl Session Cache TimeoutsNA
ssl_sessions_reusedSsl Sessions ReusedNA
ssl_used_session_cache_entriesSsl Used Session Cache Entries (current)NA
ssl_verify_depthSsl Verify Depth (setting)NA
ssl_verify_modeSsl Verify ModeNA
ssl_versionSsl Version (current)NA

Audit Log Activity (cumulative since server start) (AuditLogActivity), collected every 5 Min

Section titled “Audit Log Activity (cumulative since server start) (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.

ColumnLabelUnitWarningCritical
audit_log_current_sizeAudit Log Current Size (current)BYTE
audit_log_direct_writesAudit Log Direct WritesNA
audit_log_event_max_drop_sizeAudit Log Event Max Drop Size (peak)BYTE
audit_log_eventsAudit Log EventsNA
audit_log_events_filteredAudit Log Events FilteredNA
audit_log_events_lostAudit Log Events LostNA
audit_log_events_writtenAudit Log Events WrittenNA
audit_log_total_sizeAudit Log Total Size (current)BYTE
audit_log_write_waitsAudit Log Write WaitsNA

Firewall Activity (cumulative since server start) (FirewallActivity), collected every 5 Min

Section titled “Firewall Activity (cumulative since server start) (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.

ColumnLabelUnitWarningCritical
firewall_access_deniedFirewall Access DeniedNA
firewall_access_grantedFirewall Access GrantedNA
firewall_access_suspiciousFirewall Access SuspiciousNA
firewall_cached_entriesFirewall Cached Entries (current)NA

Sys Schema Status (SysSchemaStatus), collected every 5 Min

Section titled “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.

ColumnLabelUnitWarningCritical
sys_versionSys VersionNA
sys_supportedSys Schema Usable (0/1, 1 = supported)NA< 1
status_messageSys Status MessageNA

Sys Memory By Event (SysMemoryByEvent), collected every 5 Min

Section titled “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.

ColumnLabelUnitWarningCritical
event_name (key)Event NameNA
current_countCurrent AllocationsNA
current_allocCurrent Bytes AllocatedBYTE
current_avg_allocCurrent Avg Bytes per AllocationBYTE
high_countPeak AllocationsNA
high_allocPeak Bytes AllocatedBYTE
high_avg_allocPeak Avg Bytes per AllocationBYTE

Sys IO By Host (SysIoByHost), collected every 5 Min

Section titled “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.

ColumnLabelUnitWarningCritical
host (key)HostNA
iosIOsNA
io_latencyIO LatencyMICROSEC

Sys IO By Thread (SysIoByThread), collected every 5 Min

Section titled “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.

ColumnLabelUnitWarningCritical
thread_id (key)Thread IdNA
userUserNA
totalTotalNA
total_latencyTotal LatencyMICROSEC
min_latencyMin LatencyMICROSEC
avg_latencyAvg LatencyMICROSEC
max_latencyMax LatencyMICROSEC
processlist_idProcesslist IdNA

Sys IO By File (SysIoByFile), collected every 5 Min

Section titled “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.

ColumnLabelUnitWarningCritical
file (key)FileNA
totalTotalNA
total_latencyTotal LatencyMICROSEC
count_readCount ReadNA
read_latencyRead LatencyMICROSEC
count_writeCount WriteNA
write_latencyWrite LatencyMICROSEC
count_miscCount MiscNA
misc_latencyMisc LatencyMICROSEC

Sys IO By Wait (SysIoByWait), collected every 5 Min

Section titled “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.

ColumnLabelUnitWarningCritical
event_name (key)Event NameNA
totalTotalNA
total_latencyTotal LatencyMICROSEC
avg_latencyAvg LatencyMICROSEC
max_latencyMax LatencyMICROSEC
read_latencyRead LatencyMICROSEC
write_latencyWrite LatencyMICROSEC
misc_latencyMisc LatencyMICROSEC
count_readCount ReadNA
total_readTotal ReadBYTE
avg_readAvg Bytes per ReadBYTE
count_writeCount WriteNA
total_writtenTotal WrittenBYTE
avg_writtenAvg Bytes per WriteBYTE

Sys Table Statistics (SysTableStatistics), collected every 5 Min

Section titled “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.

ColumnLabelUnitWarningCritical
table_schema (key)Table SchemaNA
table_name (key)Table NameNA
totalTotalNA
total_latencyTotal LatencyMICROSEC
rows_fetchedRows FetchedNA
fetch_latencyFetch LatencyMICROSEC
rows_insertedRows InsertedNA
insert_latencyInsert LatencyMICROSEC
rows_updatedRows UpdatedNA
update_latencyUpdate LatencyMICROSEC
rows_deletedRows DeletedNA
delete_latencyDelete LatencyMICROSEC
io_read_requestsIO Read RequestsNA
io_readIO ReadBYTE
io_read_latencyIO Read LatencyMICROSEC
io_write_requestsIO Write RequestsNA
io_writeIO WriteBYTE
io_write_latencyIO Write LatencyMICROSEC
io_misc_requestsIO Misc RequestsNA
io_misc_latencyIO Misc LatencyMICROSEC

Sys User Summary (SysUserSummary), collected every 5 Min

Section titled “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.

ColumnLabelUnitWarningCritical
user (key)UserNA
statementsStatementsNA
statement_latencyStatement LatencyMICROSEC
statement_avg_latencyStatement Avg LatencyMICROSEC
table_scansFull Table ScansNA
file_iosFile IOsNA
file_io_latencyFile IO LatencyMICROSEC
current_connectionsCurrent ConnectionsNA
total_connectionsTotal ConnectionsNA
unique_hostsUnique HostsNA
current_memoryCurrent MemoryBYTE
total_memory_allocatedTotal Memory AllocatedBYTE

Sys Host Summary (SysHostSummary), collected every 5 Min

Section titled “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.

ColumnLabelUnitWarningCritical
host (key)HostNA
statementsStatementsNA
statement_latencyStatement LatencyMICROSEC
statement_avg_latencyStatement Avg LatencyMICROSEC
table_scansFull Table ScansNA
file_iosFile IOsNA
file_io_latencyFile IO LatencyMICROSEC
current_connectionsCurrent ConnectionsNA
total_connectionsTotal ConnectionsNA
unique_usersUnique UsersNA
current_memoryCurrent MemoryBYTE
total_memory_allocatedTotal Memory AllocatedBYTE

Sys Statement By Latency (SysStatementByLatency), collected every 5 Min

Section titled “Sys Statement By Latency (SysStatementByLatency), collected every 5 Min”

Top 25 statement digests by total execution latency, from sys.x$statement_analysis.

ColumnLabelUnitWarningCritical
digest (key)DigestNA
queryQueryNA
db (key)DbNA
full_scanFull Scan (”*” = full scan)NA
exec_countExecutions (cumulative)NA
err_countErrors (cumulative)NA
warn_countWarnings (cumulative)NA
total_latencyTotal Latency (us, cumulative)MICROSEC
max_latencyMax Latency (us, slowest execution)MICROSEC
avg_latencyAvg Latency (us per execution)MICROSEC
lock_latencyLock Wait Time (us, cumulative)MICROSEC
rows_sentRows Sent to Client (cumulative)NA
rows_examinedRows Examined (cumulative)NA
rows_affectedRows Affected (cumulative)NA
tmp_tablesTemp Tables Created (cumulative)NA
tmp_disk_tablesTemp Tables On Disk (cumulative)NA
first_seenFirst SeenNA

Sys Statement By Exec Count (SysStatementByExecCount), collected every 5 Min

Section titled “Sys Statement By Exec Count (SysStatementByExecCount), collected every 5 Min”

Top 25 statement digests by execution count, from sys.x$statement_analysis.

ColumnLabelUnitWarningCritical
digest (key)DigestNA
queryQueryNA
db (key)DbNA
full_scanFull Scan (”*” = full scan)NA
exec_countExecutions (cumulative)NA
err_countErrors (cumulative)NA
warn_countWarnings (cumulative)NA
total_latencyTotal Latency (us, cumulative)MICROSEC
max_latencyMax Latency (us, slowest execution)MICROSEC
avg_latencyAvg Latency (us per execution)MICROSEC
lock_latencyLock Wait Time (us, cumulative)MICROSEC
rows_sentRows Sent to Client (cumulative)NA
rows_examinedRows Examined (cumulative)NA
rows_affectedRows Affected (cumulative)NA
tmp_tablesTemp Tables Created (cumulative)NA
tmp_disk_tablesTemp Tables On Disk (cumulative)NA
first_seenFirst SeenNA

Sys Statement By First Seen (SysStatementByFirstSeen), collected every 5 Min

Section titled “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.

ColumnLabelUnitWarningCritical
digest (key)DigestNA
queryQueryNA
db (key)DbNA
full_scanFull Scan (”*” = full scan)NA
exec_countExecutions (cumulative)NA
err_countErrors (cumulative)NA
warn_countWarnings (cumulative)NA
total_latencyTotal Latency (us, cumulative)MICROSEC
max_latencyMax Latency (us, slowest execution)MICROSEC
avg_latencyAvg Latency (us per execution)MICROSEC
lock_latencyLock Wait Time (us, cumulative)MICROSEC
rows_sentRows Sent to Client (cumulative)NA
rows_examinedRows Examined (cumulative)NA
rows_affectedRows Affected (cumulative)NA
tmp_tablesTemp Tables Created (cumulative)NA
tmp_disk_tablesTemp Tables On Disk (cumulative)NA
first_seenFirst SeenNA

Sys InnoDB Lock Waits (SysInnodbLockWaits), collected every 5 Min

Section titled “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.

ColumnLabelUnitWarningCritical
waiting_lock_id (key)Waiting Lock IdNA
blocking_lock_id (key)Blocking Lock IdNA
locked_schemaLocked SchemaNA
locked_tableLocked TableNA
locked_indexLocked IndexNA
locked_typeLocked Type (RECORD | TABLE)NA
waiting_lock_modeWaiting Lock ModeNA
blocking_lock_modeBlocking Lock ModeNA
waiting_pidWaiting PidNA
blocking_pidBlocking PidNA
waiting_trx_idWaiting Trx IdNA
blocking_trx_idBlocking Trx IdNA
waiting_secondsLock Wait Age (seconds; -1 = unknown)SECOND

Sys Table Lock Waits (SysTableLockWaits), collected every 5 Min

Section titled “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.

ColumnLabelUnitWarningCritical
object_schema (key)Object SchemaNA
object_name (key)Object NameNA
waiting_thread_id (key)Waiting Thread IdNA
waiting_pidWaiting PidNA
waiting_lock_typeWaiting Lock Type (SHARED_READ | EXCLUSIVE | …)NA
waiting_lock_durationWaiting Lock DurationNA
blocking_thread_idBlocking Thread IdNA
blocking_pidBlocking PidNA
blocking_lock_typeBlocking Lock Type (SHARED_READ | EXCLUSIVE | …)NA
blocking_lock_durationBlocking Lock DurationNA
waiting_secondsWait Time (seconds in MDL wait state; -1 = unknown)SECOND

Sys Processlist (SysProcesslist), collected every 5 Min

Section titled “Sys Processlist (SysProcesslist), collected every 5 Min”

Active, non-idle sessions and their current statement, from sys.x$processlist.

ColumnLabelUnitWarningCritical
thd_id (key)Thd IdNA
conn_idConn IdNA
userUserNA
dbDbNA
commandCommandNA
stateStateNA
timeTime in Current StateSECOND
current_statementCurrent StatementNA
statement_latencyStatement Running TimeMICROSEC
lock_latencyLock Wait TimeMICROSEC
rows_examinedRows Examined by StatementNA
rows_sentRows Sent by StatementNA
rows_affectedRows Affected by StatementNA
tmp_tablesTemp Tables Created by StatementNA
tmp_disk_tablesTemp Tables on Disk by StatementNA
trx_stateTransaction State (ACTIVE | COMMITTED | ROLLED BACK)NA

Backup History (BackupHistory), collected every 1 Hr

Section titled “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.

ColumnLabelUnitWarningCritical
source (key)SourceNA
backup_id (key)Backup IDNA
backup_typeBackup Type (full | incremental | partial)NA
start_timeStart TimeNA
end_timeEnd TimeNA
run_secondsRun Time (sec)SECOND
lock_secondsLock Time (sec)SECOND
end_lsnEnd LSNNA
binlog_positionBinlog Position (PITR)NA
exit_stateExit State (SUCCESS | COMPLETED | INCOMPLETE | …)NA
successSuccess (0/1: 1 = backup completed OK)NA

Backup Status (BackupStatus), collected every 1 Hr

Section titled “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.

ColumnLabelUnitWarningCritical
meb_presentMEB Detected (0/1: 1 = mysql.backup_history exists)NA
pxb_presentXtraBackup Detected (0/1: 1 = PERCONA_SCHEMA exists)NA
pxb_history_enabledXtraBackup History Enabled (0/1: 1 = history table exists)NA
last_sourceLast Backup SourceNA
last_exit_stateLast Exit State (SUCCESS | COMPLETED | INCOMPLETE | …)NA
last_successful_end_timeLast Successful BackupNA
hours_since_last_successHours Since Last Successful Backup (empty = none/unknown)HOURS> 26> 50
last_backup_failedLast Backup Failed (0/1: 1 = failed)NA> 0
never_succeededNever Succeeded (0/1: 1 = no success on record)NA> 0
backup_history_visibleBackup History Visible (0/1: 1 = backup history table present)NA

Character Set (CharacterSet), configuration snapshot, collected every 24 Hr

Section titled “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.

ColumnLabelUnitWarningCritical
CLIENTClientNA
CONNECTIONConnectionNA
DATABASEDatabaseNA
DIRECTORYDirectoryNA
FILESYSTEMFilesystemNA
RESULTSResultsNA
SERVERServerNA
SYSTEMSystemNA

Connection Buffers (ConnectionBuffers), configuration snapshot, collected every 24 Hr

Section titled “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.

ColumnLabelUnitWarningCritical
BULK_INSERT_BUFFER_SIZEBulk Insert Buffer Size (bytes)BYTE
JOIN_BUFFER_SIZEJoin Buffer Size (bytes)BYTE
MAX_ALLOWED_PACKETMax Allowed Packet (bytes)BYTE
NET_BUFFER_LENGTHNet Buffer Length (bytes)BYTE
PRELOAD_BUFFER_SIZEPreload Buffer Size (bytes)BYTE
QUERY_ALLOC_BLOCK_SIZEQuery Alloc Block Size (bytes)BYTE
QUERY_PREALLOC_SIZEQuery Prealloc Size (bytes)BYTE
READ_BUFFER_SIZERead Buffer Size (bytes)BYTE
READ_RND_BUFFER_SIZERead Rnd Buffer Size (bytes)BYTE
SORT_BUFFER_SIZESort Buffer Size (bytes)BYTE
STORED_PROGRAM_CACHEStored Program Cache (routines per session)NA
THREAD_STACKThread Stack (bytes)BYTE
TRANSACTION_ALLOC_BLOCK_SIZETransaction Alloc Block Size (bytes)BYTE
TRANSACTION_PREALLOC_SIZETransaction Prealloc Size (bytes)BYTE

Metadata (Metadata), configuration snapshot, collected every 24 Hr

Section titled “Metadata (Metadata), configuration snapshot, collected every 24 Hr”

Configuration snapshot of the server’s Metadata settings, captured for configuration history and compliance evaluation.

ColumnLabelUnitWarningCritical
LICENSELicenseNA
PROTOCOL_VERSIONProtocol Version (number)NA
VERSIONVersionNA
VERSION_COMMENTVersion CommentNA
VERSION_COMPILE_MACHINEVersion Compile MachineNA
VERSION_COMPILE_OSVersion Compile OSNA

Replication Source Configuration (ReplicationSourceConfig), configuration snapshot, collected every 24 Hr

Section titled “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.

ColumnLabelUnitWarningCritical
AUTO_INCREMENT_INCREMENTAuto-Increment StepNA
AUTO_INCREMENT_OFFSETAuto-Increment Start OffsetNA
ENFORCE_GTID_CONSISTENCYEnforce Gtid ConsistencyNA
GTID_EXECUTEDGtid ExecutedNA
GTID_EXECUTED_COMPRESS_PERIODGTID Compression Period (transactions)NA
GTID_MODEGtid ModeNA
GTID_OWNEDGtid OwnedNA
GTID_PURGEDGtid PurgedNA
SEMI_SYNC_SOURCE_ENABLEDSemi Sync Source EnabledNA
SEMI_SYNC_SOURCE_TIMEOUTSemi-Sync Source Timeout (ms)MILLISECONDS
SEMI_SYNC_SOURCE_TRACE_LEVELSemi-Sync Source Trace Level (bit mask)NA
SEMI_SYNC_SRC_WAIT_NO_REPLICASemi Sync Source Wait No ReplicaNA
SERVER_IDServer ID (this server)NA
SOURCE_VERIFY_CHECKSUMSource Verify ChecksumNA

Replication Replica Configuration (ReplicationReplicaConfig), configuration snapshot, collected every 24 Hr

Section titled “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.

ColumnLabelUnitWarningCritical
ALLOW_BATCHINGAllow BatchingNA
CHECKPOINT_GROUPCheckpoint Group (transactions)NA
CHECKPOINT_PERIODCheckpoint Period (ms)MILLISECONDS
COMPRESSED_PROTOCOLCompressed ProtocolNA
EXEC_MODEExec ModeNA
GTID_MODEGtid ModeNA
INIT_REPLICAInit ReplicaNA
LOAD_TMPDIRLoad TmpdirNA
LOG_REPLICA_UPDATESLog Replica UpdatesNA
MAX_ALLOWED_PACKETMax Allowed Packet (bytes)BYTE
MAX_RELAY_LOG_SIZEMax Relay Log Size (bytes; 0 = max_binlog_size)BYTE
NET_TIMEOUTNet Timeout (s)SECOND
PARALLEL_TYPEParallel Type (DATABASE | LOGICAL_CLOCK)NA
PARALLEL_WORKERSParallel Workers (threads)NA
PENDING_JOBS_SIZE_MAXPending Jobs Size Max (bytes)BYTE
PRESERVE_COMMIT_ORDERPreserve Commit OrderNA
READ_ONLYRead OnlyNA
RELAY_LOGRelay LogNA
RELAY_LOG_BASENAMERelay Log BasenameNA
RELAY_LOG_INDEXRelay Log IndexNA
RELAY_LOG_PURGERelay Log PurgeNA
RELAY_LOG_RECOVERYRelay Log RecoveryNA
RELAY_LOG_SPACE_LIMITRelay Log Space Limit (bytes; 0 = unlimited)BYTE
REPORT_HOSTReport HostNA
REPORT_PORTReport Port (TCP)NA
REPORT_USERReport UserNA
SEMI_SYNC_REPLICA_ENABLEDSemi Sync Replica EnabledNA
SEMI_SYNC_REPLICA_TRACE_LEVELSemi-Sync Replica Trace Level (bit mask)NA
SERVER_IDServer ID (this server)NA
SKIP_ERRORSSkip ErrorsNA
SQL_VERIFY_CHECKSUMSql Verify ChecksumNA
SYNC_SOURCE_INFOSync Source Info (events)NA
SYNC_RELAY_LOGSync Relay Log (events)NA
SYNC_RELAY_LOG_INFOSync Relay Log Info (transactions)NA
TRANSACTION_RETRIESTransaction Retries (limit)NA
TYPE_CONVERSIONSType ConversionsNA

Information Schema Configuration (InformationSchema), configuration snapshot, collected every 24 Hr

Section titled “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.

ColumnLabelUnitWarningCritical
STATS_EXPIRYStats Expiry (s)SECOND

Data Dictionary Configuration (DataDictionary), configuration snapshot, collected every 24 Hr

Section titled “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.

ColumnLabelUnitWarningCritical
SCHEMA_DEFINITION_CACHESchema Definition Cache (objects)NA
TABLE_DEFINITION_CACHETable Definition Cache (objects)NA
TABLESPACE_DEFINITION_CACHETablespace Definition Cache (objects)NA
STORED_PROGRAM_DEF_CACHEStored Program Definition Cache (objects)NA

Binary Logs (BinaryLogs), configuration snapshot, collected every 24 Hr

Section titled “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.

ColumnLabelUnitWarningCritical
BINLOG_CACHE_SIZEBinlog Cache Size (bytes)BYTE
BINLOG_CHECKSUMBinlog ChecksumNA
BINLOG_DIRECT_NON_TRX_UPDATESBinlog Direct Non Trx UpdatesNA
BINLOG_ERROR_ACTIONBinlog Error ActionNA
BINLOG_EXPIRE_LOGS_SECONDSBinlog Expire Logs (s)SECOND
BINLOG_FORMATBinlog FormatNA
BINLOG_GROUP_COMMIT_SYNC_DELAYGroup Commit Sync Delay (us)MICROSEC
BINLOG_GROUP_COMMIT_SYNC_NDCGroup Commit No-Delay Count (transactions)NA
BINLOG_GTID_SIMPLE_RECOVERYBinlog Gtid Simple RecoveryNA
BINLOG_MAX_FLUSH_QUEUE_TIMEMax Flush Queue Time (us)MICROSEC
BINLOG_ORDER_COMMITSBinlog Order CommitsNA
BINLOG_ROW_IMAGEBinlog Row ImageNA
BINLOG_ROW_METADATABinlog Row MetadataNA
BINLOG_ROWS_QUERY_LOG_EVENTBinlog Rows Query Log EventNA
BINLOG_ROW_VALUE_OPTIONSBinlog Row Value OptionsNA
BINLOG_STMT_CACHE_SIZEBinlog Stmt Cache Size (bytes)BYTE
BINLOG_TRX_DEP_HISTORY_SIZETrx Dependency History Size (row hashes)NA
BINLOG_TRUST_FUNC_CREATORSBinlog Trust Func CreatorsNA
LOG_BIN_BASENAMELog Bin BasenameNA
LOG_BINLog BinNA
LOG_BIN_INDEXLog Bin IndexNA
MAX_BINLOG_CACHE_SIZEMax Binlog Cache Size (bytes)BYTE
MAX_BINLOG_SIZEMax Binlog Size (bytes)BYTE
MAX_BINLOG_STMT_CACHE_SIZEMax Binlog Stmt Cache Size (bytes)BYTE
SYNC_BINLOGSync Binlog (0 = OS flush | N = fsync every N commit groups)NA

Secure Connections (SecureConnections), configuration snapshot, collected every 24 Hr

Section titled “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.

ColumnLabelUnitWarningCritical
CACaNA
CA_PATHCa PathNA
CERTCertNA
CIPHERCipherNA
CRLCrlNA
CRL_PATHCrl PathNA
KEYKeyNA
TLS_VERSIONTls VersionNA
REQUIRE_SECURE_TRANSPORTRequire Secure TransportNA

Audit Log (AuditLog), configuration snapshot, collected every 24 Hr

Section titled “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.

ColumnLabelUnitWarningCritical
BUFFER_SIZEBuffer SizeNA
CONN_POLICYConn PolicyNA
ENABLED_STATEAudit Log Disable Switch (ON = logging off | OFF = logging on)NA
EXCLUDE_ACCOUNTSExclude AccountsNA
AUDIT_LOG_FILEAudit Log FileNA
FLUSHFlushNA
FORMATFormatNA
INCLUDE_ACCOUNTSInclude AccountsNA
POLICYPolicyNA
ROTATE_ON_SIZERotate On SizeNA
STMT_POLICYStmt PolicyNA
STRATEGYStrategyNA

Firewall (Firewall), configuration snapshot, collected every 24 Hr

Section titled “Firewall (Firewall), configuration snapshot, collected every 24 Hr”

Configuration snapshot of the server’s Firewall settings, captured for configuration history and compliance evaluation.

ColumnLabelUnitWarningCritical
MAX_QUERY_SIZEMax Query SizeNA
FIREWALL_MODEFirewall ModeNA
TRACETraceNA

Connection (Connection), configuration snapshot, collected every 24 Hr

Section titled “Connection (Connection), configuration snapshot, collected every 24 Hr”

Configuration snapshot of the server’s Connection settings, captured for configuration history and compliance evaluation.

ColumnLabelUnitWarningCritical
BACK_LOGBack Log (pending connections)NA
CONNECT_TIMEOUTConnect Timeout (s)SECOND
INIT_CONNECTInit ConnectNA
INTERACTIVE_TIMEOUTInteractive Timeout (s)SECOND
MAX_CONNECT_ERRORSMax Connect Errors (limit)NA
MAX_CONNECTIONSMax Connections (limit)NA
MAX_USER_CONNECTIONSMax User Connections (0 = no limit)NA
NET_BUFFER_LENGTHNet Buffer Length (bytes)BYTE
NET_READ_TIMEOUTNet Read Timeout (s)SECOND
NET_RETRY_COUNTNet Retry Count (retries)NA
NET_WRITE_TIMEOUTNet Write Timeout (s)SECOND
OFFLINE_MODEOffline ModeNA
SESSION_TRACK_GTIDSSession Track GtidsNA
SESSION_TRACK_SCHEMASession Track SchemaNA
SESSION_TRACK_STATE_CHANGESession Track State ChangeNA
SESSION_TRACK_SYSTEM_VARIABLESSession Track System VariablesNA
SKIP_NAME_RESOLVESkip Name ResolveNA
WAIT_TIMEOUTWait Timeout (s)SECOND

Connection (ConnectionLive), collected on demand

Section titled “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.

ColumnLabelUnitWarningCritical
BACK_LOGBack Log (pending connections)NA
CONNECT_TIMEOUTConnect Timeout (s)SECOND
INIT_CONNECTInit ConnectNA
INTERACTIVE_TIMEOUTInteractive Timeout (s)SECOND
MAX_CONNECT_ERRORSMax Connect Errors (limit)NA
MAX_CONNECTIONSMax Connections (limit)NA
MAX_USER_CONNECTIONSMax User Connections (0 = no limit)NA
NET_BUFFER_LENGTHNet Buffer Length (bytes)BYTE
NET_READ_TIMEOUTNet Read Timeout (s)SECOND
NET_RETRY_COUNTNet Retry Count (retries)NA
NET_WRITE_TIMEOUTNet Write Timeout (s)SECOND
OFFLINE_MODEOffline ModeNA
SESSION_TRACK_GTIDSSession Track GtidsNA
SESSION_TRACK_SCHEMASession Track SchemaNA
SESSION_TRACK_STATE_CHANGESession Track State ChangeNA
SESSION_TRACK_SYSTEM_VARIABLESSession Track System VariablesNA
SKIP_NAME_RESOLVESkip Name ResolveNA
WAIT_TIMEOUTWait Timeout (s)SECOND

Environment (Environment), configuration snapshot, collected every 24 Hr

Section titled “Environment (Environment), configuration snapshot, collected every 24 Hr”

Configuration snapshot of the server’s Environment settings, captured for configuration history and compliance evaluation.

ColumnLabelUnitWarningCritical
BASEDIRBasedirNA
CORE_FILECore FileNA
DATADIRDatadirNA
HOSTNAMEHostnameNA
INIT_FILEInit FileNA
KEEP_FILES_ON_CREATEKeep Files On CreateNA
LARGE_FILES_SUPPORTLarge Files SupportNA
LARGE_PAGESLarge PagesNA
LARGE_PAGE_SIZELarge Page Size (bytes)BYTE
LOCKED_IN_MEMORYLocked In MemoryNA
LOWER_CASE_FILE_SYSTEMLower Case File SystemNA
OPEN_FILES_LIMITOpen Files Limit (files)NA
PERSISTED_GLOBALS_LOADPersisted Globals LoadNA
PID_FILEPid FileNA
PLUGIN_DIRPlugin DirNA
SKIP_EXTERNAL_LOCKINGSkip External LockingNA
SQL_MODESql ModeNA
TMPDIRTmpdirNA

HostCache (HostCache), configuration snapshot, collected every 24 Hr

Section titled “HostCache (HostCache), configuration snapshot, collected every 24 Hr”

Configuration snapshot of the server’s HostCache settings, captured for configuration history and compliance evaluation.

ColumnLabelUnitWarningCritical
HOST_CACHE_SIZEHost Cache Size (entries)NA

Threads (Threads), configuration snapshot, collected every 24 Hr

Section titled “Threads (Threads), configuration snapshot, collected every 24 Hr”

Configuration snapshot of the server’s Threads settings, captured for configuration history and compliance evaluation.

ColumnLabelUnitWarningCritical
THREAD_CACHE_SIZEThread Cache Size (threads)NA
THREAD_HANDLINGThread HandlingNA
SLOW_LAUNCH_TIMESlow Launch Time (s)SECOND
THREAD_STACKThread Stack (bytes)BYTE

Threads (ThreadsLive), collected on demand

Section titled “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.

ColumnLabelUnitWarningCritical
THREAD_CACHE_SIZEThread Cache Size (threads)NA
THREAD_HANDLINGThread HandlingNA
SLOW_LAUNCH_TIMESlow Launch Time (s)SECOND
THREAD_STACKThread Stack (bytes)BYTE

Transactions (Transactions), configuration snapshot, collected every 24 Hr

Section titled “Transactions (Transactions), configuration snapshot, collected every 24 Hr”

Configuration snapshot of the server’s Transactions settings, captured for configuration history and compliance evaluation.

ColumnLabelUnitWarningCritical
AUTOCOMMITAutocommitNA
COMPLETION_TYPECompletion Type (NO_CHAIN | CHAIN | RELEASE)NA
TRANSACTION_ISOLATIONTransaction IsolationNA
TRANSACTION_READ_ONLYTransaction Read OnlyNA

Networking (Networking), configuration snapshot, collected every 24 Hr

Section titled “Networking (Networking), configuration snapshot, collected every 24 Hr”

Configuration snapshot of the server’s Networking settings, captured for configuration history and compliance evaluation.

ColumnLabelUnitWarningCritical
BIND_ADDRESSBind AddressNA
PORTPort (TCP listen)NA
SKIP_NAME_RESOLVESkip Name ResolveNA
SKIP_NETWORKINGSkip NetworkingNA
SOCKETSocketNA

Optimizer (Optimizer), configuration snapshot, collected every 24 Hr

Section titled “Optimizer (Optimizer), configuration snapshot, collected every 24 Hr”

Configuration snapshot of the server’s Optimizer settings, captured for configuration history and compliance evaluation.

ColumnLabelUnitWarningCritical
END_MARKERS_IN_JSONEnd Markers In JsonNA
EQ_RANGE_INDEX_DIVE_LIMITEq Range Index Dive Limit (ranges)NA
HISTOGRAM_GEN_MAX_MEM_SIZEHistogram Gen Max Memory (bytes)BYTE
MAX_LENGTH_FOR_SORT_DATAMax Length For Sort Data (bytes)BYTE
MAX_SEEKS_FOR_KEYMax Seeks For Key (seeks)NA
MAX_SORT_LENGTHMax Sort Length (bytes)BYTE
PRUNE_LEVELPrune Level (0 = exhaustive | 1 = heuristic)NA
RANGE_ALLOC_BLOCK_SIZERange Alloc Block Size (bytes)BYTE
SEARCH_DEPTHSearch Depth (tables)NA
SWITCH_VALUESwitch ValueNA
TRACETraceNA
TRACE_FEATURESTrace FeaturesNA
TRACE_LIMITTrace Limit (traces)NA
TRACE_MAX_MEM_SIZETrace Max Memory (bytes)BYTE
TRACE_OFFSETTrace Offset (traces)NA
WINDOWING_USE_HIGH_PRECISIONWindowing Use High PrecisionNA

Optimizer (OptimizerLive), collected on demand

Section titled “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.

ColumnLabelUnitWarningCritical
END_MARKERS_IN_JSONEnd Markers In JsonNA
EQ_RANGE_INDEX_DIVE_LIMITEq Range Index Dive Limit (ranges)NA
HISTOGRAM_GEN_MAX_MEM_SIZEHistogram Gen Max Memory (bytes)BYTE
MAX_LENGTH_FOR_SORT_DATAMax Length For Sort Data (bytes)BYTE
MAX_SEEKS_FOR_KEYMax Seeks For Key (seeks)NA
MAX_SORT_LENGTHMax Sort Length (bytes)BYTE
PRUNE_LEVELPrune Level (0 = exhaustive | 1 = heuristic)NA
RANGE_ALLOC_BLOCK_SIZERange Alloc Block Size (bytes)BYTE
SEARCH_DEPTHSearch Depth (tables)NA
SWITCH_VALUESwitch ValueNA
TRACETraceNA
TRACE_FEATURESTrace FeaturesNA
TRACE_LIMITTrace Limit (traces)NA
TRACE_MAX_MEM_SIZETrace Max Memory (bytes)BYTE
TRACE_OFFSETTrace Offset (traces)NA
WINDOWING_USE_HIGH_PRECISIONWindowing Use High PrecisionNA

Logging (Logging), configuration snapshot, collected every 24 Hr

Section titled “Logging (Logging), configuration snapshot, collected every 24 Hr”

Configuration snapshot of the server’s Logging settings, captured for configuration history and compliance evaluation.

ColumnLabelUnitWarningCritical
GENERAL_LOGGeneral LogNA
GENERAL_LOG_FILEGeneral Log FileNA
LOG_ERRORLog ErrorNA
LOG_ERROR_SERVICESLog Error ServicesNA
LOG_ERROR_VERBOSITYLog Error Verbosity (1 = errors | 2 = +warnings | 3 = +notes)NA
LOG_OUTPUTLog OutputNA
LOG_TIMESTAMPSLog TimestampsNA
SQL_LOG_DISABLEDSql Log DisabledNA

Slow Query Logging (SlowQueryLogging), configuration snapshot, collected every 24 Hr

Section titled “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.

ColumnLabelUnitWarningCritical
LOG_QUERIES_NOT_USING_INDEXESLog Queries Not Using IndexesNA
LOG_SLOW_ADMIN_STMTSLog Slow Admin StmtsNA
LOG_SLOW_QUERIESLog Slow QueriesNA
LOG_SLOW_SLAVE_STMTSLog Slow Slave StmtsNA
THROTTLE_STMTS_NOT_INDXThrottle Non-Indexed Queries (per minute)NA
LONG_QUERY_TIMELong Query Time (s)SECOND
MIN_EXAMINED_ROW_LIMITMin Examined Row Limit (rows)NA
SLOW_QUERY_LOG_FILESlow Query Log FileNA

Statement Processing (StatementProcessing), configuration snapshot, collected every 24 Hr

Section titled “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.

ColumnLabelUnitWarningCritical
AUTO_IS_NULLAuto Is NullNA
BIG_SELECTSBig SelectsNA
BUFFER_RESULTBuffer ResultNA
CTE_MAX_RECURSION_DEPTHCTE Max Recursion Depth (levels)NA
DIV_PRECISION_INCREMENTDivision Precision Increment (digits)NA
GROUP_CONCAT_MAX_LENGroup Concat Max Length (bytes)BYTE
INTERNAL_TMP_MEM_STORAGE_ENGInternal Tmp Mem Storage EngNA
MAX_DIGEST_LENGTHMax Digest Length (bytes)BYTE
MAX_ERROR_COUNTMax Error Count (messages)NA
MAX_EXECUTION_TIMEMax Execution Time (ms; 0 = no limit)MILLISECONDS
MAX_JOIN_SIZEMax Join Size (row combinations)NA
MAX_PREPARED_STMT_COUNTMax Prepared Statements (limit)NA
MAX_SP_RECURSION_DEPTHMax SP Recursion Depth (levels)NA
MAX_WRITE_LOCK_COUNTMax Write Lock Count (locks)NA
NOTESNotesNA
QUOTE_SHOW_CREATEQuote Show CreateNA
SAFE_UPDATESSafe UpdatesNA
SELECT_LIMITSelect Limit (rows)NA
TEMPTABLE_MAX_RAMTempTable Max RAM (bytes)BYTE
WARNINGSWarningsNA

Statement Processing (StatementProcessingLive), collected on demand

Section titled “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.

ColumnLabelUnitWarningCritical
AUTO_IS_NULLAuto Is NullNA
BIG_SELECTSBig SelectsNA
BUFFER_RESULTBuffer ResultNA
CTE_MAX_RECURSION_DEPTHCTE Max Recursion Depth (levels)NA
DIV_PRECISION_INCREMENTDivision Precision Increment (digits)NA
GROUP_CONCAT_MAX_LENGroup Concat Max Length (bytes)BYTE
INTERNAL_TMP_MEM_STORAGE_ENGInternal Tmp Mem Storage EngNA
MAX_DIGEST_LENGTHMax Digest Length (bytes)BYTE
MAX_ERROR_COUNTMax Error Count (messages)NA
MAX_EXECUTION_TIMEMax Execution Time (ms; 0 = no limit)MILLISECONDS
MAX_JOIN_SIZEMax Join Size (row combinations)NA
MAX_PREPARED_STMT_COUNTMax Prepared Statements (limit)NA
MAX_SP_RECURSION_DEPTHMax SP Recursion Depth (levels)NA
MAX_WRITE_LOCK_COUNTMax Write Lock Count (locks)NA
NOTESNotesNA
QUOTE_SHOW_CREATEQuote Show CreateNA
SAFE_UPDATESSafe UpdatesNA
SELECT_LIMITSelect Limit (rows)NA
TEMPTABLE_MAX_RAMTempTable Max RAM (bytes)BYTE
WARNINGSWarningsNA

MyISAM (Myisam), configuration snapshot, collected every 24 Hr

Section titled “MyISAM (Myisam), configuration snapshot, collected every 24 Hr”

Configuration snapshot of the server’s MyISAM settings, captured for configuration history and compliance evaluation.

ColumnLabelUnitWarningCritical
CONCURRENT_INSERTConcurrent InsertNA
DELAY_KEY_WRITEDelay Key WriteNA
KEEP_FILES_ON_CREATEKeep Files On CreateNA
KEY_BUFFER_SIZEKey Buffer Size (bytes)BYTE
KEY_CACHE_AGE_THRESHOLDKey Cache Age Threshold (setting)NA
KEY_CACHE_BLOCK_SIZEKey Cache Block Size (bytes)BYTE
KEY_CACHE_DIVISION_LIMITKey Cache Division Limit (% warm sublist)PERCENTAGE
MYISAM_DATA_POINTER_SIZEMyISAM Data Pointer Size (bytes)BYTE
MYISAM_MAX_SORT_FILE_SIZEMyISAM Max Sort File Size (bytes)BYTE
MYISAM_MMAP_SIZEMyISAM Mmap Size (bytes)BYTE
MYISAM_RECOVER_OPTIONSMyisam Recover OptionsNA
MYISAM_SORT_BUFFER_SIZEMyISAM Sort Buffer Size (bytes)BYTE
MYISAM_STATS_METHODMyisam Stats MethodNA
MYISAM_USE_MMAPMyisam Use MmapNA
SKIP_EXTERNAL_LOCKINGSkip External LockingNA

MyISAM Full-Text (MyisamFullText), configuration snapshot, collected every 24 Hr

Section titled “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.

ColumnLabelUnitWarningCritical
BOOLEAN_SYNTAXBoolean SyntaxNA
MAX_WORD_LENMax Word Length (characters)NA
MIN_WORD_LENMin Word Length (characters)NA
QUERY_EXPANSION_LIMITQuery Expansion Limit (rows)NA
STOPWORD_FILEStopword FileNA

Table Configuration (TableConfiguration), configuration snapshot, collected every 24 Hr

Section titled “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.

ColumnLabelUnitWarningCritical
BIG_TABLESBig TablesNA
DEFAULT_STORAGE_ENGINEDefault Storage EngineNA
DEFAULT_TMP_STORAGE_ENGINEDefault Tmp Storage EngineNA
EXPLICIT_DEFAULT_FOR_TSExplicit Default For TsNA
FLUSHFlushNA
FLUSH_TIMEFlush Time (s)SECOND
LOCK_WAIT_TIMEOUTLock Wait Timeout (s)SECOND
LOWER_CASE_FILE_SYSTEMLower Case File SystemNA
LOWER_CASE_TABLE_NAMESLower Case Table Names (0 | 1 | 2)NA
LOW_PRIORITY_UPDATESLow Priority UpdatesNA
MAX_HEAP_TABLE_SIZEMax Heap Table Size (bytes)BYTE
OLD_ALTER_TABLEOld Alter TableNA
OPEN_FILES_LIMITOpen Files Limit (files)NA
TABLE_DEFINITION_CACHETable Definition Cache (tables)NA
TABLE_OPEN_CACHETable Open Cache (tables)NA
TABLE_OPEN_CACHE_INSTANCESTable Open Cache Instances (instances)NA
TMP_TABLE_SIZETmp Table Size (bytes)BYTE
UPDATABLE_VIEWS_WITH_LIMITUpdatable Views With LimitNA

Table Configuration (TableConfigurationLive), collected on demand

Section titled “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.

ColumnLabelUnitWarningCritical
BIG_TABLESBig TablesNA
DEFAULT_STORAGE_ENGINEDefault Storage EngineNA
DEFAULT_TMP_STORAGE_ENGINEDefault Tmp Storage EngineNA
EXPLICIT_DEFAULT_FOR_TSExplicit Default For TsNA
FLUSHFlushNA
FLUSH_TIMEFlush Time (s)SECOND
LOCK_WAIT_TIMEOUTLock Wait Timeout (s)SECOND
LOWER_CASE_FILE_SYSTEMLower Case File SystemNA
LOWER_CASE_TABLE_NAMESLower Case Table Names (0 | 1 | 2)NA
LOW_PRIORITY_UPDATESLow Priority UpdatesNA
MAX_HEAP_TABLE_SIZEMax Heap Table Size (bytes)BYTE
OLD_ALTER_TABLEOld Alter TableNA
OPEN_FILES_LIMITOpen Files Limit (files)NA
TABLE_DEFINITION_CACHETable Definition Cache (tables)NA
TABLE_OPEN_CACHETable Open Cache (tables)NA
TABLE_OPEN_CACHE_INSTANCESTable Open Cache Instances (instances)NA
TMP_TABLE_SIZETmp Table Size (bytes)BYTE
UPDATABLE_VIEWS_WITH_LIMITUpdatable Views With LimitNA

Collation (Collation), configuration snapshot, collected every 24 Hr

Section titled “Collation (Collation), configuration snapshot, collected every 24 Hr”

Configuration snapshot of the server’s Collation settings, captured for configuration history and compliance evaluation.

ColumnLabelUnitWarningCritical
CONNConnNA
DATABASEDatabaseNA
SERVER_DEFAULTServer DefaultNA

Localization (Localization), configuration snapshot, collected every 24 Hr

Section titled “Localization (Localization), configuration snapshot, collected every 24 Hr”

Configuration snapshot of the server’s Localization settings, captured for configuration history and compliance evaluation.

ColumnLabelUnitWarningCritical
DEFAULT_WEEK_FORMATDefault Week Format (mode 0-7)NA
MESSAGESMessagesNA
MESSAGES_DIRMessages DirNA
SYSTEM_TIME_ZONESystem Time ZoneNA
TIME_NAMESTime NamesNA
TIME_ZONETime ZoneNA

InnoDB Configuration (InnodbConfiguration), configuration snapshot, collected every 24 Hr

Section titled “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.

ColumnLabelUnitWarningCritical
ADAPTIVE_FLUSHINGAdaptive FlushingNA
ADAPTIVE_FLUSHING_LWMAdaptive Flushing Low Water Mark (% of redo)PERCENTAGE
ADAPTIVE_HASH_INDEXAdaptive Hash IndexNA
ADAPTIVE_MAX_SLEEP_DELAYAdaptive Max Sleep Delay (us)MICROSEC
AUTOEXTEND_INCREMENTAutoextend Increment (MB)MB
AUTOINC_LOCK_MODEAutoinc Lock Mode (0 trad. | 1 consec. | 2 interleaved)NA
BUFFER_POOL_CHUNK_SIZEBuffer Pool Chunk Size (bytes)BYTE
BUFFER_POOL_DUMP_AT_SHUTDOWNBuffer Pool Dump At ShutdownNA
BUFFER_POOL_DUMP_NOWBuffer Pool Dump NowNA
BUFFER_POOL_DUMP_PCTBuffer Pool Dump (% of pages)PERCENTAGE
BUFFER_POOL_FILENAMEBuffer Pool FilenameNA
BUFFER_POOL_INSTANCESBuffer Pool Instances (count)NA
BUFFER_POOL_LOAD_AT_STARTUPBuffer Pool Load At StartupNA
BUFFER_POOL_LOAD_NOWBuffer Pool Load NowNA
BUFFER_POOL_SIZEBuffer Pool Size (bytes)BYTE
CHANGE_BUFFERINGChange BufferingNA
CHANGE_BUFFER_MAX_SIZEChange Buffer Max Size (% of buffer pool)PERCENTAGE
CHECKSUM_ALGORITHMChecksum AlgorithmNA
COMMIT_CONCURRENCYCommit Concurrency (threads)NA
COMPRESSION_LEVELCompression Level (0-9 zlib)NA
COMPRESSION_PAD_PCT_MAXCompression Pad Max (% of page)PERCENTAGE
CONCURRENCY_TICKETSConcurrency Tickets (tickets)NA
DATA_FILE_PATHData File PathNA
DATA_HOME_DIRData Home DirNA
DEDICATED_SERVERDedicated ServerNA
DISABLE_SORT_FILE_CACHEDisable Sort File CacheNA
DOUBLEWRITEDoublewriteNA
FAST_SHUTDOWNFast Shutdown (0 slow | 1 fast | 2 crash-like)NA
FILE_PER_TABLEFile Per TableNA
FILL_FACTORFill Factor (% of page)PERCENTAGE
FLUSHING_AVG_LOOPSFlushing Avg Loops (iterations)NA
FLUSH_LOG_AT_TIMEOUTFlush Log At Timeout (s)SECOND
FLUSH_LOG_AT_TRX_COMMITFlush Log at Trx Commit (0 | 1 | 2)NA
FLUSH_METHODFlush MethodNA
FLUSH_NEIGHBORSFlush Neighbors (0 off | 1 contiguous | 2 all)NA
FORCE_LOAD_CORRUPTEDForce Load CorruptedNA
FORCE_RECOVERYForce Recovery (0 = off | 1-6 = recovery level)NA
FOREIGN_KEY_CHECKSForeign Key ChecksNA
IO_CAPACITYI/O Capacity (IOPS)IOSEC
IO_CAPACITY_MAXI/O Capacity Max (IOPS)IOSEC
LOCK_WAIT_TIMEOUTLock Wait Timeout (s)SECOND
LOG_BUFFER_SIZELog Buffer Size (bytes)BYTE
LOG_COMPRESSED_PAGESLog Compressed PagesNA
LOG_FILES_IN_GROUPLog Files In Group (files)NA
LOG_FILE_SIZELog File Size (bytes)BYTE
LOG_GROUP_HOME_DIRLog Group Home DirNA
LOG_WRITE_AHEAD_SIZELog Write Ahead Size (bytes)BYTE
LRU_SCAN_DEPTHLRU Scan Depth (pages)NA
MAX_DIRTY_PAGES_PCTMax Dirty Pages (%)PERCENTAGE
MAX_DIRTY_PAGES_PCT_LWMMax Dirty Pages Low Water Mark (%)PERCENTAGE
MAX_PURGE_LAGMax Purge Lag (history length)NA
MAX_PURGE_LAG_DELAYMax Purge Lag Delay (us)MICROSEC
MAX_UNDO_LOG_SIZEMax Undo Log Size (bytes)BYTE
MONITOR_DISABLEMonitor DisableNA
MONITOR_ENABLEMonitor EnableNA
MONITOR_RESETMonitor ResetNA
MONITOR_RESET_ALLMonitor Reset AllNA
OLD_BLOCKS_PCTOld Blocks (% of buffer pool)PERCENTAGE
OLD_BLOCKS_TIMEOld Blocks Time (ms)MILLISECONDS
ONLINE_ALTER_LOG_MAX_SIZEOnline Alter Log Max Size (bytes)BYTE
OPEN_FILESOpen Files (files)NA
PAGE_CLEANERSPage Cleaners (threads)NA
PAGE_SIZEPage Size (bytes)BYTE
PRINT_ALL_DEADLOCKSPrint All DeadlocksNA
PRINT_DDL_LOGSPrint Ddl LogsNA
PURGE_BATCH_SIZEPurge Batch Size (undo pages)NA
PURGE_RSEG_TRUNCATE_FREQUENCYPurge Rseg Truncate Frequency (purges)NA
PURGE_THREADSPurge Threads (threads)NA
RANDOM_READ_AHEADRandom Read AheadNA
READ_AHEAD_THRESHOLDRead Ahead Threshold (pages)NA
READ_IO_THREADSRead I/O ThreadsNA
READ_ONLYRead OnlyNA
REDO_LOG_ENCRYPTRedo Log EncryptNA
ROLLBACK_ON_TIMEOUTRollback On TimeoutNA
SORT_BUFFER_SIZESort Buffer Size (bytes)BYTE
SPIN_WAIT_DELAYSpin Wait Delay (multiplier)NA
STATS_AUTO_RECALCStats Auto RecalcNA
STATS_METHODStats MethodNA
STATS_ON_METADATAStats On MetadataNA
STATS_PERSISTENTStats PersistentNA
STATS_PERSISTENT_SAMPLE_PAGESStats Persistent Sample Pages (pages)NA
STRICT_MODEStrict ModeNA
SYNC_ARRAY_SIZESync Array Size (arrays)NA
SYNC_SPIN_LOOPSSync Spin Loops (iterations)NA
TABLE_LOCKSTable LocksNA
TEMP_DATA_FILE_PATHTemp Data File PathNA
THREAD_CONCURRENCYThread Concurrency (threads)NA
THREAD_SLEEP_DELAYThread Sleep Delay (us)MICROSEC
UNDO_DIRECTORYUndo DirectoryNA
UNDO_LOG_ENCRYPTUndo Log EncryptNA
UNDO_LOG_TRUNCATEUndo Log TruncateNA
UNDO_TABLESPACESUndo Tablespaces (count)NA
UNIQUE_CHECKSUnique ChecksNA
USE_NATIVE_AIOUse Native AioNA
WRITE_IO_THREADSWrite I/O ThreadsNA

InnoDB Configuration (InnodbConfigurationLive), collected on demand

Section titled “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.

ColumnLabelUnitWarningCritical
ADAPTIVE_FLUSHINGAdaptive FlushingNA
ADAPTIVE_FLUSHING_LWMAdaptive Flushing Low Water Mark (% of redo)PERCENTAGE
ADAPTIVE_HASH_INDEXAdaptive Hash IndexNA
ADAPTIVE_MAX_SLEEP_DELAYAdaptive Max Sleep Delay (us)MICROSEC
AUTOEXTEND_INCREMENTAutoextend Increment (MB)MB
AUTOINC_LOCK_MODEAutoinc Lock Mode (0 trad. | 1 consec. | 2 interleaved)NA
BUFFER_POOL_CHUNK_SIZEBuffer Pool Chunk Size (bytes)BYTE
BUFFER_POOL_DUMP_AT_SHUTDOWNBuffer Pool Dump At ShutdownNA
BUFFER_POOL_DUMP_NOWBuffer Pool Dump NowNA
BUFFER_POOL_DUMP_PCTBuffer Pool Dump (% of pages)PERCENTAGE
BUFFER_POOL_FILENAMEBuffer Pool FilenameNA
BUFFER_POOL_INSTANCESBuffer Pool Instances (count)NA
BUFFER_POOL_LOAD_AT_STARTUPBuffer Pool Load At StartupNA
BUFFER_POOL_LOAD_NOWBuffer Pool Load NowNA
BUFFER_POOL_SIZEBuffer Pool Size (bytes)BYTE
CHANGE_BUFFERINGChange BufferingNA
CHANGE_BUFFER_MAX_SIZEChange Buffer Max Size (% of buffer pool)PERCENTAGE
CHECKSUM_ALGORITHMChecksum AlgorithmNA
COMMIT_CONCURRENCYCommit Concurrency (threads)NA
COMPRESSION_LEVELCompression Level (0-9 zlib)NA
COMPRESSION_PAD_PCT_MAXCompression Pad Max (% of page)PERCENTAGE
CONCURRENCY_TICKETSConcurrency Tickets (tickets)NA
DATA_FILE_PATHData File PathNA
DATA_HOME_DIRData Home DirNA
DEDICATED_SERVERDedicated ServerNA
DISABLE_SORT_FILE_CACHEDisable Sort File CacheNA
DOUBLEWRITEDoublewriteNA
FAST_SHUTDOWNFast Shutdown (0 slow | 1 fast | 2 crash-like)NA
FILE_PER_TABLEFile Per TableNA
FILL_FACTORFill Factor (% of page)PERCENTAGE
FLUSHING_AVG_LOOPSFlushing Avg Loops (iterations)NA
FLUSH_LOG_AT_TIMEOUTFlush Log At Timeout (s)SECOND
FLUSH_LOG_AT_TRX_COMMITFlush Log at Trx Commit (0 | 1 | 2)NA
FLUSH_METHODFlush MethodNA
FLUSH_NEIGHBORSFlush Neighbors (0 off | 1 contiguous | 2 all)NA
FORCE_LOAD_CORRUPTEDForce Load CorruptedNA
FORCE_RECOVERYForce Recovery (0 = off | 1-6 = recovery level)NA
FOREIGN_KEY_CHECKSForeign Key ChecksNA
IO_CAPACITYI/O Capacity (IOPS)IOSEC
IO_CAPACITY_MAXI/O Capacity Max (IOPS)IOSEC
LOCK_WAIT_TIMEOUTLock Wait Timeout (s)SECOND
LOG_BUFFER_SIZELog Buffer Size (bytes)BYTE
LOG_COMPRESSED_PAGESLog Compressed PagesNA
LOG_FILES_IN_GROUPLog Files In Group (files)NA
LOG_FILE_SIZELog File Size (bytes)BYTE
LOG_GROUP_HOME_DIRLog Group Home DirNA
LOG_WRITE_AHEAD_SIZELog Write Ahead Size (bytes)BYTE
LRU_SCAN_DEPTHLRU Scan Depth (pages)NA
MAX_DIRTY_PAGES_PCTMax Dirty Pages (%)PERCENTAGE
MAX_DIRTY_PAGES_PCT_LWMMax Dirty Pages Low Water Mark (%)PERCENTAGE
MAX_PURGE_LAGMax Purge Lag (history length)NA
MAX_PURGE_LAG_DELAYMax Purge Lag Delay (us)MICROSEC
MAX_UNDO_LOG_SIZEMax Undo Log Size (bytes)BYTE
MONITOR_DISABLEMonitor DisableNA
MONITOR_ENABLEMonitor EnableNA
MONITOR_RESETMonitor ResetNA
MONITOR_RESET_ALLMonitor Reset AllNA
OLD_BLOCKS_PCTOld Blocks (% of buffer pool)PERCENTAGE
OLD_BLOCKS_TIMEOld Blocks Time (ms)MILLISECONDS
ONLINE_ALTER_LOG_MAX_SIZEOnline Alter Log Max Size (bytes)BYTE
OPEN_FILESOpen Files (files)NA
PAGE_CLEANERSPage Cleaners (threads)NA
PAGE_SIZEPage Size (bytes)BYTE
PRINT_ALL_DEADLOCKSPrint All DeadlocksNA
PRINT_DDL_LOGSPrint Ddl LogsNA
PURGE_BATCH_SIZEPurge Batch Size (undo pages)NA
PURGE_RSEG_TRUNCATE_FREQUENCYPurge Rseg Truncate Frequency (purges)NA
PURGE_THREADSPurge Threads (threads)NA
RANDOM_READ_AHEADRandom Read AheadNA
READ_AHEAD_THRESHOLDRead Ahead Threshold (pages)NA
READ_IO_THREADSRead I/O ThreadsNA
READ_ONLYRead OnlyNA
REDO_LOG_ENCRYPTRedo Log EncryptNA
ROLLBACK_ON_TIMEOUTRollback On TimeoutNA
SORT_BUFFER_SIZESort Buffer Size (bytes)BYTE
SPIN_WAIT_DELAYSpin Wait Delay (multiplier)NA
STATS_AUTO_RECALCStats Auto RecalcNA
STATS_METHODStats MethodNA
STATS_ON_METADATAStats On MetadataNA
STATS_PERSISTENTStats PersistentNA
STATS_PERSISTENT_SAMPLE_PAGESStats Persistent Sample Pages (pages)NA
STRICT_MODEStrict ModeNA
SYNC_ARRAY_SIZESync Array Size (arrays)NA
SYNC_SPIN_LOOPSSync Spin Loops (iterations)NA
TABLE_LOCKSTable LocksNA
TEMP_DATA_FILE_PATHTemp Data File PathNA
THREAD_CONCURRENCYThread Concurrency (threads)NA
THREAD_SLEEP_DELAYThread Sleep Delay (us)MICROSEC
UNDO_DIRECTORYUndo DirectoryNA
UNDO_LOG_ENCRYPTUndo Log EncryptNA
UNDO_LOG_TRUNCATEUndo Log TruncateNA
UNDO_TABLESPACESUndo Tablespaces (count)NA
UNIQUE_CHECKSUnique ChecksNA
USE_NATIVE_AIOUse Native AioNA
WRITE_IO_THREADSWrite I/O ThreadsNA

Performance Schema (PerformanceSchema), configuration snapshot, collected every 24 Hr

Section titled “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.

ColumnLabelUnitWarningCritical
ACCOUNTS_SIZEAccounts Size (rows)NA
DIGESTS_SIZEDigests Size (rows)NA
ENABLEDEnabledNA
ERROR_SIZEError Size (error codes)NA
STAGES_HISTORY_LONG_SIZEStages History Long Size (rows)NA
EVENTS_STAGES_HISTORY_SIZEEvents Stages History Size (rows/thread)NA
STMTS_HISTORY_LONG_SIZEStatements History Long Size (rows)NA
EVENTS_STMTS_HISTORY_SIZEEvents Statements History Size (rows/thread)NA
EVENTS_TRXS_HISTORY_LONG_SIZETransactions History Long Size (rows)NA
EVENTS_TRXS_HISTORY_SIZEEvents Transactions History Size (rows/thread)NA
EVENTS_WAITS_HISTORY_LONG_SIZEWaits History Long Size (rows)NA
EVENTS_WAITS_HISTORY_SIZEEvents Waits History Size (rows/thread)NA
HOSTS_SIZEHosts Size (rows)NA
MAX_COND_CLASSESMax Condition Classes (limit)NA
MAX_COND_INSTANCESMax Condition Instances (limit)NA
MAX_DIGEST_LENGTHMax Digest Length (bytes)BYTE
MAX_DIGEST_SAMPLE_AGEMax Digest Sample Age (s)SECOND
MAX_FILE_CLASSESMax File Classes (limit)NA
MAX_FILE_HANDLESMax File Handles (limit)NA
MAX_FILE_INSTANCESMax File Instances (limit)NA
MAX_INDEX_STATMax Index Stat (indexes)NA
MAX_MEMORY_CLASSESMax Memory Classes (limit)NA
MAX_METADATA_LOCKSMax Metadata Locks (locks)NA
MAX_MUTEX_CLASSESMax Mutex Classes (limit)NA
MAX_MUTEX_INSTANCESMax Mutex Instances (limit)NA
MAX_PREPARED_STMTS_INSTANCESMax Prepared Statement Instances (limit)NA
MAX_PROGRAM_INSTANCESMax Program Instances (limit)NA
MAX_RWLOCK_CLASSESMax RWLock Classes (limit)NA
MAX_RWLOCK_INSTANCESMax RWLock Instances (limit)NA
MAX_SOCKET_CLASSESMax Socket Classes (limit)NA
MAX_SOCKET_INSTANCESMax Socket Instances (limit)NA
MAX_SQL_TEXT_LENGTHMax SQL Text Length (bytes)BYTE
MAX_STAGE_CLASSESMax Stage Classes (limit)NA
MAX_STMT_CLASSESMax Statement Classes (limit)NA
MAX_STMT_STACKMax Statement Stack (levels)NA
MAX_TABLE_HANDLESMax Table Handles (limit)NA
MAX_TABLE_INSTANCESMax Table Instances (limit)NA
MAX_TABLE_LOCK_STATMax Table Lock Stat (tables)NA
MAX_THREAD_CLASSESMax Thread Classes (limit)NA
MAX_THREAD_INSTANCESMax Thread Instances (limit)NA
SESSION_CONNECT_ATTRS_SIZESession Connect Attrs Size (bytes)BYTE
SETUP_ACTORS_SIZESetup Actors Size (rows)NA
SETUP_OBJECTS_SIZESetup Objects Size (rows)NA
USERS_SIZEUsers Size (rows)NA

Capabilities (Capabilities), configuration snapshot, collected every 24 Hr

Section titled “Capabilities (Capabilities), configuration snapshot, collected every 24 Hr”

Configuration snapshot of the server’s Capabilities settings, captured for configuration history and compliance evaluation.

ColumnLabelUnitWarningCritical
CAPABILITIES_COMPRESSCapabilities CompressNA
DYNAMIC_LOADINGDynamic LoadingNA
GEOMETRY_TYPESGeometry TypesNA
PROFILINGProfilingNA
QUERY_CACHEQuery CacheNA
RTREE_KEYSRtree KeysNA
STMT_TIMEOUTStmt TimeoutNA
SYMLINKSymlinkNA
EVENT_SCHEDULEREvent SchedulerNA

Binary Log Status (BinaryLogStatus), configuration snapshot, collected every 24 Hr

Section titled “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.

ColumnLabelUnitWarningCritical
BINLOG_DO_DBBinlog Do DBNA
BINLOG_IGNORE_DBBinlog Ignore DBNA

Security (Security), configuration snapshot, collected every 24 Hr

Section titled “Security (Security), configuration snapshot, collected every 24 Hr”

Configuration snapshot of the server’s Security settings, captured for configuration history and compliance evaluation.

ColumnLabelUnitWarningCritical
ACTIVATE_ALL_ROLES_ON_LOGINActivate All Roles On LoginNA
AUTO_GENERATE_CERTSAuto Generate CertsNA
AUTOMATIC_SP_PRIVILEGESAutomatic Sp PrivilegesNA
CACHING_SHA2_PASS_PRIVKEY_PATHCaching Sha2 Pass Privkey PathNA
CACHING_SHA2_PASS_PUBKEY_PATHCaching Sha2 Pass Pubkey PathNA
CHECK_PROXY_USERSCheck Proxy UsersNA
DEFAULT_PASSWORD_LIFETIMEDefault Password Lifetime (days; 0 = never)DAYS
DISCONNECT_ON_EXPIRED_PASSWORDDisconnect On Expired PasswordNA
LOCAL_INFILELocal InfileNA
MANDATORY_ROLESMandatory RolesNA
MYSQL_NATIVE_PW_PROXY_USERSMysql Native Pw Proxy UsersNA
PASSWORD_HISTORYPassword History (passwords)NA
PASSWORD_REUSE_INTERVALPassword Reuse Interval (days; 0 = none)DAYS
SECURE_FILE_PRIVILEGESSecure File PrivilegesNA
SHA256_PW_AUTO_GEN_RSA_KEYSSha256 Pw Auto Gen Rsa KeysNA
SHA256_PW_PRIVATE_KEY_PATHSha256 Pw Private Key PathNA
SHA256_PASSWORD_PROXY_USERSSha256 Password Proxy UsersNA
SHA256_PW_PUBLIC_KEY_PATHSha256 Pw Public Key PathNA
SKIP_SHOW_DATABASESkip Show DatabaseNA
AUTHENTICATION_POLICYAuthentication PolicyNA

Password Validation (PasswordValidation), configuration snapshot, collected every 24 Hr

Section titled “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.

ColumnLabelUnitWarningCritical
DICTIONARY_FILEDictionary FileNA
LENGTHMin Password Length (characters)NA
MIXED_CASE_COUNTMin Mixed-Case Characters (each case)NA
NUMBER_COUNTMin DigitsNA
POLICYPolicyNA
SPECIAL_CHAR_COUNTMin Special CharactersNA

Security Accounts (SecurityAccounts), configuration snapshot, collected every 24 Hr

Section titled “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.

ColumnLabelUnitWarningCritical
USER_HOST (key)User HostNA
USER_NAMEUserNA
HOSTHostNA
AUTH_PLUGINAuth PluginNA
ACCOUNT_LOCKEDAccount Locked (0/1: 1 = locked)NA
IS_ANONYMOUSAnonymous Account (0/1: 1 = empty user name)NA
IS_REMOTE_ROOTRemote Root (0/1: 1 = root from a non-local host)NA
HAS_ALL_PRIVILEGESHas All Privileges (0/1: 1 = every static privilege)NA
HAS_GRANT_OPTIONHas Grant Option (0/1: 1 = can grant privileges)NA
HAS_FILE_PRIVHas FILE Privilege (0/1: 1 = yes)NA
HAS_PROCESS_PRIVHas PROCESS Privilege (0/1: 1 = yes)NA
HAS_SHUTDOWN_PRIVHas SHUTDOWN Privilege (0/1: 1 = yes)NA
HAS_SUPER_PRIVHas SUPER Privilege (0/1: 1 = SUPER or equivalent)NA
HAS_MYSQL_SCHEMA_WRITEHas mysql Schema Write (0/1: 1 = can write)NA
HAS_EMPTY_PASSWORDHas Empty Password (0/1: 1 = empty password)NA
HAS_LOGIN_LOCKOUTHas Login Lockout (0/1: 1 = lockout configured)NA

Security Config Ext (SecurityConfigExt), configuration snapshot, collected every 24 Hr

Section titled “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.

ColumnLabelUnitWarningCritical
PARTIAL_REVOKESPartial RevokesNA
BINLOG_ENCRYPTIONBinlog EncryptionNA
DEFAULT_TABLE_ENCRYPTIONDefault Table EncryptionNA
AUDIT_LOG_ENCRYPTIONAudit Log EncryptionNA
KEYRING_AVAILABLEKeyring Available (0/1: 1 = plugin or component active)NA
CONNECTION_CONTROL_INSTALLEDConnection Control Installed (0/1: 1 = plugin active)NA

InnoDB Fulltext (InnodbFulltext), configuration snapshot, collected every 24 Hr

Section titled “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.

ColumnLabelUnitWarningCritical
AUX_TABLEAux TableNA
CACHE_SIZEFT Cache Size (bytes)BYTE
ENABLE_DIAG_PRINTEnable Diag PrintNA
ENABLE_STOPWORDEnable StopwordNA
MAX_TOKEN_SIZEFT Max Token Size (characters)NA
MIN_TOKEN_SIZEFT Min Token Size (characters)NA
NUM_WORD_OPTIMIZEFT Words Per OPTIMIZE (words)NA
OPTIMIZE_FULLTEXT_ONLYOptimize Fulltext OnlyNA
RESULT_CACHE_LIMITFT Result Cache Limit (bytes)BYTE
SERVER_STOPWORD_TABLEServer Stopword TableNA
SORT_PLL_DEGREEFT Sort Parallel Degree (threads)NA
TOTAL_CACHE_SIZEFT Total Cache Size (bytes)BYTE
USER_STOPWORD_TABLEUser Stopword TableNA

InnoDB Memcached Configuration (InnodbMemcachedConfiguration), configuration snapshot, collected every 24 Hr

Section titled “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.

ColumnLabelUnitWarningCritical
BK_COMMIT_INTERVALBackground Commit Interval (s)SECOND
DISABLE_ROWLOCKDisable RowlockNA
ENABLE_BINLOGEnable BinlogNA
ENABLE_MDLEnable MdlNA
ENGINE_LIB_NAMEEngine Lib NameNA
ENGINE_LIB_PATHEngine Lib PathNA
OPTIONSOptionsNA
READ_BATCH_SIZERead Batch Size (operations)NA
TRX_LEVELTrx Isolation Level (0 | 1 | 2 | 3)NA
WRITE_BATCH_SIZEWrite Batch Size (operations)NA

Insert Delayed (InsertDelayed), configuration snapshot, collected every 24 Hr

Section titled “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.

ColumnLabelUnitWarningCritical
INSERT_LIMITInsert Limit (rows)NA
INSERT_TIMEOUTInsert Timeout (s)SECOND
MAX_DELAYED_THREADSMax Delayed Threads (threads)NA
QUEUE_SIZEQueue Size (rows)NA

NDB (Ndb), configuration snapshot, collected every 24 Hr

Section titled “NDB (Ndb), configuration snapshot, collected every 24 Hr”

Configuration snapshot of the server’s NDB settings, captured for configuration history and compliance evaluation.

ColumnLabelUnitWarningCritical
ENGINE_CONDITION_PUSHDOWNEngine Condition PushdownNA
NDB_AUTOINC_PREFETCHAuto-Increment Prefetch (values)NA

Thread Pool (ThreadPool), configuration snapshot, collected every 24 Hr

Section titled “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.

ColumnLabelUnitWarningCritical
ALGORITHMAlgorithm (0 = low concurrency | 1 = high concurrency)NA
HIGH_PRIORITY_CONNHigh Priority Connection (0/1: 1 = high priority)NA
MAX_UNUSED_THREADSMax Unused Threads (threads)NA
PRIO_KICKUP_TIMERPriority Kickup Timer (ms)MILLISECONDS
THREAD_POOL_SIZEThread Pool Size (thread groups)NA
STALL_LIMITStall Limit (10 ms units)NA

Wait Profile (Top Waits) (WaitProfile), collected every 1 Min

Section titled “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.

ColumnLabelUnitWarningCritical
event_name (key)Event NameNA
wait_classWait ClassNA
d_countWait Count (since prev. collection, ~1 min)NA
d_time_usWait Time (since prev. collection, ~1 min)MICROSEC
avg_wait_usAvg Wait (since prev. collection, ~1 min)MICROSEC> 1000000> 5000000

Wait Profile Summary (WaitProfileSummary), collected every 1 Min

Section titled “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. An interval with no wait activity is reported explicitly (zero totals, top event and class idle); only the first collection after the agent starts reports nothing.

ColumnLabelUnitWarningCritical
total_wait_time_usTotal Wait Time, all events (since prev. collection, ~1 min)MICROSEC
active_event_countActive Wait Events (since prev. collection, ~1 min)NA
top_wait_eventTop Wait Event (since prev. collection, ~1 min)NA
top_wait_time_usTop Wait Time (since prev. collection, ~1 min)MICROSEC
top_wait_classTop Wait Class (since prev. collection, ~1 min)NA= lock

Query Analytics (Statement Digest Deltas) (StatementDigestProfile), collected every 5 Min

Section titled “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.

ColumnLabelUnitWarningCritical
digest (key)Statement DigestNA
d_exec_countExecutions (since prev. collection, ~5 min)NA
d_total_latency_usTotal Latency (since prev. collection, ~5 min)MICROSEC
d_avg_latency_usAverage Latency (since prev. collection, ~5 min)MICROSEC
d_lock_time_usLock Time (since prev. collection, ~5 min)MICROSEC
d_rows_examinedRows Examined (since prev. collection, ~5 min)NA
d_rows_sentRows Sent (since prev. collection, ~5 min)NA
d_rows_examined_per_sentRows Examined per Row Sent (ratio, since prev. collection)NA
d_no_index_usedExecutions Without an Index (since prev. coll., ~5 min)NA

Query Analytics Summary (StatementDigestProfileSummary), collected every 5 Min

Section titled “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.

ColumnLabelUnitWarningCritical
total_latency_usTotal Statement Latency, all digests, last 5 minMICROSEC
total_exec_countTotal Executions, all digests, last 5 minNA
active_digest_countActive Statement Digests, last 5 minNA
top_digestTop Statement Digest, last 5 minNA
top_digest_latency_usTop Statement Latency, last 5 minMICROSEC
digest_overflow_activeDigest Table Overflowing (0/1, 1 = overflowing)NA
digest_capacity_pctDigest Table Used (%)PERCENTAGE

License 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 license is active.

ColumnLabelUnitWarningCritical
statusStatus (Active | Expired | Invalid Signature | …)NA
licensedLicensed (0/1: 1 = license is Active)NA< 1
days_remainingDays Remaining (perpetual if Never Expires = 1)DAYS< 30< 7
expirationExpirationNA
license_typeType (Trial | Enterprise | None | …)NA
instancesLicensed Instances (entitlement)NA
customerCustomerNA
never_expiresNever Expires (0/1: 1 = perpetual license)NA

Monitoring Readiness Detail (readiness_detail), collected on demand

Section titled “Monitoring Readiness Detail (readiness_detail), collected on demand”

Monitoring Readiness checks, one row per requirement, keyed by feature section and check: what each feature needs, what is in effect now, and a status of ok, warn, fail or unknown (unknown means the check could not be decided, for example because the monitoring account cannot read what it inspects). The page runs the same checks live; this collection feeds the Overview row and the hourly history.

ColumnLabelUnitWarningCritical
section (key)Feature SectionNA
item (key)Check IdNA
database_nameDatabase Name (blank: one scope per target)NA
labelRequirementNA
mandatoryMandatory (0/1: 1 = required, 0 = optional)NA
requiredRequired ValueNA
currentCurrent ValueNA
statusStatus (ok | warn | fail | unknown)NA
fixableFixable by the Plug-in (0/1: always 0 in this release)NA
detailDetail and Suggested FixNA

Monitoring Readiness Summary (readiness_summary), collected every 60 Min

Section titled “Monitoring Readiness Summary (readiness_summary), collected every 60 Min”

Single-row rollup of the Monitoring Readiness checks for the Home page: how many features are ok, need attention (warn), are not functional (fail) or could not be checked (unknown). A feature is as bad as its worst check, and an optional check counts at most as a warning. No alert is set on it: readiness is a state to read, not a fault.

ColumnLabelUnitWarningCritical
ok_countFeatures Ready (count of ok features)NA
warn_countFeatures Needing Attention (count of warn)NA
fail_countFeatures Not Functional (count of fail)NA
unknown_countFeatures Not Checked (count of unknown)NA

Table Storage (TableStorage), collected every 60 Min

Section titled “Table Storage (TableStorage), collected every 60 Min”

Table sizes for the Tables page: data, index, free space, estimated rows, engine and row format per table, from INFORMATION_SCHEMA.TABLES. One row for each of the 500 largest user tables, an /other/ row totalling the tables past the cap and a /system/ row totalling the mysql, sys, information_schema and performance_schema schemas, so a total built from the rows is complete. Collected hourly and kept as history: MySQL 8 caches these figures (information_schema_stats_expiry, one day by default), so row counts and sizes can lag recent changes, and run ANALYZE TABLE for fresh numbers. A size the server does not report is blank, never 0. No alert is set on it.

ColumnLabelUnitWarningCritical
table_schema (key)SchemaNA
table_name (key)TableNA
row_kindRow KindNA
table_countTables in RowNA
total_bytesTotal SizeBYTE
data_bytesData SizeBYTE
index_bytesIndex SizeBYTE
data_free_bytesFree SpaceBYTE
row_estimateEstimated RowsNA
engineEngineNA
row_formatRow FormatNA
update_timeLast UpdatedNA

Index Storage (IndexStorage), collected every 60 Min

Section titled “Index Storage (IndexStorage), collected every 60 Min”

Index sizes for the Indexes page: one row per index with its table, columns, uniqueness, primary-key flag, type and cardinality, from INFORMATION_SCHEMA.STATISTICS. Capped like Table Storage: the indexes of the 500 largest user tables, with an /other/ row for the rest and a system-schemas row.

ColumnLabelUnitWarningCritical
table_schema (key)SchemaNA
table_name (key)TableNA
index_name (key)IndexNA
row_kindRow KindNA
index_countIndexes in RowNA
size_bytesSizeBYTE
cardinalityEstimated Distinct KeysNA
is_uniqueUnique (0/1: 1 = enforces uniqueness)NA
is_primaryPrimary Key (0/1: 1 = the PRIMARY KEY)NA
index_typeIndex Type (BTREE|HASH|FULLTEXT|SPATIAL)NA
index_columnsColumnsNA

Index Summary (IndexSummary), collected every 60 Min

Section titled “Index Summary (IndexSummary), collected every 60 Min”

Single-row figures behind the Indexes page tiles: tables read by full scan with no index, unused indexes and redundant indexes (from the sys schema views schema_tables_with_full_table_scans, schema_unused_indexes and schema_redundant_indexes), the number and total size of secondary indexes (primary keys not counted), and the server’s uptime in seconds. A figure the server cannot provide is blank, with the reason in the Indexes page tile.

ColumnLabelUnitWarningCritical
full_scan_tablesTables Read by Full ScanNA
unused_indexesIndexes Unused Since RestartNA
redundant_indexesIndexes Covered by Another IndexNA
total_index_countTotal Secondary IndexesNA
total_index_bytesTotal Secondary Index SizeBYTE
uptime_secondsServer UptimeSECOND
full_scan_noteFull Scan NoteNA
unused_noteUnused NoteNA
redundant_noteRedundant NoteNA
totals_noteTotals NoteNA

Response (Response), collected every 1 Min

Section titled “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.

ColumnLabelUnitWarningCritical
StatusStatus (0/1: 1 = up, 0 = down)NA< 1

Group Replication Members (GroupMembers), collected every 5 Min

Section titled “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.

ColumnLabelUnitWarningCritical
member_id (key)Member IDNA
channel_nameChannel NameNA
member_hostMember HostNA
member_portMember PortNA
member_stateMember State (ONLINE|RECOVERING|OFFLINE|ERROR|UNREACHABLE)NA
member_roleMember Role (PRIMARY | SECONDARY)NA
member_versionMember VersionNA
is_onlineMember Online (0/1: 1 = ONLINE)NA
is_primaryMember Is Primary (0/1: 1 = PRIMARY)NA

Group Replication Member Stats (GroupMemberStats), collected every 5 Min

Section titled “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.

ColumnLabelUnitWarningCritical
member_id (key)Member IDNA
channel_nameChannel NameNA
view_idView IDNA
count_transactions_in_queueTransactions Queued for Certification (current)NA> 100> 1000
count_transactions_checkedTransactions Checked (cumulative since member joined)NA
count_conflicts_detectedConflicts Detected (cumulative since member joined)NA
count_transactions_rows_validatingRows Held for Certification (current)NA
transactions_committed_all_membersTransactions Committed All MembersNA
last_conflict_free_transactionLast Conflict Free TransactionNA
count_transactions_remote_in_applier_queueRemote Transactions in Applier Queue (current)NA> 100> 1000
count_transactions_remote_appliedRemote Transactions Applied (cumulative since member joined)NA
count_transactions_local_proposedLocal Transactions Proposed (cumulative since member joined)NA
count_transactions_local_rollbackLocal Transactions Rolled Back (cumulative since member joined)NA

Group Replication Summary (GroupSummary), collected every 5 Min

Section titled “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.

ColumnLabelUnitWarningCritical
member_countMembers in Group (total)NA
online_countMembers ONLINENA
recovering_countMembers RECOVERINGNA
unreachable_countMembers UNREACHABLENA
error_countMembers in ERROR StateNA
offline_countMembers OFFLINENA
primary_countMembers with PRIMARY RoleNA
secondary_countMembers with SECONDARY RoleNA

Group Replication Consensus (GrConsensus), collected every 5 Min

Section titled “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.

ColumnLabelUnitWarningCritical
member_id (key)Member IDNA
consensus_proposalsConsensus Proposals (since prev. collection, ~5 min)NA
consensus_time_total_usConsensus Time Total (since prev. collection, ~5 min)MICROSEC
avg_consensus_time_usAvg Consensus Time per Proposal (since prev. collection, ~5 min)MICROSEC> 100000> 1000000
empty_consensus_proposalsEmpty Consensus Proposals (since prev. collection, ~5 min)NA
empty_proposal_pctEmpty Proposals (% of proposals, since prev. collection)PERCENTAGE
extended_consensus_countExtended Consensus Rounds (since prev. collection, ~5 min)NA
extended_consensus_pctExtended Consensus (% of proposals, since prev. collection)PERCENTAGE
consensus_bytes_sentConsensus Bytes Sent (since prev. collection, ~5 min)BYTE
consensus_bytes_receivedConsensus Bytes Received (since prev. collection, ~5 min)BYTE
last_consensus_endLast Consensus EndNA

Group Replication Messaging (GrMessaging), collected every 5 Min

Section titled “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.

ColumnLabelUnitWarningCritical
member_id (key)Member IDNA
total_messages_sentTotal Messages Sent (since prev. collection, ~5 min)NA
control_messages_sentControl Messages Sent (since prev. collection, ~5 min)NA
control_messages_bytesControl Message Bytes (since prev. collection, ~5 min)BYTE
control_roundtrip_time_usControl Roundtrip Time Total (since prev. collection, ~5 min)MICROSEC
avg_control_roundtrip_usAvg Control Roundtrip per Message (since prev. collection)MICROSEC
data_messages_sentData Messages Sent (since prev. collection, ~5 min)NA
data_messages_bytesData Message Bytes (since prev. collection, ~5 min)BYTE
data_roundtrip_time_usData Roundtrip Time Total (since prev. collection, ~5 min)MICROSEC
avg_data_roundtrip_usAvg Data Roundtrip per Message (since prev. collection, ~5 min)MICROSEC

Group Replication Certification (GrCertification), collected every 5 Min

Section titled “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.

ColumnLabelUnitWarningCritical
member_id (key)Member IDNA
certification_gc_runsCertification GC Runs (since prev. collection, ~5 min)NA
certification_gc_time_usCertification GC Time (since prev. collection, ~5 min)MICROSEC
consistency_before_begin_countConsistency Waits, Before Begin (since prev. collection, ~5 min)NA
consistency_before_begin_time_usConsistency Wait Time, Before Begin (since prev. collection)MICROSEC
consistency_after_sync_countConsistency Waits, After Sync (since prev. collection, ~5 min)NA
consistency_after_sync_time_usConsistency Wait Time, After Sync (since prev. collection)MICROSEC
consistency_after_termination_countConsistency Waits, After Termination (since prev. collection)NA
consistency_after_termination_time_usConsistency Wait, After Termination (since prev. collection)MICROSEC

Backup Source (BackupSource), collected every 15 Min

Section titled “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.

ColumnLabelUnitWarningCritical
source_uuidSource Member UUIDNA
source_memberSource MemberNA
source_stateSource Member State (ONLINE | RECOVERING | … | blank)NA
source_offlineBackup Source Offline (0/1: 1 = offline; -1 = unknown)NA> 0
last_success_end_timeLast Successful Backup End TimeNA
toolBackup ToolNA

MySQL InnoDB ClusterSet (ip_mysql_clusterset)

Section titled “MySQL InnoDB ClusterSet (ip_mysql_clusterset)”

Response (Response), collected every 1 Min

Section titled “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.

ColumnLabelUnitWarningCritical
StatusStatus (up/down)NA< 1

ClusterSet Health (ClusterSetHealth), collected every 5 Min

Section titled “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, 0 when a readiness check ran and failed, and -1 when readiness was not assessed (the repository rollup, or MySQL Shell could not be used), with health_status READY, NOT_READY or UNKNOWN to match; under a network partition the Shell reports HEALTHY with the replication channel CONNECTING, which this metric surfaces as not promotion-ready.

ColumnLabelUnitWarningCritical
health_sourceHealth Source (ADMINAPI | REPOSITORY_ROLLUP | UNAVAILABLE)NA
fallback_reasonFallback Reason (MYSQLSH_NOT_FOUND | AUTH_FAILED | …)NAmatches ^(AUTH_FAILED|TIMEOUT|UNREACHABLE|MEMBER_UNREACHABLE|KERBEROS_TICKET|KERBEROS_CONFIG_UNREADABLE|TLS_TRUSTSTORE_REQUIRED|PARSE_FAILED)$
primary_healthyPrimary Healthy (0/1: 1=yes, 0=no; -1=not assessed)NA
replica_clusters_healthyReplica Clusters Healthy (0/1: 1=yes, 0=no; -1=not assessed)NA
replication_channel_okReplication Channel OK (0/1: 1=yes, 0=no; -1=not assessed)NA
gtid_lagGTID Lag (transactions behind; -1 not assessed)NA
errant_gtid_countErrant GTID Count (transactions; -1 not assessed)NA
dr_promotion_readyDR Promotion Ready (1 ready | 0 check failed | -1 not assessed)NA= 0
replica_cluster_countReplica Cluster Count (-1 not assessed)NA
domain_nameDomain NameNA
primary_clusterPrimary ClusterNA
global_primary_instanceGlobal Primary InstanceNA
statusStatusNA
status_textStatus TextNA
health_statusHealth Status (READY | NOT_READY | UNKNOWN)NA

ClusterSet Clusters (ClusterSetClusters), collected every 5 Min

Section titled “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.

ColumnLabelUnitWarningCritical
cluster_name (key)ClusterNA
cluster_roleRole (PRIMARY | REPLICA)NA
global_statusGlobal Status (OK | OK_NOT_REPLICATING = stopped | NOT_OK | …)NA
cluster_set_replication_statusClusterSet Replication (OK | STOPPED | …; blank on primary)NA
transaction_set_consistency_statusTransaction Set Consistency (OK | INCONSISTENT | UNAVAILABLE)NA
missing_gtid_countMissing TransactionsNA
errant_gtid_countErrant TransactionsNA
primary_instancePrimary InstanceNA
missing_gtid_setMissing GTID SetNA
errant_gtid_setErrant GTID SetNA

Monitoring Readiness Detail (readiness_detail), collected on demand

Section titled “Monitoring Readiness Detail (readiness_detail), collected on demand”

Monitoring Readiness checks, one row per requirement, keyed by feature section and check: what each feature needs, what is in effect now, and a status of ok, warn, fail or unknown (unknown means the check could not be decided, for example because the monitoring account cannot read what it inspects). The page runs the same checks live; this collection feeds the Overview row and the hourly history.

ColumnLabelUnitWarningCritical
section (key)Feature SectionNA
item (key)Check IdNA
database_nameDatabase Name (blank: one scope per target)NA
labelRequirementNA
mandatoryMandatory (0/1: 1 = required, 0 = optional)NA
requiredRequired ValueNA
currentCurrent ValueNA
statusStatus (ok | warn | fail | unknown)NA
fixableFixable by the Plug-in (0/1: always 0 in this release)NA
detailDetail and Suggested FixNA