large transactions

Aikesheng Open Source Community

May 22, 2025 · Databases

Root Cause Analysis of MySQL Replication Lag Caused by Large Transactions in a Sharding Scenario

This article examines a real‑world MySQL master‑slave replication lag issue caused by massive multi‑table transactions during a sharding operation, details the investigative steps using system tables, binlog parsing, and my2sql analysis, and proposes three practical mitigation strategies.

MySQLPerformance OptimizationReplication Lag

0 likes · 8 min read

Root Cause Analysis of MySQL Replication Lag Caused by Large Transactions in a Sharding Scenario

Practical DevOps Architecture

Jun 4, 2024 · Databases

Understanding Large Transactions, Risks, and Mitigation Strategies in Databases

The article defines large database transactions, explains their performance and replication risks, offers practical guidelines to avoid them, demonstrates a MySQL example that creates and repeatedly inserts data to illustrate growing execution time, and discusses challenges and solutions for handling massive tables in high‑traffic environments.

MySQLSQLbig tables

0 likes · 5 min read

Understanding Large Transactions, Risks, and Mitigation Strategies in Databases

Aikesheng Open Source Community

Dec 26, 2022 · Databases

MySQL Replication Delay Analysis and Troubleshooting for Large Transactions

The article describes a MySQL 5.7.31 replication delay where Seconds_Behind_Master fluctuates between 0 and over 10,000 seconds, analyzes root causes such as single‑threaded replication, large or long‑running transactions, and provides preventive, diagnostic, and remediation steps including enabling parallel replication and using the infobin tool.

MySQLReplicationdatabase

0 likes · 10 min read

MySQL Replication Delay Analysis and Troubleshooting for Large Transactions

Aikesheng Open Source Community

Sep 1, 2021 · Databases

How to Split Large Transactions in TiDB: Guidelines, Limits, and Practical Scripts

The article explains why TiDB discourages large transactions, outlines the historical transaction limits, shows how to configure size thresholds, and provides concrete scripts for splitting big updates based on primary‑key characteristics to keep transaction size within safe bounds.

Database OptimizationSQLTiDB

0 likes · 8 min read

How to Split Large Transactions in TiDB: Guidelines, Limits, and Practical Scripts

Aikesheng Open Source Community

Dec 18, 2020 · Databases

Analyzing MySQL Replication Heartbeat Incompatibility Caused by Large Binlog Transactions

The article investigates why MySQL replication reports the error “heartbeat is not compatible with local info” when large transactions exceed the 4 GB limit of the binlog's next_position field, reproduces the issue with a controlled experiment, analyzes packet structures, and proposes practical mitigation strategies.

MySQLReplicationbinlog

0 likes · 7 min read

Analyzing MySQL Replication Heartbeat Incompatibility Caused by Large Binlog Transactions

Aikesheng Open Source Community

Jul 10, 2020 · Databases

Detecting Large Transactions in MySQL Binlog Using Linux Commands

This article explains how to identify and measure large MySQL transactions by extracting GTID events from binlog files using Linux command-line tools such as grep, awk, and sort, and demonstrates the process with example commands and visual results.

Database MonitoringLinux CommandsMySQL

0 likes · 3 min read

Detecting Large Transactions in MySQL Binlog Using Linux Commands

Aikesheng Open Source Community

Mar 19, 2020 · Databases

Analyzing High CPU Usage of lock_number_of_rows_locked in MySQL 5.6 Large Transactions

The article examines why a 100 GB MySQL 5.6 transaction causes high CPU usage during lock_number_of_rows_locked calculation, compares the lock‑counting implementations of MySQL 5.6 and 5.7, and offers diagnostic steps and version‑upgrade recommendations to mitigate the bottleneck.

CPU BottleneckInnoDBMySQL

0 likes · 9 min read

Analyzing High CPU Usage of lock_number_of_rows_locked in MySQL 5.6 Large Transactions