mysqld_exporter -config.my-cnf="/home/mysql/mysqld_exporter_3308/mysqld_exporter_3308.cnf" -collect.binlog_size=true _schema.processlist=true -web.listen-address=:9106 -log.level=info > /home/mysql/mysqld_exporter_3308/mysqld_exporter. mysqld_exporter -config.my-cnf="/home/mysql/mysqld_exporter_3307/mysqld_exporter_3307.cnf" -collect.binlog_size=true _schema.processlist=true -web.listen-address=:9105 -log.level=info > /home/mysql/mysqld_exporter_3307/mysqld_exporter.log 2>&1 & mysqld_exporter -config.my-cnf="/home/mysql/mysqld_exporter_3306/mysqld_exporter_3306.cnf" -collect.binlog_size=true _schema.processlist=true -web.listen-address=:9104 -log.level=info > /home/mysql/mysqld_exporter_3306/mysqld_exporter.log 2>&1 & home/mysql/mysqld_exporter_3308/mysqld_exporter_3308.cnf home/mysql/mysqld_exporter_3307/mysqld_exporter_3307.cnf home/mysql/mysqld_exporter_3306/mysqld_exporter_3306.cnf Let’s download MySQLOverview dashboard which has a good overview of database performance. mysqld_exporter.cnf 파일 생성(3개의 디렉토리에 각각 생성) Create / Import Grafana Dashboard for MySQL Prometheus exporter If you don’t have all the golden time to create your own dashboards, you can use one created by Percona, they are Open source. ![]() (default info)Īdd a log_slow_filter to avoid exessive MySQL slow logging. Only log messages with the given severity or above. Example: logger:syslog?appname=bob&local=7 or logger:stdout?json=true. If set use a syslog logger or JSON logging. my.cnf file to read MySQL credentials from. Limit how old the 'last_seen' events statements can be, in seconds (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.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 (default true) Limit the number of events statements digests by response time (default 250) Maximum length of the normalized statement text (default 120) ![]() If running with userstat=1, set to true to collect user statisticsĬollect metrics from performance_schema.events_statements_summary_by_digest 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 "*") Minimum time a thread must be in each state to be countedĬollect query response time distribution if query_response_time_stats is ON.Ĭollect metrics from information_schema.tables (default true) 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 current thread state counts from the information_schema.processlist Collect auto_increment columns and max values from information_schemaĬollect the current size of all registered binlog filesĬollect from SHOW GLOBAL STATUS (default true)Ĭollect from SHOW GLOBAL VARIABLES (default true)
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |