MySQL Server Configuration for High Performance
Автор: High-Performance Programming
Загружено: 2021-05-12
Просмотров: 31132
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
Доступные форматы для скачивания:
Скачать видео mp4
-
Информация по загрузке:
