Skip to content- Sources: primary
- Summary: Materialize rewrote MySQL initial snapshotting to split a table across workers by ranges of the clustered primary key. Offset walking failed once the data outgrew the InnoDB buffer pool, so the team switched to sargable prefix queries and EXPLAIN row estimates, and limited support to collations without contractions or expansions. Internal scale tests showed 2.2x to 6.9x speedups, and the customer reported about 10x.
- Why it matters: The post shows which MySQL range queries stay index-driven, why NOT LIKE and OFFSET force scans at scale, and how unreliable EXPLAIN estimates and collations break naive key partitioning.