We saw in the previous post that MySQL likes memory. We also saw how to perform operating system checks and some configuration changes for Swap and NUMA.
Today, we will check what MySQL server can tell us about its memory usage.
Introduced in MySQL 5.7 and enabled by default in MySQL 8.0, the
Performance_Schema‘s Memory instrumentation allows
us to have a better overview of what MySQL is allocating and why.
Let’s check on our MySQL server using
Pay attention that there is a bug
related to how InnoDB Buffer Pool statistics are accounted in
Performance_Schema. This is fixed in 8.0.13. …