Basic
Basic concept, DDL, DML, DCL, TCL, Database, Table, Procedure
- Sams teach yourself SQL in 10 minutes,4th edition by Ben Forta (SQL 必知必会)
- Database System Concepts
- MySQL 是怎么样运行的：从根上儿理解 MySQL
Advance
Priciples, Sources Optimization。优化（sql/参数/架构/硬件层面）、高可用方案（海量数据/高并发）、备份与恢复、集群、复制技术，运维和应用
- MySQL Internals Manual - documentation
- Expert MySQL by Charles A Bell (深入理解MySQL)
- Understanding MySQL Internals by Sasha Pachev (深入理解MySQL核心技术)
- Effective MySQL Optimizing SQL Statements
- Effective MySQL Backup and Recovery
- Effective MySQL Replication Techniques in Depth
- MySQL Troubleshooting: What To Do When Queries Don't Work by Sevta Smirnova (MySQL排错指南)
Principle
- mysql技术内幕：innodb存储引擎 by 姜承尧
- MySQL内核：InnoDB存储引擎 by 姜承尧
- MariaDB原理与实现 by 张金鹏
Optimization
- High Performance MySQL by Baron Schwartz
- MySQL High Availability: Tools for Building Robust Data Centers by Charles Bell
- MySQL性能调优与架构设计 by 简朝阳
- Relational Database Index Design and the Optimizers by Tapio Lahdenmaki (数据库索引设计与优化)