Durch die Nutzung von AWS re:Post stimmt du den AWS re:Post Nutzungsbedingungen
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

Themen
AnalysenDatenbank
Tags
Amazon AuroraMySQL
Sprache
English
AC
gefragt vor 5 Monaten213 Aufrufe
1 Antwort
-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
EXPERTE
Max Clements
beantwortet vor 5 Monaten
profile picture
EXPERTE
Gary Mclean
überprüft vor 5 Monaten
  • AC
    vor 5 Monaten

    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?

Du bist nicht angemeldet. Anmelden um eine Antwort zu veröffentlichen.

Eine gute Antwort beantwortet die Frage klar, gibt konstruktives Feedback und fördert die berufliche Weiterentwicklung des Fragenstellers.

Richtlinien für die Beantwortung von Fragen

Relevanter Inhalt