--- name: "prometheus-mysqld-exporter" section: "1" platform: "linux" package: "prometheus-mysqld-exporter" version: "0.17.2-1+b4" release: "Debian 13 (Trixie)" platforms: ["linux"] url: "https://new.carta.tech/prometheus-mysqld-exporter" --- # prometheus-mysqld-exporter(1) Prometheus exporter for MySQL/MariaDB ## NAME prometheus-mysqld-exporter - Prometheus exporter for MySQL/MariaDB ## SYNOPSIS - **prometheus-mysqld-exporter \[\\]** ## 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. 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/master/docs/web-configuration.md - **--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.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 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.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 information\_schema.processlist - **--collect.info\_schema.query\_response\_time** Collect query response time distribution if query\_response\_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 statistics - **--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 statistics - **--collect.info\_schema.userstats** If running with userstat=1, set to true to collect user statistics - **--collect.mysql.user** Collect data from mysql.user - **--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.indexiowaits** Collect metrics from performance\_schema.table\_io\_waits\_summary\_by\_index\_usage - **--collect.perf\_schema.memory\_events** Collect metrics from performance\_schema.memory\_summary\_global\_by\_event\_name - **--collect.perf\_schema.replication\_applier\_status\_by\_worker** Collect metrics from performance\_schema.replication\_applier\_status\_by\_worker - **--collect.perf\_schema.replication\_group\_member\_stats** Collect metrics from performance\_schema.replication\_group\_member\_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\_summary\_by\_table - **--collect.perf\_schema.tablelocks** Collect metrics from performance\_schema.table\_lock\_waits\_summary\_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: \[debug, info, warn, error\] - **--log.format=logfmt** Output format of log messages. One of: \[logfmt, json\] - **--version** Show application version.