Parameter recommendations for Aurora MySQL 8
AWS/AWS RDS
Updated
•1 min read
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
