MySQL Uncovered: Internals, Trace Analysis, and Performance

Source: https://wangbin579.gumroad.com/l/mysql-internals

Take a step-by-step journey to understand how MySQL works from the inside out, starting with simple queries and progressing to advanced internal mechanisms.

🎓 About the Course

This is an intermediate-level course designed for developers and anyone curious about MySQL internals. You’ll start with basic SQL queries and gradually explore:

• B+ trees and index structures
• Buffer pool and caching
• Transactions, MVCC, and redo and undo logs
• Isolation levels, locking, and durability
• Execution plans, join strategies, and performance analysis
• In-depth MySQL planner internals
• Deep analysis of MySQL storage engines
• High availability mechanisms in MySQL
• Architectural comparisons between MySQL and PostgreSQL

You will learn not just what MySQL does, but why it was designed that way and how those design choices affect real-world performance and scalability. Most importantly, this course connects theory with practice, letting you use the trace tool to efficiently explore MySQL’s internal details.

📌 Note: To better understand MySQL internals, our tracing tool is the most effective approach for most people. If reading traces feels challenging at first, AI can act as an assistant and make the whole process much easier, as long as you stay aware of possible AI hallucinations.

It’s not my rip & it’s a text based course

Password: cms.ddpanda.org