Understanding MySQL Communication Protocols, Parsing, Optimizer, Storage Engines, and Execution Engine
This article explains how MySQL establishes connections, the supported communication protocols and message formats, the lexical and syntactic parsing process, query optimization and execution plan generation, the role of different storage engines, and how the execution engine uses the plan to operate on the storage layer.