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
Watch video MySQL Server Configuration for High Performance online without registration, duration hours minute second in high quality. This video was added by user High-Performance Programming 12 May 2021, don't forget to share it with your friends and acquaintances, it has been viewed on our site 27,14 once and liked it 51 people.