Skip to content
Tagged articles

LOAD DATA INFILE

2 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
ITPUB
ITPUB
Sep 29, 2021 · Databases

INSERT vs LOAD DATA INFILE in MySQL: When to Choose Each for Speed and Bulk Loads

This article compares MySQL's INSERT INTO and LOAD DATA INFILE statements, explains their syntax, shows practical examples, highlights when each should be used for bulk data loading, discusses error handling with IGNORE, and explains why LOAD DATA INFILE is typically faster.

INSERTLOAD DATA INFILEMySQL
0 likes · 7 min read
INSERT vs LOAD DATA INFILE in MySQL: When to Choose Each for Speed and Bulk Loads