MySQL Architecture
Get 60% OFF on the Complete Course - MySQL High-Performance Guide Course
https://www.udemy.com/course/mysql-hi...
MySQL has a layered architecture, with query execution on top, and storage engines underneath.
The goal of this section was to understand how MySQL executes queries, so that we can write better ones, based on educated decisions.
Executing a query includes several steps, of which the optimizer, and execution steps, are the most important, and are ones that you will learn more about, in later sections.
0:00 MySQL Logical Architecture
2:22 MySQL Client/Server Protocol
3:59 The parser and the preprocessor
5:24 The Query Optimizer
8:15 The Query Execution Engine
8:45 Returning Results to the Client
