Default settings can help you get started quickly – but they can
also cost you performance and a higher cloud bill at the end of
the month. Want to save money on your AWS RDS bill? I’ll show you
some MySQL settings to tune to get better performance, and cost
savings, with AWS RDS.
Recently I was engaged in a MySQL Performance Audit for a customer to help
troubleshoot performance issues that led to downtime during
periods of high traffic on their AWS RDS MySQL instances. During
heavy loads, they would see messages about their InnoDB settings
in the error logs:
[Note] InnoDB: page_cleaner: 1000ms intended loop took 4460ms. The settings might not be optimal. (flushed=140, during the time.)
This message is normally a side effect of a storage subsystem
that is not capable of keeping up with the number of writes
(e.g., IOPs) required by MySQL. This is …
[Read more]