Advanced
5 resources — audiences Advanced
High Performance MySQL, 3rd Edition
The classic guide to MySQL performance — covering query optimisation, schema design, indexing, replication, and high availability at scale.
High Performance MySQL, 4th Edition
The definitive guide to MySQL performance — covering query optimisation, indexing, replication, and scaling strategies.
MySQL 8 Query Performance Tuning
A systematic, step-by-step method for finding and fixing slow MySQL queries — from EXPLAIN and EXPLAIN ANALYZE through the Performance Schema and sys schema.
MySQL Reference Manual
Oracle's official, continuously updated documentation for MySQL Server — installation, SQL syntax, the InnoDB storage engine, replication, security, and every configuration option, covering all currently maintained MySQL versions.
Pro MySQL
An advanced, developer-focused tour of MySQL covering transaction processing, indexing theory, query optimization, stored procedures, replication, and MySQL's internal source architecture.