Why MySQL Locks and Transaction Isolation Cause Data Loss in Concurrent Syncs
A detailed investigation reveals that MySQL's lock matrix and MVCC‑based transaction isolation caused a concurrent synchronization job to lose metric and dimension data, and proposes a distributed‑lock solution together with a long‑term read‑calc‑write refactor to eliminate the issue.
