This article examines MySQL INSERT and UPDATE from the SQL command layer through table and metadata locking into InnoDB record locking, undo …

For many years, MySQL executed SQL queries using a deeply nested, monolithic executor loop. Functions like JOIN::exec() and evaluate_join_record() …

Grouping and aggregation are cornerstones of relational databases. In MySQL, executing a GROUP BY statement involves a sophisticated dance between the …

This article introduces the internal architecture and implementation details of MySQL’s default storage engine, InnoDB, exploring its memory …

This article introduces Mysql Metadata

This article provides an in-depth dive into MySQL query processing internals, tracing the lifecycle of a query from the network connection to parsing, …