AWS Aurora3 - MySQL upgrade

Question

We are in the processing of upgrading from AWS Aurora 2 to Aurora 3 (mysql) and have noticed a performance degradation. We have narrowed it down to the following parameter which affects the stats generated for index usage: innodb_stats_persistent_sample_pages

The default value for mysql is 20, but this was changed in Aurora 2 to 128 (see following release notes)
https://docs.aws.amazon.com/AmazonRDS/latest/AuroraMySQLReleaseNotes/AuroraMySQL.Updates.2023.html

It seems in Aurora 3 it reverted back to the mysql default of 20 again, was this deliberatly? Is it documented anywhere any other parameters that might have changed?

thanks

Answer

`innodb_stats_persistent_sample_pages` is a modifiable instance level parameter for Aurora (2 and 3). You can use a parameter group to modify this yourself?

https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/parameter-groups-overview.html

Using a custom parameter group will leave you in control of this value - and not rely on the value specified in the default parameter group.

AWS Aurora3 - MySQL upgrade

관련 콘텐츠