MySQL Server Configuration for High Performance

Get 60% OFF on the Complete Course - MySQL High-Performance Guide Course https://www.udemy.com/course/mysql-hi... In this section, we go through the general considerations of configuring a MySQL instance, and the options that most commonly need adjustments. First, we check how we should approach MySQL configuration changes by considering some best practices so that we can successfully tune MySQL. Then, we see which are the three options, that MySQL is most likely to benefit, from non-default values, and also how to set them. This includes settings for core components, such InnoDB buffer pool, and the Redo Logs. We discuss as well, parameters that are important for certain use-cases. For instance, buffer pool instances for high concurrent workloads, and how to make use of parallel execution for certain queries. 0:00 Introducere 0:26 MySQL Configuration Best Practices 4:44 InnoDB Overview 7:38 The Buffer Pool Size 11:26 The Buffer Pool Instances 14:38 Flushing Pages 17:24 Redo Log Buffer 19:15 Redo Log Files 22:16 Parallel Query Execution 23:44 Query Buffers 25:42 Conclusions