BestHub
Sign in
Tagged articles
9 articles
Page 1 of 1
Aikesheng Open Source Community
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.

Large TransactionsPerformance 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
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.

Large TransactionsSQLbig tables
0 likes · 5 min read
Understanding Large Transactions, Risks, and Mitigation Strategies in Databases
Meituan Technology Team
Meituan Technology Team
Jul 6, 2023 · Databases

Meituan Database Fault Detection, Diagnosis, and Kernel Observability Practices

The article explains the design of Meituan’s MySQL autonomous platform, detailing its four‑layer architecture, statistical dynamic‑threshold anomaly detection, model selection based on time‑series distribution, kernel‑level root‑cause analysis for replication lag, large‑transaction diagnostics, and crash investigation using core‑dump and signal analysis.

Autonomous PlatformKernel DiagnosticsLarge Transactions
0 likes · 29 min read
Meituan Database Fault Detection, Diagnosis, and Kernel Observability Practices
Aikesheng Open Source Community
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.

Large TransactionsReplicationdatabase
0 likes · 10 min read
MySQL Replication Delay Analysis and Troubleshooting for Large Transactions
Aikesheng Open Source Community
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.

HeartbeatLarge TransactionsReplication
0 likes · 7 min read
Analyzing MySQL Replication Heartbeat Incompatibility Caused by Large Binlog Transactions
Su San Talks Tech
Su San Talks Tech
Nov 30, 2020 · Backend Development

How to Tame Large Transactions in Spring: 6 Proven Strategies

This article shares practical techniques for handling large transactions in Spring-based backend systems, covering why @Transactional can cause issues, how to use programmatic transactions, move queries outside transactions, avoid remote calls, limit data volume, execute non‑transactional operations, and leverage asynchronous processing.

Declarative TransactionLarge TransactionsProgrammatic Transaction
0 likes · 10 min read
How to Tame Large Transactions in Spring: 6 Proven Strategies