Metrics

Label model, derived-metric dictionary, and raw metric families of the MYSQL module.

mysqld_exporter supplies raw mysql_ metrics. vmalert derives mysql:ins:* and mysql:cls:* metrics for dashboards and alerts. This page defines those metrics.

Common Labels

Metrics carry job=mysql, cls, ins, ip, and topology (standalone or innodb_cluster). Instance-derived metrics retain all identity labels. Cluster metrics aggregate to cls and topology.

Availability

Metric	Meaning
`mysql:ins:exporter_up`	Scrape success (transport health)
`mysql:ins:up`	MySQL connection probe success (database health)
`mysql:ins:uptime`	Instance uptime in seconds
`mysql:cls:instances`	Declared instance count
`mysql:cls:up`	Online instance count
`mysql:cls:health`	Cluster health: 2 healthy / 1 degraded-writable / 0 critical

For HA, mysql:cls:health combines quorum, single-primary, and full-membership state. For standalone, it equals 2 × mysql:cls:up.

Workload

Metric	Meaning
`mysql:ins:qps`	Questions per second
`mysql:ins:tps`	Transactions per second (commit + rollback)
`mysql:ins:read_qps` / `mysql:ins:write_qps`	Read-class / write-class command rate
`mysql:ins:row_ops`	InnoDB row operations (read/insert/update/delete dimensions)
`mysql:ins:statement_rate`	Performance-schema statement rate
`mysql:ins:statement_latency`	Mean statement latency (seconds)
`mysql:ins:rows_examined_per_query`	Average rows examined per query
`mysql:ins:statement_errors`	Statement error rate
`mysql:ins:slow_queries` / `mysql:ins:slow_query_ratio`	Slow query rate and ratio
`mysql:ins:no_index_queries`	Rate of queries using no index

Connections and Sessions

Metric	Meaning
`mysql:ins:connections`	Current connections (Threads_connected)
`mysql:ins:connection_usage`	Connections / `max_connections`
`mysql:ins:connection_rate`	New connection rate
`mysql:ins:threads_running` / `mysql:ins:threads_cached`	Active / cached threads
`mysql:ins:aborted_connects` / `mysql:ins:aborted_clients`	Failed handshakes / abnormal disconnects
`mysql:ins:connection_errors`	Total connection error rate
`mysql:ins:rx_bytes` / `mysql:ins:tx_bytes`	Network receive / transmit rate

Temp Tables, Scans, and Caches

Metric	Meaning
`mysql:ins:tmp_tables` / `mysql:ins:tmp_disk_tables`	In-memory / on-disk temp table creation rate
`mysql:ins:tmp_disk_ratio`	Share of temp tables spilling to disk
`mysql:ins:full_joins` / `mysql:ins:full_scans`	Index-less join / full scan rate
`mysql:ins:sort_merge_passes`	Sort merge passes (undersized sort buffer signal)
`mysql:ins:table_open_cache_hit_ratio`	Table open cache hit ratio
`mysql:ins:open_files_usage`	Open file usage ratio

InnoDB

Metric	Meaning
`mysql:ins:buffer_pool_hit_ratio`	Buffer pool hit ratio
`mysql:ins:buffer_pool_usage` / `mysql:ins:buffer_pool_dirty_ratio`	Buffer pool usage / dirty page ratio
`mysql:ins:buffer_pool_waits`	Free-page wait rate (memory pressure signal)
`mysql:ins:data_read_bytes` / `mysql:ins:data_write_bytes`	Data file read / write throughput
`mysql:ins:data_reads` / `mysql:ins:data_writes` / `mysql:ins:data_fsyncs`	Data file I/O and fsync rates
`mysql:ins:redo_bytes`	Redo write throughput
`mysql:ins:redo_utilization`	Redo capacity utilization (checkpoint lag)
`mysql:ins:log_waits`	Redo buffer wait rate
`mysql:ins:row_lock_waits` / `mysql:ins:row_lock_time`	Row lock wait rate / time
`mysql:ins:deadlocks`	Deadlock rate
`mysql:ins:history_list_length`	Purge lag (history list length)
`mysql:ins:binlog_bytes`	Total on-disk binlog size (bytes)

Group Replication

Instance membership flags have value 1 or are absent. False conditions produce no series, so alerts use unless:

Metric	Meaning
`mysql:ins:gr_member`	Instance is in any MGR member state
`mysql:ins:gr_online`	Instance is ONLINE
`mysql:ins:gr_primary` / `mysql:ins:gr_secondary`	Instance is the ONLINE primary / a secondary

Cluster-level quorum and topology:

Metric	Meaning
`mysql:cls:gr_online_members`	ONLINE member count
`mysql:cls:gr_primary_members`	ONLINE primary count
`mysql:cls:gr_quorum`	Majority held (0/1)
`mysql:cls:gr_single_primary`	Exactly one primary (0/1)

Replication pipeline (certification and apply):

Metric	Meaning
`mysql:ins:gr_certifier_queue` / `mysql:ins:gr_applier_queue`	Transactions backed up in certification / applier queues
`mysql:ins:gr_certifier_queue_ratio` / `mysql:ins:gr_applier_queue_ratio`	Queue depth relative to flow-control thresholds
`mysql:ins:gr_checked_rate` / `mysql:ins:gr_applied_rate`	Certification / apply throughput
`mysql:ins:gr_conflict_rate`	Certification conflict rate (should be 0 under single-primary)

Raw Metric Families

For data not covered by derived metrics, query raw exporter families:

Prefix	Content
`mysql_up` / `up`	Database probe / scrape status
`mysql_global_status_*`	Full `SHOW GLOBAL STATUS` counters
`mysql_global_variables_*`	Key system variables (e.g. `max_connections`)
`mysql_perf_schema_events_statements_*`	Statement digests (top 50 by digest)
`mysql_perf_schema_table_io_waits_` / `..._index_io_waits_`	Table / index I/O waits
`mysql_perf_schema_replication_group_member_info`	MGR membership (`member_state` / `member_role` dimensions)
`mysql_perf_schema_transactions_*` / `mysql_perf_schema_conflicts_detected_total`	MGR certification, applier queues, and conflicts
`mysql_binlog_*`	Binlog file count and size
`mysql_info_schema_processlist_*`	Session distribution by state

Browse the complete list with the mysql_ prefix in VictoriaMetrics vmui (/select/vmui).