Performance
7 resources — topics Performance
Efficient MySQL Performance
Efficient MySQL Performance distills 20 years of MySQL expertise into 344 pages. Written for software developers, not DBAs, it's easy to digest even if you're new to MySQL.
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 Concurrency
A guide to locking and transactions in MySQL — row and gap locks, metadata locks, isolation levels, and how to diagnose lock contention and deadlocks with the Performance and Information Schemas.
Percona Database Performance Blog
Percona's company blog — practical, technical articles on MySQL, MariaDB, PostgreSQL, and MongoDB performance, tuning, troubleshooting, and operations, written mainly by Percona's own engineers.
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.