large transaction

Zhuanzhuan Tech

Mar 8, 2024 · Backend Development

Root Cause Analysis and Resolution of Data Inconsistency in Transactional MQ Processing

This article details a real‑world investigation of intermittent refund order failures caused by improper handling of transactions and message queues, explains the step‑by‑step debugging process, identifies large‑transaction timing issues, and presents a concrete fix that moves MQ sending until after transaction commit.

BackendConcurrencyMessage Queue

0 likes · 9 min read

Root Cause Analysis and Resolution of Data Inconsistency in Transactional MQ Processing

Aikesheng Open Source Community

Mar 5, 2024 · Databases

Locating Large Transactions in MySQL Binlog Using GTID and Shell Scripts

This article explains how to identify and extract large MySQL transactions from binary log files by monitoring binlog size, parsing GTID information, and using shell scripts to retrieve transaction details, timestamps, positions, and DML statistics, with optional use of the my2sql tool.

Database TroubleshootingGTIDMySQL

0 likes · 12 min read

Locating Large Transactions in MySQL Binlog Using GTID and Shell Scripts

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.

MySQLReplicationbinlog

0 likes · 7 min read

Analysis of Commit Blocking and SHOW MASTER STATUS Contention in MySQL 5.7 Replication

Aikesheng Open Source Community

Aug 26, 2019 · Databases

Controlling mysqldump Insert Batch Size with --net-buffer-length to Avoid Large Transactions

This article explains how mysqldump’s --net-buffer-length option can be used to split INSERT statements into manageable batches, defines large transactions, shows performance testing with different buffer sizes, and concludes that the default settings already avoid large transactions and provide acceptable import performance.

MySQLdatabase backuplarge transaction

0 likes · 8 min read

Controlling mysqldump Insert Batch Size with --net-buffer-length to Avoid Large Transactions

Aikesheng Open Source Community

Aug 22, 2019 · Databases

Analysis of Large Transaction Binlog Behavior in MySQL 5.6/5.7

This article analyzes why a large MySQL transaction can occupy an entire binlog file without triggering a binlog switch, why the final transaction appears small, and why the commit timestamps of the large and small transactions can differ by up to fifteen minutes, providing detailed explanations, test procedures, and code examples.

DatabaseGTIDMySQL

0 likes · 11 min read

Analysis of Large Transaction Binlog Behavior in MySQL 5.6/5.7