---
title: "prometheus.exporter.mysql | Grafana Alloy documentation"
description: "Learn about prometheus.exporter.mysql"
---

# `prometheus.exporter.mysql`

The `prometheus.exporter.mysql` component embeds the [`mysqld_exporter`](https://github.com/prometheus/mysqld_exporter) for collecting stats from a MySQL server.

## Usage

Alloy ![Copy code to clipboard](/media/images/icons/icon-copy-small-2.svg) Copy

```alloy
prometheus.exporter.mysql "<LABEL>" {
    data_source_name = "<DATA_SOURCE_NAME>"
}
```

## Arguments

You can use the following arguments with `prometheus.exporter.mysql`:

Expand table

| Name                       | Type           | Description                                                                                                         | Default | Required |
|----------------------------|----------------|---------------------------------------------------------------------------------------------------------------------|---------|----------|
| `data_source_name`         | `secret`       | [Data Source Name](https://github.com/go-sql-driver/mysql#dsn-data-source-name) for the MySQL server to connect to. |         | yes      |
| `disable_collectors`       | `list(string)` | A list of [collectors](#supported-collectors) to disable from the default set.                                      |         | no       |
| `enable_collectors`        | `list(string)` | A list of [collectors](#supported-collectors) to enable on top of the default set.                                  |         | no       |
| `enable_lock_wait_timeout` | `bool`         | Whether to enable the `lock_wait_timeout` parameter.                                                                | `true`  | no       |
| `lock_wait_timeout`        | `int`          | Timeout, in seconds, to acquire a metadata lock.                                                                    | `2`     | no       |
| `log_slow_filter`          | `bool`         | Used to avoid queries from scrapes being logged in the slow query log.                                              | `false` | no       |
| `set_collectors`           | `list(string)` | A list of [collectors](#supported-collectors) to run. Fully overrides the default set.                              |         | no       |

Set a `lock_wait_timeout` on the connection to avoid potentially long wait times for metadata locks. For more information, refer to the `lock_wait_timeout` [in the MySQL documentation](https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_lock_wait_timeout).

> Note
> 
> `log_slow_filter` isn’t supported by Oracle MySQL.

## Blocks

You can use the following blocks with `prometheus.exporter.mysql`:

No valid configuration blocks found.

### `heartbeat`

Expand table

| Name       | Type     | Description                                                                          | Default       | Required |
|------------|----------|--------------------------------------------------------------------------------------|---------------|----------|
| `database` | `string` | Database to collect heartbeat data from.                                             | `"heartbeat"` | no       |
| `table`    | `string` | Table to collect heartbeat data from.                                                | `"heartbeat"` | no       |
| `utc`      | `bool`   | Use UTC for timestamps of the current server. `pt-heartbeat` is called with `--utc`. | `false`       | no       |

### `info_schema.processlist`

Expand table

| Name                | Type   | Description                                                | Default | Required |
|---------------------|--------|------------------------------------------------------------|---------|----------|
| `min_time`          | `int`  | Minimum time a thread must be in each state to be counted. | `0`     | no       |
| `processes_by_host` | `bool` | Enable collecting the number of processes by host.         | `true`  | no       |
| `processes_by_user` | `bool` | Enable collecting the number of processes by user.         | `true`  | no       |

### `info_schema.tables`

Expand table

| Name        | Type     | Description                                                         | Default | Required |
|-------------|----------|---------------------------------------------------------------------|---------|----------|
| `databases` | `string` | The list of databases to collect table stats for, or `"*"` for all. | `"*"`   | no       |

### `mysql.user`

Expand table

| Name         | Type   | Description                                          | Default | Required |
|--------------|--------|------------------------------------------------------|---------|----------|
| `privileges` | `bool` | Enable collecting user privileges from `mysql.user`. | `false` | no       |

### `perf_schema.eventsstatements`

Expand table

| Name              | Type           | Description                                                                        | Default | Required |
|-------------------|----------------|------------------------------------------------------------------------------------|---------|----------|
| `exclude_schemas` | `list(string)` | List of schemas to exclude from events statements collection.                      |         | no       |
| `limit`           | `int`          | Limit the number of events statements digests, in descending order by `last_seen`. | `250`   | no       |
| `text_limit`      | `int`          | Maximum length of the normalized statement text.                                   | `120`   | no       |
| `time_limit`      | `int`          | Limit how old, in seconds, the `last_seen` events statements can be.               | `86400` | no       |

### `perf_schema.file_instances`

Expand table

| Name            | Type     | Description                                                                         | Default            | Required |
|-----------------|----------|-------------------------------------------------------------------------------------|--------------------|----------|
| `filter`        | `string` | Regular expression to select rows in `performance_schema.file_summary_by_instance`. | `".*"`             | no       |
| `remove_prefix` | `string` | Prefix to trim away from `file_name`.                                               | `"/var/lib/mysql"` | no       |

Refer to the [MySQL documentation](https://dev.mysql.com/doc/mysql-perfschema-excerpt/8.0/en/performance-schema-file-summary-tables.html) for more detailed information about the tables used in `perf_schema_file_instances_filter` and `perf_schema_file_instances_remove_prefix`.

### `perf_schema.memory_events`

Expand table

| Name            | Type     | Description                                                                        | Default     | Required |
|-----------------|----------|------------------------------------------------------------------------------------|-------------|----------|
| `remove_prefix` | `string` | Prefix to trim away from `performance_schema.memory_summary_global_by_event_name`. | `"memory/"` | no       |

### Supported Collectors

The full list of supported collectors is:

Expand table

| Name                                               | Description                                                                                  | Enabled by default |
|----------------------------------------------------|----------------------------------------------------------------------------------------------|--------------------|
| `global_status`                                    | Collect metrics from `SHOW GLOBAL STATUS`.                                                   | yes                |
| `global_variables`                                 | Collect metrics from `SHOW GLOBAL VARIABLES`.                                                | yes                |
| `info_schema.innodb_cmp`                           | Collect metrics from `information_schema.innodb_cmp`.                                        | yes                |
| `info_schema.innodb_cmpmem`                        | Collect metrics from `information_schema.innodb_cmpmem`.                                     | yes                |
| `info_schema.query_response_time`                  | Collect query response time distribution if `query_response_time_stats` is ON.               | yes                |
| `slave_status`                                     | Scrape information from `SHOW SLAVE STATUS`.                                                 | yes                |
| `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 metrics from `SHOW ENGINE INNODB STATUS`.                                            | no                 |
| `engine_tokudb_status`                             | Collect metrics from `SHOW ENGINE TOKUDB STATUS`.                                            | no                 |
| `heartbeat`                                        | Collect metrics from heartbeat database and tables.                                          | no                 |
| `info_schema.clientstats`                          | If running with userstat=1, enable to collect client statistics.                             | no                 |
| `info_schema.innodb_metrics`                       | Collect metrics from `information_schema.innodb_metrics`.                                    | no                 |
| `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.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                 |
| `sys.user_summary`                                 | Collect per-user metrics from `sys.x$user_summary`.                                          | no                 |

## Exported fields

The following fields are exported and can be referenced by other components.

Expand table

| Name      | Type                | Description                                               |
|-----------|---------------------|-----------------------------------------------------------|
| `targets` | `list(map(string))` | The targets that can be used to collect exporter metrics. |

For example, the `targets` can either be passed to a `discovery.relabel` component to rewrite the targets’ label sets or to a `prometheus.scrape` component that collects the exposed metrics.

The exported targets use the configured [in-memory traffic](../../../../get-started/component_controller/#in-memory-traffic) address specified by the [run command](../../../cli/run/).

## Component health

`prometheus.exporter.mysql` is only reported as unhealthy if given an invalid configuration. In those cases, exported fields retain their last healthy values.

## Debug information

`prometheus.exporter.mysql` doesn’t expose any component-specific debug information.

## Debug metrics

`prometheus.exporter.mysql` doesn’t expose any component-specific debug metrics.

## Example

The following example uses a [`prometheus.scrape` component](../prometheus.scrape/) to collect metrics from `prometheus.exporter.mysql`:

Alloy ![Copy code to clipboard](/media/images/icons/icon-copy-small-2.svg) Copy

```alloy
prometheus.exporter.mysql "example" {
  data_source_name  = "root@(server-a:3306)/"
  enable_collectors = ["heartbeat", "mysql.user"]
}

// Configure a prometheus.scrape component to collect mysql metrics.
prometheus.scrape "demo" {
  targets    = prometheus.exporter.mysql.example.targets
  forward_to = [prometheus.remote_write.demo.receiver]
}

prometheus.remote_write "demo" {
  endpoint {
    url = "<PROMETHEUS_REMOTE_WRITE_URL>"

    basic_auth {
      username = "<USERNAME>"
      password = "<PASSWORD>"
    }
  }
}
```

Replace the following:

- *`<PROMETHEUS_REMOTE_WRITE_URL>`* : The URL of the Prometheus `remote_write` compatible server to send metrics to.
- *`<USERNAME>`* : The username to use for authentication to the `remote_write` API.
- *`<PASSWORD>`* : The password to use for authentication to the `remote_write` API.

## Compatible components

`prometheus.exporter.mysql` has exports that can be consumed by the following components:

- Components that consume [Targets](../../../compatibility/#targets-consumers)

> Note
> 
> Connecting some components may not be sensible or components may require further configuration to make the connection work correctly. Refer to the linked documentation for more details.