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
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.