prometheus-mysqld-exporter(1) 0.17.2 prometheus-mysqld-exporter(1)
NAME
prometheus-mysqld-exporter - Prometheus exporter for MySQL/MariaDB
SYNOPSIS
prometheus-mysqld-exporter [<flags>]
DESCRIPTION
OPTIONS
-h, --help
Show context-sensitive help (also try --help-long and --help-
man).
--exporter.lock_wait_timeout=2
Set a lock_wait_timeout (in seconds) on the connection to avoid
long metadata locking.
--exporter.log_slow_filter
Add a log_slow_filter to avoid slow query logging of scrapes.
NOTE: Not supported by Oracle MySQL.
--collect.heartbeat.database
Database from where to collect heartbeat data
--collect.heartbeat.table
Table from where to collect heartbeat data
--collect.heartbeat.utc
Use UTC for timestamps of the current server (`pt-heartbeat` is
called with `--utc`)
--collect.info_schema.processlist.min_time=0
Minimum time a thread must be in each state to be counted
--collect.info_schema.processlist.processes_by_user
Enable collecting the number of processes by user
--collect.info_schema.processlist.processes_by_host
Enable collecting the number of processes by host
--collect.info_schema.tables.databases
The list of databases to collect table stats for, or '*' for all
--collect.mysql.user.privileges
Enable collecting user privileges from mysql.user
--collect.perf_schema.eventsstatements.limit=250
Limit the number of events statements digests by response time
--collect.perf_schema.eventsstatements.timelimit=86400
Limit how old the 'last_seen' events statements can be, in sec-
onds
--collect.perf_schema.eventsstatements.digest_text_limit=120
Maximum length of the normalized statement text
--collect.perf_schema.file_instances.filter
RegEx file_name filter for performance_schema.file_summary_by_in-
stance
--collect.perf_schema.file_instances.remove_prefix
Remove path prefix in performance_schema.file_summary_by_instance
--collect.perf_schema.memory_events.remove_prefix
Remove instrument prefix in performance_schema.memory_sum-
mary_global_by_event_name
--web.telemetry-path
Path under which to expose metrics.
--timeout-offset=0.25
Offset to subtract from timeout in seconds.
--config.my-cnf
Path to .my.cnf file to read MySQL credentials from.
--mysqld.address
Address to use for connecting to MySQL
--mysqld.username=MYSQLD.USERNAME
Hostname to use for connecting to MySQL
--tls.insecure-skip-verify
Ignore certificate and server verification when using a tls con-
nection.
--web.systemd-socket
Use systemd socket activation listeners instead of port listeners
(Linux only).
--web.listen-address=:9104
Addresses on which to expose metrics and web interface. Repeat-
able for multiple addresses. Examples: `:9100` or `[::1]:9100`
for http, `vsock://:9100` for vsock
--web.config.file
Path to configuration file that can enable TLS or authentication.
See: https://github.com/prometheus/exporter-toolkit/blob/mas-
ter/docs/web-configuration.md
--collect.auto_increment.columns
Collect auto_increment columns and max values from informa-
tion_schema
--collect.binlog_size
Collect the current size of all registered binlog files
--collect.engine_innodb_status
Collect from SHOW ENGINE INNODB STATUS
--collect.engine_tokudb_status
Collect from SHOW ENGINE TOKUDB STATUS
--collect.global_status
Collect from SHOW GLOBAL STATUS
--collect.global_variables
Collect from SHOW GLOBAL VARIABLES
--collect.heartbeat
Collect from heartbeat
--collect.info_schema.clientstats
If running with userstat=1, set to true to collect client statis-
tics
--collect.info_schema.innodb_cmp
Collect metrics from information_schema.innodb_cmp
--collect.info_schema.innodb_cmpmem
Collect metrics from information_schema.innodb_cmpmem
--collect.info_schema.innodb_metrics
Collect metrics from information_schema.innodb_metrics
--collect.info_schema.innodb_tablespaces
Collect metrics from information_schema.innodb_sys_tablespaces
--collect.info_schema.processlist
Collect current thread state counts from the informa-
tion_schema.processlist
--collect.info_schema.query_response_time
Collect query response time distribution if query_re-
sponse_time_stats is ON.
--collect.info_schema.replica_host
Collect metrics from information_schema.replica_host_status
--collect.info_schema.schemastats
If running with userstat=1, set to true to collect schema statis-
tics
--collect.info_schema.tables
Collect metrics from information_schema.tables
--collect.info_schema.tablestats
If running with userstat=1, set to true to collect table statis-
tics
--collect.info_schema.userstats
If running with userstat=1, set to true to collect user statis-
tics
--collect.mysql.user
Collect data from mysql.user
--collect.perf_schema.eventsstatements
Collect metrics from performance_schema.events_statements_sum-
mary_by_digest
--collect.perf_schema.eventsstatementssum
Collect metrics of grand sums from perfor-
mance_schema.events_statements_summary_by_digest
--collect.perf_schema.eventswaits
Collect metrics from performance_schema.events_waits_sum-
mary_global_by_event_name
--collect.perf_schema.file_events
Collect metrics from performance_schema.file_sum-
mary_by_event_name
--collect.perf_schema.file_instances
Collect metrics from performance_schema.file_summary_by_instance
--collect.perf_schema.indexiowaits
Collect metrics from performance_schema.table_io_waits_sum-
mary_by_index_usage
--collect.perf_schema.memory_events
Collect metrics from performance_schema.memory_sum-
mary_global_by_event_name
--collect.perf_schema.replication_applier_status_by_worker
Collect metrics from performance_schema.replication_applier_sta-
tus_by_worker
--collect.perf_schema.replication_group_member_stats
Collect metrics from performance_schema.replication_group_mem-
ber_stats
--collect.perf_schema.replication_group_members
Collect metrics from performance_schema.replication_group_members
--collect.perf_schema.tableiowaits
Collect metrics from performance_schema.table_io_waits_sum-
mary_by_table
--collect.perf_schema.tablelocks
Collect metrics from performance_schema.table_lock_waits_sum-
mary_by_table
--collect.slave_hosts
Scrape information from 'SHOW SLAVE HOSTS'
--collect.slave_status
Collect from SHOW SLAVE STATUS
--collect.sys.user_summary
Collect per user metrics from sys.x$user_summary. See
https://dev.mysql.com/doc/refman/5.7/en/sys-user-summary.html for
details
--log.level=info
Only log messages with the given severity or above. One of: [de-
bug, info, warn, error]
--log.format=logfmt
Output format of log messages. One of: [logfmt, json]
--version
Show application version.
version mysqld_exporter, prometheus-mysqld-exporter(1)
Generated by dwww version 1.16 on Tue Dec 16 06:01:53 CET 2025.