Efficient MySQL Performance book cover

What is MySQL performance and how do you get it? Efficient MySQL Performance will teach you. Read it to gain 20 years of MySQL performance know-how—written for software engineers, not DBAs.

"Daniel does a great job of showing how to drive to the fastest resolution without getting lost in guesswork. He also covers InnoDB row locking in a detailed yet digestible form."
—Vadim Tkachenko, CTO, Percona

"This book is different from other MySQL books—it focuses on what matters most: query response time. A must-have for MySQL users!"
—Frédéric Descamps, MySQL Community Manager, Oracle Belgium

"Hands down [the] best technical book I've ever read, and I've been working in this field for close to 30 years."
—Adam (verified Amazon review)

More books about databases, MySQL, and SQL
Learning MySQL (2nd Edition) High Performance MySQL (4th Edition) Database Internals MySQL Troubleshooting MySQL Cookbook (4th Edition) SQL Antipatterns (Vol. 1) MySQL Concurrency: Locking and Transactions for MySQL Developers and DBAs

Group Commit and Transaction Dependency Tracking

Towards Multi-threaded Replication

MySQL 8.0 and newer change and improve how we measure and monitor replication lag. Even though multi-threaded replication (MTR) has been on by default for the last three years (since v8.0.27 released October 2021), the industry has been steeped in single-threaded replication for nearly 30 years. As a result, replication lag with MTR is a complicated topic because it depends on version, configuration, and more. This three-part series provides a detailed understanding, starting from what was originally an unrelated feature: binary log group commit.
Pulse icon
Blip
The most advanced MySQL metrics collector ever written
Albums icon
Spirit
The fastest online schema change tool for MySQL 8.x
Speedometer icon
Finch
The modern declarative MySQL benchmarking tool
Repeat icon
Skeema
The best way to manage MySQL table definitions
Wrench icon
Percona Toolkit
The famous MySQL tools that changed the world
Database icon
Percona Monitoring & Management
The open source database observability, monitoring, and management stack