.TH prometheus-mysqld-exporter 1 mysqld_exporter, version 0.15.1 (branch: debian/sid, revision: 0.15.1-1) .SH "NAME" prometheus-mysqld-exporter - Prometheus exporter for MySQL/MariaDB .SH "SYNOPSIS" .TP \fBprometheus-mysqld-exporter []\fR .SH "DESCRIPTION" .SH "OPTIONS" .TP \fB-h, --help\fR Show context-sensitive help (also try --help-long and --help-man). .TP \fB--exporter.lock_wait_timeout=2\fR Set a lock_wait_timeout (in seconds) on the connection to avoid long metadata locking. .TP \fB--exporter.log_slow_filter\fR Add a log_slow_filter to avoid slow query logging of scrapes. NOTE: Not supported by Oracle MySQL. .TP \fB--collect.heartbeat.database\fR Database from where to collect heartbeat data .TP \fB--collect.heartbeat.table\fR Table from where to collect heartbeat data .TP \fB--collect.heartbeat.utc\fR Use UTC for timestamps of the current server (`pt-heartbeat` is called with `--utc`) .TP \fB--collect.info_schema.processlist.min_time=0\fR Minimum time a thread must be in each state to be counted .TP \fB--collect.info_schema.processlist.processes_by_user\fR Enable collecting the number of processes by user .TP \fB--collect.info_schema.processlist.processes_by_host\fR Enable collecting the number of processes by host .TP \fB--collect.info_schema.tables.databases\fR The list of databases to collect table stats for, or '*' for all .TP \fB--collect.mysql.user.privileges\fR Enable collecting user privileges from mysql.user .TP \fB--collect.perf_schema.eventsstatements.limit=250\fR Limit the number of events statements digests by response time .TP \fB--collect.perf_schema.eventsstatements.timelimit=86400\fR Limit how old the 'last_seen' events statements can be, in seconds .TP \fB--collect.perf_schema.eventsstatements.digest_text_limit=120\fR Maximum length of the normalized statement text .TP \fB--collect.perf_schema.file_instances.filter\fR RegEx file_name filter for performance_schema.file_summary_by_instance .TP \fB--collect.perf_schema.file_instances.remove_prefix\fR Remove path prefix in performance_schema.file_summary_by_instance .TP \fB--collect.perf_schema.memory_events.remove_prefix\fR Remove instrument prefix in performance_schema.memory_summary_global_by_event_name .TP \fB--web.telemetry-path\fR Path under which to expose metrics. .TP \fB--timeout-offset=0.25\fR Offset to subtract from timeout in seconds. .TP \fB--config.my-cnf\fR Path to .my.cnf file to read MySQL credentials from. .TP \fB--mysqld.address\fR Address to use for connecting to MySQL .TP \fB--mysqld.username=MYSQLD.USERNAME\fR Hostname to use for connecting to MySQL .TP \fB--tls.insecure-skip-verify\fR Ignore certificate and server verification when using a tls connection. .TP \fB--web.systemd-socket\fR Use systemd socket activation listeners instead of port listeners (Linux only). .TP \fB--web.listen-address=:9104\fR Addresses on which to expose metrics and web interface. Repeatable for multiple addresses. .TP \fB--web.config.file\fR Path to configuration file that can enable TLS or authentication. See: https://github.com/prometheus/exporter-toolkit/blob/master/docs/web-configuration.md .TP \fB--collect.info_schema.tables\fR Collect metrics from information_schema.tables .TP \fB--collect.info_schema.innodb_tablespaces\fR Collect metrics from information_schema.innodb_sys_tablespaces .TP \fB--collect.info_schema.innodb_metrics\fR Collect metrics from information_schema.innodb_metrics .TP \fB--collect.global_status\fR Collect from SHOW GLOBAL STATUS .TP \fB--collect.global_variables\fR Collect from SHOW GLOBAL VARIABLES .TP \fB--collect.slave_status\fR Collect from SHOW SLAVE STATUS .TP \fB--collect.info_schema.processlist\fR Collect current thread state counts from the information_schema.processlist .TP \fB--collect.mysql.user\fR Collect data from mysql.user .TP \fB--collect.perf_schema.eventsstatements\fR Collect metrics from performance_schema.events_statements_summary_by_digest .TP \fB--collect.perf_schema.eventsstatementssum\fR Collect metrics of grand sums from performance_schema.events_statements_summary_by_digest .TP \fB--collect.perf_schema.eventswaits\fR Collect metrics from performance_schema.events_waits_summary_global_by_event_name .TP \fB--collect.auto_increment.columns\fR Collect auto_increment columns and max values from information_schema .TP \fB--collect.binlog_size\fR Collect the current size of all registered binlog files .TP \fB--collect.perf_schema.tableiowaits\fR Collect metrics from performance_schema.table_io_waits_summary_by_table .TP \fB--collect.perf_schema.indexiowaits\fR Collect metrics from performance_schema.table_io_waits_summary_by_index_usage .TP \fB--collect.perf_schema.tablelocks\fR Collect metrics from performance_schema.table_lock_waits_summary_by_table .TP \fB--collect.perf_schema.replication_applier_status_by_worker\fR Collect metrics from performance_schema.replication_applier_status_by_worker .TP \fB--collect.sys.user_summary\fR 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 .TP \fB--collect.info_schema.userstats\fR If running with userstat=1, set to true to collect user statistics .TP \fB--collect.perf_schema.file_events\fR Collect metrics from performance_schema.file_summary_by_event_name .TP \fB--collect.perf_schema.file_instances\fR Collect metrics from performance_schema.file_summary_by_instance .TP \fB--collect.perf_schema.memory_events\fR Collect metrics from performance_schema.memory_summary_global_by_event_name .TP \fB--collect.perf_schema.replication_group_members\fR Collect metrics from performance_schema.replication_group_members .TP \fB--collect.perf_schema.replication_group_member_stats\fR Collect metrics from performance_schema.replication_group_member_stats .TP \fB--collect.info_schema.query_response_time\fR Collect query response time distribution if query_response_time_stats is ON. .TP \fB--collect.engine_tokudb_status\fR Collect from SHOW ENGINE TOKUDB STATUS .TP \fB--collect.engine_innodb_status\fR Collect from SHOW ENGINE INNODB STATUS .TP \fB--collect.info_schema.clientstats\fR If running with userstat=1, set to true to collect client statistics .TP \fB--collect.info_schema.tablestats\fR If running with userstat=1, set to true to collect table statistics .TP \fB--collect.info_schema.schemastats\fR If running with userstat=1, set to true to collect schema statistics .TP \fB--collect.info_schema.innodb_cmp\fR Collect metrics from information_schema.innodb_cmp .TP \fB--collect.info_schema.innodb_cmpmem\fR Collect metrics from information_schema.innodb_cmpmem .TP \fB--collect.heartbeat\fR Collect from heartbeat .TP \fB--collect.slave_hosts\fR Scrape information from 'SHOW SLAVE HOSTS' .TP \fB--collect.info_schema.replica_host\fR Collect metrics from information_schema.replica_host_status .TP \fB--log.level=info\fR Only log messages with the given severity or above. One of: [debug, info, warn, error] .TP \fB--log.format=logfmt\fR Output format of log messages. One of: [logfmt, json] .TP \fB--version\fR Show application version.