MySQL Server Configuration for High Performance

Опубликовано: 05 Октябрь 2024
на канале: High-Performance Programming

27,148

510

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