2/29/2024 0 Comments Mysqld exporter![]() Set a lock_wait_timeout on the connection to avoid long metadata locking. my.cnf file to read MySQL credentials from. Table from where to collect heartbeat data. (default: 86400)Ĭollect metrics from performance_schema.events_waits_summary_global_by_event_name.Ĭollect metrics from performance_schema.file_summary_by_event_name.Ĭollect metrics from performance_schema.file_summary_by_instance.Ĭollect metrics from performance_schema.table_io_waits_summary_by_index_usage.Ĭollect metrics from performance_schema.table_io_waits_summary_by_table.Ĭollect metrics from performance_schema.table_lock_waits_summary_by_table.Ĭollect from SHOW SLAVE STATUS (Enabled by default)ĭatabase from where to collect heartbeat data. Limit how old the 'last_seen' events statements can be, in seconds. Limit the number of events statements digests by response time. ![]() Maximum length of the normalized statement text. If running with userstat=1, set to true to collect user statistics.Ĭollect metrics from performance_schema.events_statements_summary_by_digest.Ĭollect.perf_text_limit If running with userstat=1, set to true to collect table statistics. The list of databases to collect table stats for, or ' *' for all. (default: 0)Ĭollect query response time distribution if query_response_time_stats is ON.Ĭollect metrics from information_schema.tables (Enabled by default) Minimum time a thread must be in each state to be counted. If running with userstat=1, set to true to collect client statistics.Ĭollect metrics from information_schema.innodb_metrics.Ĭollect metrics from information_schema.innodb_sys_tablespaces.Ĭollect thread state counts from information_schema.processlist. mysqld_exporter Ĭollect auto_increment columns and max values from information_schema.Ĭollect the current size of all registered binlog files.Ĭollect from SHOW GLOBAL STATUS (Enabled by default)Ĭollect from SHOW GLOBAL VARIABLES (Enabled by default) NOTE: Not all collection methods are supported on MySQL Prometheus exporter for MySQL server metrics.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |