Skip to content
Tagged articles

JDBC Batching

1 articles · Page 1 of 1
Rain's Path to Java Mastery
Rain's Path to Java Mastery
Oct 25, 2026 · Databases

10B Rows into MySQL: From 231 Days to 3.5 Hours — The 6-Step Bulk Insert Playbook

This article details a six-step engineering playbook to bulk-insert 10 billion rows into MySQL, reducing time from 231 days to under 3.5 hours by combining sharding, true JDBC batching with rewriteBatchedStatements, LOAD DATA INFILE, temporary parameter tuning, parallel shard loading, idempotent checkpointing, and shadow-table swapping, while explaining B+ tree capacity math and common pitfalls.

B+ TreeBulk InsertIdempotency
0 likes · 42 min read
10B Rows into MySQL: From 231 Days to 3.5 Hours — The 6-Step Bulk Insert Playbook