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. |
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. |
Note: These parameters require MySQL 5.7.6 or later.
MySQL 5.6
| Parameter | Value | Description |
|---|---|---|
performance_schema | 1 | Required. Enables the Performance Schema. |
Note:max_digest_length,performance_schema_max_digest_length, andperformance_schema_max_sql_text_lengthare not available in MySQL 5.6.