Databases & MySQL
MySQL Index Design: Reading EXPLAIN Through a Slow Query
Connect query shape, composite indexes, actual scan volume, and write costs through a practical event-log query.
MySQL
Databases & MySQL
MySQL Concurrency: MVCC, Lock Waits, and Deadlocks in One Example
Use two sessions to understand snapshot reads and conflicting updates, inspect deadlocks, and design retries at the transaction boundary.
Databases & MySQL
Consistency Boundaries in MySQL CDC: Snapshots, Offsets, and Idempotency
Trace duplicates, reordering, deletes, and replay from MySQL through Debezium and Kafka to downstream state.
Earlier notes · 2023
MySQL Study Notes: Locks, Lock Ranges, and Deadlocks
An English reading edition of the 2023 notes on global, table, metadata, intention, auto-increment, and row locks, with practical inspection and recovery guidance.
Earlier notes · 2023
MySQL Study Notes: Transactions, Logging, and MVCC
An English reading edition of the 2023 notes, covering isolation, undo and redo, binary logs, commit coordination, replication, and buffer-pool behavior.