Analysis of Replication Lag in a Database System
A business system recently experienced significant lag on its replica databases, failing to catch up with the primary database, posing considerable operational risks. Despite low CPU, IO, and network usage on the replica servers, indicating no resource bottlenecks, parallel replay was enibled. The SHOW PROCESSLIST command showed continuous repl ...
Posted on Wed, 02 Sep 2026 16:07:07 +0000 by slindstr
MySQL Query Cache Mechanism Analysis
Understanding MySQL Query Cache
MySQL Query Cache was a feature available in versions prior to 8.0 that stored the results of SELECT queries in memory. For small-scale applications where external caching solutions like Redis or Memcached aren't implemented, and where query results remain relatively stable, enabling query cache in MySQL 5.7 or e ...
Posted on Thu, 16 Jul 2026 16:36:06 +0000 by grissom