Aikesheng Open Source Community
Jul 18, 2022 · Databases
Analysis of Commit Blocking and SHOW MASTER STATUS Contention in MySQL 5.7 Replication
The article examines how a large transaction in MySQL 5.7 can block the SHOW MASTER STATUS command by holding the lock_log during the commit's flush stage, analyzes the commit and SHOW MASTER STATUS code paths, and proposes mitigation strategies such as avoiding big transactions and using SELECT @@global.gtid_executed.
BinlogMySQLPerformance
0 likes · 7 min read