In a previous post, I explained how you can collect and plot metrics using MySQL Shell.
This is a new series of article where I will explain how to read and understand some of the generated graphs.
Understanding your workload and seeing the evolution of it over time can help anticipating problems and work on solutions before the breakdown.
Let’s start the series with a concept that is not always well understood or at least not always considered at its true value: MySQL Checkpoint Age.
example of checkpoint age graphInnoDB Checkpointing
Before analyzing the graph, we need to understand what is MySQL InnoDB Checkpointing.
Each change to a data page in the InnoDB Buffer Pool are also written into the Write Ahead Logs.
In the literature they are sometimes called Transaction …[Read more]