Sample Header Ad - 728x90

How to performance tune high /wait/io/redo_log_flush values in "commit"

3 votes
2 answers
3820 views
According to the "Top SQL" view in *AWS Performance Insights*, commit tops the list of SQL statements in terms of *average active session (AAS)*. And most of the time seems to be spent in wait/io/redo_log_flush. I have read the [docs on io/aurora_redo_log_flush](https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/ams-waits.io-auredologflush.html) - which I assume to be the name of wait/io/redo_log_flush prior to Aurora 3 - but they don't really help me, because there are apparently only 0.25 commits per second, but the load is close to 15 AAS. So it is not a problem of too many small commits. So why would such a low commit rate lead to such a high AAS? How can I dig deeper into this? N.B. We are using *8.0.mysql_aurora.3.02.1* enter image description here
Asked by Evgeniy Berezovsky (151 rep)
Nov 14, 2022, 08:26 AM
Last activity: Jul 9, 2025, 02:51 PM