Skip to content

mysqld_exporter job from prometheus/12.2.0

Github source: c2a87ca6 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

info_schema
clientstats

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

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

indexiowaits

Collect metrics from performance_schema.table_io_waits_summary_by_index_usage

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_status

Collect from SHOW SLAVE STATUS

log_format

If set use a syslog logger or JSON logging

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 exessive MySQL slow logging

my_cnf

Path to .my.cnf file to read MySQL credentials from (default ‘/root/.my.cnf’)

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.