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 seconds

--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_instance

--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_summary_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 connection.

--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. Repeatable for multiple addresses.

--web.config.file
    Path to configuration file that can enable TLS or authentication. See: https://github.com/prometheus/exporter-toolkit/blob/master/docs/web-configuration.md

--collect.slave_status
    Collect from SHOW SLAVE STATUS

--collect.info_schema.processlist
    Collect current thread state counts from the information_schema.processlist

--collect.mysql.user
    Collect data from mysql.user

--collect.info_schema.tables
    Collect metrics from information_schema.tables

--collect.info_schema.innodb_tablespaces
    Collect metrics from information_schema.innodb_sys_tablespaces

--collect.info_schema.innodb_metrics
    Collect metrics from information_schema.innodb_metrics

--collect.global_status
    Collect from SHOW GLOBAL STATUS

--collect.global_variables
    Collect from SHOW GLOBAL VARIABLES

--collect.perf_schema.tableiowaits
    Collect metrics from performance_schema.table_io_waits_summary_by_table

--collect.perf_schema.indexiowaits
    Collect metrics from performance_schema.table_io_waits_summary_by_index_usage

--collect.perf_schema.tablelocks
    Collect metrics from performance_schema.table_lock_waits_summary_by_table

--collect.perf_schema.eventsstatements
    Collect metrics from performance_schema.events_statements_summary_by_digest

--collect.perf_schema.eventsstatementssum
    Collect metrics of grand sums from performance_schema.events_statements_summary_by_digest

--collect.perf_schema.eventswaits
    Collect metrics from performance_schema.events_waits_summary_global_by_event_name

--collect.auto_increment.columns
    Collect auto_increment columns and max values from information_schema

--collect.binlog_size
    Collect the current size of all registered binlog files

--collect.perf_schema.memory_events
    Collect metrics from performance_schema.memory_summary_global_by_event_name

--collect.perf_schema.replication_group_members
    Collect metrics from performance_schema.replication_group_members

--collect.perf_schema.replication_group_member_stats
    Collect metrics from performance_schema.replication_group_member_stats

--collect.perf_schema.replication_applier_status_by_worker
    Collect metrics from performance_schema.replication_applier_status_by_worker

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

--collect.info_schema.userstats
    If running with userstat=1, set to true to collect user statistics

--collect.perf_schema.file_events
    Collect metrics from performance_schema.file_summary_by_event_name

--collect.perf_schema.file_instances
    Collect metrics from performance_schema.file_summary_by_instance

--collect.info_schema.schemastats
    If running with userstat=1, set to true to collect schema statistics

--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.query_response_time
    Collect query response time distribution if query_response_time_stats is ON.

--collect.engine_tokudb_status
    Collect from SHOW ENGINE TOKUDB STATUS

--collect.engine_innodb_status
    Collect from SHOW ENGINE INNODB STATUS

--collect.info_schema.clientstats
    If running with userstat=1, set to true to collect client statistics

--collect.info_schema.tablestats
    If running with userstat=1, set to true to collect table statistics

--collect.info_schema.replica_host
    Collect metrics from information_schema.replica_host_status

--collect.heartbeat
    Collect from heartbeat

--collect.slave_hosts
    Scrape information from 'SHOW SLAVE HOSTS'

--log.level=info
    Only log messages with the given severity or above. One of: [debug, info, warn, error]

--log.format=logfmt
    Output format of log messages. One of: [logfmt, json]

--version
    Show application version.