Prometheus exporter for MySQL server metrics. Supported MySQL versions: 5.1 and up. NOTE: Not all collection methods are support on MySQL < 5.6
make
export DATA_SOURCE_NAME="login:password@(hostname:port)/dbname"
./mysqld_exporter <flags>
Running using ~/.my.cnf:
./mysqld_exporter <flags>
| Name | Description |
|---|---|
| collect.auto_increment.columns | Collect auto_increment columns and max values from information_schema. |
| collect.binlog_size | Compute the size of all binlog files combined (as specified by "SHOW MASTER LOGS") |
| collect.info_schema.userstats | If running with userstat=1, set to true to collect user statistics. |
| collect.info_schema.tablestats | If running with userstat=1, set to true to collect table statistics. |
| collect.info_schema.tables | Collect metrics from information_schema.tables. |
| collect.info_schema.tables.databases | The list of databases to collect table stats for, or '*' for all. |
| collect.info_schema.query_response_time | Collect query response time distribution if query_response_time_stats is ON. |
| collect.perf_schema.eventsstatements | Collect metrics from performance_schema.events_statements_summary_by_digest. |
| collect.perf_schema.eventsstatements.limit | Limit the number of events statements digests by response time. (default: 250) |
| collect.perf_schema.eventsstatements.digest_text_limit | Maximum length of the normalized statement text. (default: 120) |
| collect.perf_schema.indexiowaits | Collect metrics from performance_schema.table_io_waits_summary_by_index_usage. |
| 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.perf_schema.file_events | Collect metrics from performance_schema.file_summary_by_event_name. |
| collect.perf_schema.eventswaits | Collect metrics from performance_schema.events_waits_summary_global_by_event_name. |
| collect.info_schema.processlist | Collect thread state counts from information_schema.processlist. |
| config.my-cnf | Path to .my.cnf file to read MySQL credentials from. (default: ~/.my.cnf) |
| log.level | Logging verbosity (default: info) |
| web.listen-address | Address to listen on for web interface and telemetry. |
| web.telemetry-path | Path under which to expose metrics. |
The MySQL server's data source name
must be set via the DATA_SOURCE_NAME environment variable.
The format of this variable is described at https://github.com/go-sql-driver/mysql#dsn-data-source-name.
You can deploy this exporter using the prom/mysqld-exporter Docker image.
For example:
docker pull prom/mysqld-exporter
docker run -d -p 9104:9104 --link=my_mysql_container:bdd \
-e DATA_SOURCE_NAME="user:password@(bdd:3306)/database" prom/mysqld-exporter