By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre:Post

AWS Aurora3 - MySQL upgrade

1

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

Topics
AnalyticsDatabase
Tags
Amazon AuroraMySQL
Language
English
AC
asked 4 months ago178 views
1 Answer
-2

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
EXPERT
Max Clements
answered 4 months ago
profile picture
EXPERT
Gary Mclean
reviewed 4 months ago
  • AC
    4 months ago

    I appreciate i can change it by wanted to check why it changed, when you look at the parameter group it states 'Engine Default' on both aurora 2 & 3 but doesn't match the mysql documentation. Is there a way of checking other parameters that don't match the engine default?

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions

Relevant content