Skip to content

mysqld_exporter job from prometheus/29.1.0

Github source: 9cf244cd or master branch

Properties

mysqld_exporter

collect

auto_increment_columns

Collect auto_increment columns and max values from information_schema

binlog_size

Collect the current size of all registered binlog files

engine_innodb_status

Collect from SHOW ENGINE INNODB STATUS

engine_tokudb_status

Collect from SHOW ENGINE TOKUDB STATUS

global_status

Collect from SHOW GLOBAL STATUS

global_variables

Collect from SHOW GLOBAL VARIABLES

heartbeat

Collect from heartbeat

heartbeat_database

Database from where to collect heartbeat data

heartbeat_table

Table from where to collect heartbeat data

info_schema
clientstats

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

innodb_cmp

Collect metrics from information_schema.innodb_cmp

innodb_cmpmem

Collect metrics from information_schema.innodb_cmpmem

innodb_metrics

Collect metrics from information_schema.innodb_metrics

innodb_tablespaces

Collect metrics from information_schema.innodb_sys_tablespaces

processlist

Collect current thread state counts from the information_schema.processlist

processlist_min_time

Minimum time a thread must be in each state to be counted

query_response_time

Collect query response time distribution if query_response_time_stats is ON

tables

Collect metrics from information_schema.tables

tables_databases

The list of databases to collect table stats for, or ‘*’ for all

tablestats

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

userstats

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

perf_schema
eventsstatements

Collect metrics from performance_schema.events_statements_summary_by_digest

eventsstatements_digest_text_limit

Maximum length of the normalized statement text

eventsstatements_limit

Limit the number of events statements digests by response time

eventsstatements_timelimit

Limit how old the ‘last_seen’ events statements can be, in seconds

eventswaits

Collect metrics from performance_schema.events_waits_summary_global_by_event_name

file_events

Collect metrics from performance_schema.file_summary_by_event_name

file_instances

Collect metrics from performance_schema.file_summary_by_instance

file_instances_filter

RegEx file_name filter for performance_schema.file_summary_by_instance

file_instances_remove_prefix

Remove path prefix in performance_schema.file_summary_by_instance

indexiowaits

Collect metrics from performance_schema.table_io_waits_summary_by_index_usage

replication_group_member_stats

Collect metrics from performance_schema.replication_group_member_stats

tableiowaits

Collect metrics from performance_schema.table_io_waits_summary_by_table

tablelocks

Collect metrics from performance_schema.table_lock_waits_summary_by_table

slave_hosts

Scrape information from ‘SHOW SLAVE HOSTS’

slave_status

Collect from SHOW SLAVE STATUS

lock_wait_timeout

Set a lock_wait_timeout on the connection to avoid long metadata locking

log_format

Set the log target and format

log_level

Only log messages with the given severity or above. Valid levels: [debug, info, warn, error, fatal]

log_slow_filter

Add a log_slow_filter to avoid slow query logging of scrapes. NOTE: Not supported by Oracle MySQL

my_cnf

Path to .my.cnf file to read MySQL credentials from

mysql

address

MySQL address

password

MySQL password

port

MySQL port

Default
3306
protocol

MySQL protocol

Default
tcp
username

MySQL username

web

port

Port on which to expose web interface and telemetry

Default
"9104"
telemetry_path

Path under which to expose metrics

Templates

Templates are rendered and placed onto corresponding instances during the deployment process. This job's templates will be placed into /var/vcap/jobs/mysqld_exporter/ directory (learn more).

  • bin/mysqld_exporter_ctl (from bin/mysqld_exporter_ctl)

Packages

Packages are compiled and placed onto corresponding instances during the deployment process. Packages will be placed into /var/vcap/packages/ directory.