MySQL in Practice, 45 Lectures (MySQL 实战 45 讲)
A popular Chinese-language column by Lin Xiaobin (Ding Qi) that explains InnoDB transactions, locking, indexes, redo log and binlog through 36 real-world MySQL problems.
The column has a foundations module on MySQL architecture, logging, transaction isolation, and locking, followed by a practice module that works through common production problems such as slow single-row queries and replication lag. It includes more than 100 hand-drawn diagrams.
The author, Lin Xiaobin, is a former head of databases at Tencent Cloud, led the Alibaba Cloud RDS kernel team, and helped open-source the AliSQL branch.
Community feedback
This space is for grounded, evaluable experience — versions used, environments, what you measured or observed, and how it behaves alongside other software. General impressions without supporting detail may be removed. Sign in to write one; posts are tied to a verified identity, not anonymous.