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)
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.
Blip
The most advanced MySQL metrics collector ever written
The most advanced MySQL metrics collector ever written
Spirit
The fastest online schema change tool for MySQL 8.x
The fastest online schema change tool for MySQL 8.x
Finch
The modern declarative MySQL benchmarking tool
The modern declarative MySQL benchmarking tool
Skeema
The best way to manage MySQL table definitions
The best way to manage MySQL table definitions
Percona Toolkit
The famous MySQL tools that changed the world
The famous MySQL tools that changed the world
Percona Monitoring & Management
The open source database observability, monitoring, and management stack
The open source database observability, monitoring, and management stack