This course is your practical and structured immersion into the inner workings of MySQL, where you will step by step understand how the DBMS receives, optimizes, and executes queries. You will learn not only the concepts but also the real internal processes that define performance, stability, and scalability of MySQL in production systems.
What you will learn inside MySQL
The course "MySQL Uncovered: Internals, Trace Analysis, and Performance" reveals the key components of the engine and mechanisms that usually remain "behind the scenes." You will see what happens after a query is sent: how the optimizer works, what decisions it makes, how the storage subsystems interact, and what operations become bottlenecks.
Query execution architecture
- the steps of an SQL query passing through the parser, optimizer, and executor;
- the optimizer's work: plan selection, join enumeration, cost model;
- mechanisms like filesort, hash join, window functions, and CTE;
- why some JOINs are fast and others become bottlenecks.
Internals of storage engines
- structure of B+Tree indices and their impact on performance;
- buffer pool, page management, memory, and disk interaction;
- redo/undo logs, transactions, MVCC, isolation levels, locking;
- durability, crash recovery, and checkpoint mechanisms.
MySQL optimizer and its limitations
A separate module is dedicated to the work of the optimizer: how cardinality is evaluated, how operation costs are formed, and why the optimizer chooses a particular plan. You will understand the architectural compromises built into MySQL and how they reflect on the performance of real applications.
Practical focus: trace analysis and execution plans
Instead of "in a vacuum" theory, you will learn to work with real trace logs and execution plans. This approach allows you to see MySQL from the inside and accurately understand the reasons for the system's behavior. It is especially useful for diagnosing production problems and optimizing high-load queries.
Why trace analysis is one of the best ways to study MySQL
- reflects real processes, not abstract models;
- allows you to see how the optimizer makes decisions;
- reveals hidden sources of slow operations;
- combines well with modern AI tools for simplifying the analysis of complex fragments.
Additional important topics
The course also covers architectural features of MySQL, scaling, and comparison with alternative DBMSs.
- internal structure of storage engines and their differences;
- high-availability mechanisms and replication;
- features of MySQL Group Replication;
- scaling and typical architectural limitations of MySQL;
- what and why works differently in MySQL and PostgreSQL.
Who the course is for
The course is designed for specialists with an intermediate level of training: a basic understanding of SQL and experience with MySQL is sufficient. Complex topics are explained sequentially, with numerous practical examples and detailed breakdowns of internal mechanisms.
After completing the course, you will be able to
- analyze MySQL performance on a deep level;
- read and interpret execution plans;
- understand the causes of slow queries;
- design efficient indexes and data schemas;
- understand why the optimizer makes specific decisions;
- diagnose production problems and eliminate bottlenecks;
- consciously compare MySQL and PostgreSQL;
- deeply understand the architecture of modern relational DBMSs.
