Used to be that replication lag was as simple as Seconds_Behind_Master (renamed to Seconds_Behind_Source).
But with multi-threaded replication (MTR) this is no longer the case.
It’s time to relearn replication lag monitoring using Performance Schema tables.
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
Monitoring Multi-threaded Replication Lag With Performance Schema
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