mysqld_exporter job from prometheus/26.7.0
Github source:
2be8ef7 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
protocol¶MySQL protocol
- Default
username¶MySQL username
web¶
port¶Port on which to expose web interface and telemetry
- Default
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(frombin/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.