Tagged articles
LAG
20 articles · Page 1 of 1
This article explains ten advanced SQL concepts — including CTEs, recursive CTEs, temporary functions, pivoting with CASE WHEN, EXCEPT vs NOT IN, self joins, ranking functions, delta calculations with LAG/LEAD, running totals, and datetime manipulation — with practical code examples for data science interview preparation.
CTEDateTime ManipulationLAG
0 likes · 11 min read

This guide provides a structured 10-minute triage process for sudden MySQL replication lag, covering IO/SQL thread diagnosis, GTID gap analysis, source write-rate checks, replica resource contention, and safe mitigation actions with ready-to-run evidence-collection scripts.
GTIDLAGMySQL
0 likes · 41 min read

A comprehensive guide to diagnosing and resolving MySQL master-slave replication delay, covering root causes like large transactions, parallel replication misconfiguration, hardware bottlenecks, lock contention, missing indexes, network issues, and semi-sync replication, with practical tools, monitoring setup, and real-world case studies.
GTIDLAGMySQL
0 likes · 88 min read

This guide provides a systematic methodology to diagnose and resolve MySQL replication lag spikes, covering evidence collection, replication status analysis, parallel replication tuning, large transaction mitigation, topology isolation, safe configuration changes, replica rebuild procedures, and proactive monitoring setup.
GTIDLAGMySQL
0 likes · 43 min read

This guide walks through why MySQL master‑slave replication lag occurs, the key metrics to monitor, a step‑by‑step troubleshooting flow, ten typical root causes, concrete remediation actions, verification methods, rollback plans, and production‑grade best practices for keeping replication latency near zero.
DiskIOLAGMySQL
0 likes · 29 min read

This guide walks through a complete MySQL master‑slave lag diagnosis process, explaining why relying solely on Seconds_Behind_Master is insufficient and showing how to separate IO and SQL thread issues, examine relay logs, detect long transactions, DDL locks, and apply best‑practice configurations and monitoring.
LAGMySQLReplication
0 likes · 17 min read

This comprehensive guide explains why MySQL master‑slave replication can fall behind, walks through systematic diagnosis of common lag scenarios, and provides concrete configuration tweaks, parallel replication settings, GTID usage, monitoring queries, and upgrade paths to eliminate delay and improve reliability.
GTIDLAGMySQL
0 likes · 34 min read

The article explains MySQL master‑slave replication fundamentals, shows how to monitor replication status, enumerates common delay causes such as network latency, master write pressure, SQL thread bottlenecks, large transactions, missing primary keys, slave overload, replication conflicts and GTID quirks, and provides scripts, configuration tips, and real‑world case studies for troubleshooting and prevention.
ConfigurationLAGMySQL
0 likes · 28 min read

This guide explains why MySQL replication lag spikes, how to distinguish IO‑thread pull problems from SQL‑thread apply bottlenecks, provides step‑by‑step commands, configuration examples, real‑world case studies, best‑practice recommendations, and monitoring setups to reliably troubleshoot and prevent replication delays.
LAGMySQLReplication
0 likes · 16 min read

When MySQL replication falls behind, common culprits include oversized buffer pools, backup‑induced MDL waits, large transactions, slow queries, parallel replication quirks, and network issues, and this guide offers concrete configuration adjustments to restore sync and improve performance.
LAGMySQLReplication
0 likes · 6 min read

This article explains why MySQL master‑slave replication can fall behind, outlines common causes of data inconsistency, and presents four comprehensive solutions—including architecture tweaks, multi‑threaded replication, configuration tuning, and Percona Toolkit verification—to achieve fast, stable, and accurate data synchronization.
ConsistencyDatabase PerformanceLAG
0 likes · 9 min read

This article explains the fundamentals of MySQL master‑slave replication, identifies why replication lag occurs—including single‑threaded processing, lock contention, network issues, and outdated versions—and offers concrete strategies such as hardware upgrades, configuration tweaks, and architectural changes to minimize the delay.
LAGMySQLdatabases
0 likes · 7 min read


ITPUBNov 10, 2023 · Databases
This article explains what MySQL master‑slave replication lag is, walks through the replication workflow, identifies the main technical reasons for delay such as single‑threaded replay and lock contention, and provides concrete configuration and architectural solutions to reduce or eliminate the lag.
LAGMySQLdatabases
0 likes · 8 min read


LouZaiOct 30, 2023 · Databases
The article explains what MySQL master‑slave replication lag is, analyzes why it occurs—especially during relay‑log replay and large DDL/DML operations—and provides concrete configuration, hardware, and architectural solutions to reduce or eliminate the delay.
ConfigurationLAGMaster‑Slave
0 likes · 8 min read


ITPUBJul 1, 2023 · Databases
This article explains MySQL master‑slave architecture, why it’s used, the replication process, consistency challenges, causes of replication lag, and practical strategies—including binlog formats, mixed mode, monitoring, caching, and failover setups—to optimize performance and ensure high availability.
High AvailabilityLAGMaster‑Slave
0 likes · 11 min read


ITPUBOct 23, 2022 · Databases
After a write to the MySQL master, reads from a slave can return old or missing data due to replication lag, and this article explains the underlying asynchronous replication mechanisms, the involved threads, and presents practical solutions such as forcing master reads, delay detection, semi‑sync mode, GTID waiting, and middleware implementations like Sharding‑JDBC, MyCat, and MaxScale.
GTIDLAGMySQL
0 likes · 11 min read

This article examines a real‑world MySQL master‑slave replication delay case, analyzes the root causes using slave status, InnoDB metrics, OS‑level I/O and error logs, and provides concrete configuration and operational recommendations to reduce lag.
LAGMySQLtuning
0 likes · 16 min read

This article explains the root causes of MySQL master‑slave replication lag—including random replay, high master concurrency, and lock waits—and presents practical solutions such as parallel replication, reducing master load, and reading from the master to ensure data consistency.
LAGMaster‑SlaveMySQL
0 likes · 8 min read

This article walks through a real‑world case of MySQL 5.7 replication delay after switching to TokuDB, presenting a step‑by‑step methodology that examines network, hardware, large transactions, locks, configuration parameters, and multi‑threaded replication to identify and resolve the root cause.
DBALAGMySQL
0 likes · 12 min read

This article explains why iOS apps experience lag due to main‑thread blocking, demonstrates the problem with sample code, and provides practical solutions using GCD and monitoring tools like Bugly to keep the UI responsive and improve user satisfaction.
BuglyGCDLAG
0 likes · 6 min read
