In this chapter, I tried to show you that, in optimization, the most important MySQL variables could have a better impact on performance. However, be aware that optimization is not an exact science but rather a step-by-step recipe with one change at a time, using monitoring and analysis.
Of course, no matter which version of MySQL you have, with 8.0 you will still have to monitor your database for performance and adjust it in line with your business's growth. Keep in mind that the two most important variables are InnoDB Buffer Pool and thread cache.
In the next chapter, we will look at how to configure high availability with MySQL global replication.
