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.
Databases & MySQL
Query plans, transactions and reliable change-data capture.
Indexes / MVCC / CDC.
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.