prometheus-mysqld-exporter

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

[EXPERIMENTAL] Path to configuration file that can enable TLS or authentication.

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

--tls.insecure-skip-verify

Ignore certificate and server verification when using a tls connection.

--collect.global_status

Collect from SHOW GLOBAL STATUS

--collect.global_variables

Collect from SHOW GLOBAL VARIABLES

--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.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.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.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.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.info_schema.userstats

If running with userstat=1, set to true to collect user statistics

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

Collect from heartbeat

--collect.slave_hosts

Scrape information from ’SHOW SLAVE HOSTS’

--collect.info_schema.replica_host

Collect metrics from information_schema.replica_host_status

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