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.

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.

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.

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.