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*

Asked by Evgeniy Berezovsky
(151 rep)
Nov 14, 2022, 08:26 AM
Last activity: Jul 9, 2025, 02:51 PM
Last activity: Jul 9, 2025, 02:51 PM