Parameter recommendations for Aurora MySQL 8

AWS/AWS RDS

  • outline

When you are using Aurora MySQL, you need to create custom parameter group for Aurora MySQL 8. Below is common recommendations for Aurora MySQL 8.

  • parameter

## for common use
performance_schema = 1
slow_query_log = 1
long_query_time = 10
log_output = TABLE
log_queries_not_using_indexes = 1
time_zone = UTC

## only for Aurora MySQL
aurora_parallel_query = 1
aurora_read_replica_read_committed = ON
innodb_flush_log_at_trx_commit=1
  • reference

https://docs.aws.amazon.com/prescriptive-guidance/latest/hyperscale-aurora-mysql/parameter-tuning.html https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/AuroraMySQL.BestPractices.html