Articles written in English. You can also subscribe via the English feed.

• MySQL Online DDL "Duplicate Key" Optimization
  2026-10-13
  Why MySQL Online DDL sometimes fails with a Duplicate Entry error, how the row log and MVCC produce it, and how AliSQL eliminates it by safely ignoring the false duplicates.
• How Atomic DDL Works in MySQL 8.0
  2026-09-22
  A deep dive into MySQL 8.0's Atomic DDL — the unified Data Dictionary, how the InnoDB DDL log serves as redo or undo to make DDL atomic, and the binlog DDL crash-safety and CREATE TABLE ... SELECT improvements.
• Recovery Optimization for Large MySQL Transactions
  2026-08-04
  Binlog Recovery must roll back prepared large transactions before the server can serve users; AliSQL's asynchronous rollback cuts startup from hours to seconds.
• Optimizing Replication Lag for Large Transactions and DDL in MySQL
  2026-07-17
  AliSQL's Binlog Realtime Replication executes on primary and replica in parallel, eliminating lag from large transactions and DDL.
• Binlog Transmission Optimization for Large MySQL Transactions
  2026-07-16
  Why large transactions stall semisync replication, and how AliSQL's realtime transmission fixes it without degrading to async.
• Commit Optimization for Large MySQL Transactions
  2026-07-15
  Eliminates the copy overhead at commit by renaming the binlog cache file straight into a binlog file.
• Diagnosing MySQL Memory Problems with Jemalloc
  2026-04-08
  Using Jemalloc's sampling profiler to locate MySQL memory leaks and study its memory usage — two real cases, how to enable it, how to take snapshots via gdb or a UDF, and how to generate call graphs.