> ## Documentation Index
> Fetch the complete documentation index at: https://docs.rapydo.io/llms.txt
> Use this file to discover all available pages before exploring further.

# Mysql

# Configure MySQL Settings

Configure the following in the DB Parameter Group and then restart the server for the settings to take effect.

## MySQL 8.0+

| Parameter                                | Value  | Description                                                                                                                                                                                                  |
| ---------------------------------------- | ------ | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ |
| `performance_schema`                     | `1`    | Required. Enables the Performance Schema.                                                                                                                                                                    |
| `max_digest_length`                      | `4096` | Required for collection of larger queries. Increases the size of SQL digest text in `events_statements_*` tables. If left at the default value, queries longer than `1024` characters will not be collected. |
| `performance_schema_max_digest_length`   | `4096` | Must match `max_digest_length`.                                                                                                                                                                              |
| `performance_schema_max_sql_text_length` | `4096` | Recommended to match `max_digest_length`. Controls the maximum length of full SQL text stored in `events_statements_*` tables.                                                                               |
| `slow_query_log`                         | `1`    | Required for capturing uncut long queries. Enables the slow query log to record queries that exceed the `long_query_time` threshold.                                                                         |
| `long_query_time`                        | `0`    | Recommended. Set to `0` to capture all queries regardless of execution time, or adjust to your preferred threshold in seconds.                                                                               |

## MySQL 5.7

| Parameter                                | Value  | Description                                                                                                                                                                                                  |
| ---------------------------------------- | ------ | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ |
| `performance_schema`                     | `1`    | Required. Enables the Performance Schema.                                                                                                                                                                    |
| `max_digest_length`                      | `4096` | Required for collection of larger queries. Increases the size of SQL digest text in `events_statements_*` tables. If left at the default value, queries longer than `1024` characters will not be collected. |
| `performance_schema_max_digest_length`   | `4096` | Must match `max_digest_length`.                                                                                                                                                                              |
| `performance_schema_max_sql_text_length` | `4096` | Recommended to match `max_digest_length`. Controls the maximum length of full SQL text stored in `events_statements_*` tables.                                                                               |
| `slow_query_log`                         | `1`    | Required for capturing uncut long queries. Enables the slow query log to record queries that exceed the `long_query_time` threshold.                                                                         |
| `long_query_time`                        | `0`    | Recommended. Set to `0` to capture all queries regardless of execution time, or adjust to your preferred threshold in seconds.                                                                               |

> **Note:** These parameters require MySQL 5.7.6 or later.

## MySQL 5.6

| Parameter            | Value | Description                                                                                                                          |
| -------------------- | ----- | ------------------------------------------------------------------------------------------------------------------------------------ |
| `performance_schema` | `1`   | Required. Enables the Performance Schema.                                                                                            |
| `slow_query_log`     | `1`   | Required for capturing uncut long queries. Enables the slow query log to record queries that exceed the `long_query_time` threshold. |
| `long_query_time`    | `0`   | Recommended. Set to `0` to capture all queries regardless of execution time, or adjust to your preferred threshold in seconds.       |

> **Note:** `max_digest_length`, `performance_schema_max_digest_length`, and `performance_schema_max_sql_text_length` are not available in MySQL 5.6.

## Important Notes for RDS Users

* The `slow_query_log` parameter is **dynamic in RDS** and does not require a server restart to take effect.
* Changes to `slow_query_log` and `long_query_time` can be applied immediately through the RDS console or CLI.
* All other parameters listed above require a server restart to take effect.