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

MySQL Concurrency: Locking and Transactions for MySQL Developers and DBAs

Group Commit and Transaction Dependency Tracking

Towards Multi-threaded Replication

Oct 20, 2024

Oct 26, 2024

#mysql #replication #group-commit #logical-clock #writeset

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.

More blogs from MySQL experts

Frédéric "lefred" Descamps

Jean-François "J-F" Gagné

Mark Callaghan

Planet MySQL Oracle (aggregator)

Planet MariaDB Server (aggregator)

Planet MySQL Community (aggregator)

Percona

Percona Community

PlanetScale