Advanced MySQL 8

Case study 2 – when MySQL swaps on disk

What does disk swapping mean?

We can define a disk swap as the system moving data from memory to a special area on the disk called the swap space. The process is called an exchange or swap, depending on the direction in which it occurs.

The system halts when it makes the decision to free physical memory (RAM) and retrieve data from disk. It interfaces when an application needs to access the data that has been exchanged.

I believe you'll have guessed by now that the swapping between memory and disk will have a negative impact on the performance of MySQL.

The most important step to prevent disk swaps is to make sure that the MySQL database, and not any other application, uses all available memory. Generally, ...