Ao usar o AWS re:Post, você concorda com os AWS re:Post Termos de uso
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

Tópicos
AnáliseBanco de dados
Tags
Amazon AuroraMySQL
Idioma
English
AC
feita há 5 meses213 visualizações
1 Resposta
-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
ESPECIALISTA
Max Clements
respondido há 5 meses
profile picture
ESPECIALISTA
Gary Mclean
avaliado há 5 meses
  • AC
    há 5 meses

    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?

Você não está conectado. Fazer login para postar uma resposta.

Uma boa resposta responde claramente à pergunta, dá feedback construtivo e incentiva o crescimento profissional de quem perguntou.

Diretrizes para responder a perguntas

Conteúdo relevante