--- title: "mysqld_exporter_config | Grafana Agent documentation" description: "Learn about mysqld_exporter_config" --- # mysqld\_exporter\_config The `mysqld_exporter_config` block configures the `mysqld_exporter` integration, which is an embedded version of [`mysqld_exporter`](https://github.com/prometheus/mysqld_exporter) and allows for collection metrics from MySQL servers. Note that currently, an Agent can only collect metrics from a single MySQL server. If you want to collect metrics from multiple servers, run multiple Agents and add labels using `relabel_configs` to differentiate between the MySQL servers: YAML ![Copy code to clipboard](/media/images/icons/icon-copy-small-2.svg) Copy ```yaml mysqld_exporter: enabled: true data_source_name: root@(server-a:3306)/ relabel_configs: - source_labels: [__address__] target_label: instance replacement: server-a ``` We strongly recommend that you configure a separate user for the Agent, and give it only the strictly mandatory security privileges necessary for monitoring your node, as per the [official documentation](https://github.com/prometheus/mysqld_exporter#required-grants). Full reference of options: YAML ![Copy code to clipboard](/media/images/icons/icon-copy-small-2.svg) Copy ```yaml # Enables the mysqld_exporter integration, allowing the Agent to collect # metrics from a MySQL server. [enabled: | default = false] # Sets an explicit value for the instance label when the integration is # self-scraped. Overrides inferred values. # # The default value for this integration is a truncated version of the # connection DSN, containing only the server and db name. (Credentials # are not included.) [instance: ] # Automatically collect metrics from this integration. If disabled, # the mysqld_exporter integration will be run but not scraped and thus not # remote-written. Metrics for the integration will be exposed at # /integrations/mysqld_exporter/metrics and can be scraped by an external # process. [scrape_integration: | default = ] # How often should the metrics be collected? Defaults to # prometheus.global.scrape_interval. [scrape_interval: | default = ] # The timeout before considering the scrape a failure. Defaults to # prometheus.global.scrape_timeout. [scrape_timeout: | default = ] # Allows for relabeling labels on the target. relabel_configs: [- ... ] # Relabel metrics coming from the integration, allowing to drop series # from the integration that you don't care about. metric_relabel_configs: [ - ... ] # How frequent to truncate the WAL for this integration. [wal_truncate_frequency: | default = "60m"] # Data Source Name specifies the MySQL server to connect to. This is REQUIRED # but may also be specified by the MYSQLD_EXPORTER_DATA_SOURCE_NAME # environment variable. If neither are set, the integration will fail to # start. # # The format of this is specified here: https://github.com/go-sql-driver/mysql#dsn-data-source-name # # A working example value for a server with no required password # authentication is: "root@(localhost:3306)/" data_source_name: # A list of collector names to enable on top of the default set. enable_collectors: [ - ] # A list of collector names to disable from the default set. disable_collectors: [ - ] # A list of collectors to run. Fully overrides the default set. set_collectors: [ - ] # Set a lock_wait_timeout on the connection to avoid long metadata locking. [lock_wait_timeout: | default = 2] # Add a low_slow_filter to avoid slow query logging of scrapes. NOT supported # by Oracle MySQL. [log_slow_filter: | default = false] ## Collector-specific options # Minimum time a thread must be in each state to be counted. [info_schema_processlist_min_time: | default = 0] # Enable collecting the number of processes by user. [info_schema_processlist_processes_by_user: | default = true] # Enable collecting the number of processes by host. [info_schema_processlist_processes_by_host: | default = true] # The list of databases to collect table stats for. * for all [info_schema_tables_databases: | default = "*"] # Limit the number of events statements digests by response time. [perf_schema_eventsstatements_limit: | default = 250] # Limit how old the 'last_seen' events statements can be, in seconds. [perf_schema_eventsstatements_time_limit: | default = 86400] # Maximum length of the normalized statement text. [perf_schema_eventsstatements_digtext_text_limit: | default = 120] # Regex file_name filter for performance_schema.file_summary_by_instance [perf_schema_file_instances_filter: | default = ".*"] # Remove path prefix in performance_schema.file_summary_by_instance [perf_schema_file_instances_remove_prefix: | default = "/var/lib/mysql"] # Remove instrument prefix in performance_schema.memory_summary_global_by_event_name [perf_schema_memory_events_remove_prefix: | default = "memory/"] # Database from where to collect heartbeat data. [heartbeat_database: | default = "heartbeat"] # Table from where to collect heartbeat data. [heartbeat_table: | default = "heartbeat"] # Use UTC for timestamps of the current server (`pt-heartbeat` is called with `--utc`) [heartbeat_utc: | default = false] # Enable collecting user privileges from mysql.user [mysql_user_privileges: | default = false] ``` The full list of collectors that are supported for `mysqld_exporter` is: Expand table | Name | Description | Enabled by default | |-------------------------------------------------------|------------------------------------------------------------------------------------------------|--------------------| | auto\_increment.columns | Collect auto\_increment columns and max values from information\_schema | no | | binlog\_size | Collect the current size of all registered binlog files | no | | engine\_innodb\_status | Collect from SHOW ENGINE INNODB STATUS | no | | engine\_tokudb\_status | Collect from SHOW ENGINE TOKUDB STATUS | no | | global\_status | Collect from SHOW GLOBAL STATUS | yes | | global\_variables | Collect from SHOW GLOBAL VARIABLES | yes | | heartbeat | Collect from heartbeat | no | | info\_schema.clientstats | If running with userstat=1, enable to collect client statistics | no | | info\_schema.innodb\_cmpmem | Collect metrics from information\_schema.innodb\_cmpmem | yes | | info\_schema.innodb\_metrics | Collect metrics from information\_schema.innodb\_metrics | yes | | info\_schema.innodb\_tablespaces | Collect metrics from information\_schema.innodb\_sys\_tablespaces | no | | info\_schema.processlist | Collect current thread state counts from the information\_schema.processlist | no | | info\_schema.query\_response\_time | Collect query response time distribution if query\_response\_time\_stats is ON | yes | | info\_schema.replica\_host | Collect metrics from information\_schema.replica\_host\_status | no | | info\_schema.schemastats | If running with userstat=1, enable to collect schema statistics | no | | info\_schema.tables | Collect metrics from information\_schema.tables | no | | info\_schema.tablestats | If running with userstat=1, enable to collect table statistics | no | | info\_schema.userstats | If running with userstat=1, enable to collect user statistics | no | | mysql.user | Collect data from mysql.user | no | | perf\_schema.eventsstatements | Collect metrics from performance\_schema.events\_statements\_summary\_by\_digest | no | | perf\_schema.eventsstatementssum | Collect metrics of grand sums from performance\_schema.events\_statements\_summary\_by\_digest | no | | perf\_schema.eventswaits | Collect metrics from performance\_schema.events\_waits\_summary\_global\_by\_event\_name | no | | perf\_schema.file\_events | Collect metrics from performance\_schema.file\_summary\_by\_event\_name | no | | perf\_schema.file\_instances | Collect metrics from performance\_schema.file\_summary\_by\_instance | no | | perf\_schema.indexiowaits | Collect metrics from performance\_schema.table\_io\_waits\_summary\_by\_index\_usage | no | | perf\_schema.memory\_events | Collect metrics from performance\_schema.memory\_summary\_global\_by\_event\_name | no | | perf\_schema.replication\_applier\_status\_by\_worker | Collect metrics from performance\_schema.replication\_applier\_status\_by\_worker | no | | perf\_schema.replication\_group\_member\_stats | Collect metrics from performance\_schema.replication\_group\_member\_stats | no | | perf\_schema.replication\_group\_members | Collect metrics from performance\_schema.replication\_group\_members | no | | perf\_schema.tableiowaits | Collect metrics from performance\_schema.table\_io\_waits\_summary\_by\_table | no | | perf\_schema.tablelocks | Collect metrics from performance\_schema.table\_lock\_waits\_summary\_by\_table | no | | slave\_hosts | Scrape information from ‘SHOW SLAVE HOSTS’ | no | | slave\_status | Scrape information from SHOW SLAVE STATUS | yes |