MySQL Server Settings

So far, in our previous chapters, you have learned how to use indexes and optimize complex queries. The optimization will not be complete if we do not examine the MySQL Server settings.

This chapter explains how to get optimal MySQL Server 8.0 settings.

Here are the topics covered in this chapter:

• Getting started with the most important variables
• MySQL server optimization
• The InnoDB Buffer Pool
• The thread cache
• Case study 1 – when MySQL uses more than 100% of a CPU
• Case study 2 – when MySQL swaps on disk

Let's get started!