How to Efficiently Delete Hundreds of Millions of Rows from a Large MySQL Table Without Indexes

When a 370 GB MySQL table containing 4.7 billion rows must purge about 2 billion records matching a specific xxid value but cannot add an index, a divide‑and‑conquer strategy using primary‑key ranges and a Python script for batch deletes offers a safe, space‑saving solution.

Batch DeletePythonlarge data deletion

0 likes · 8 min read

How to Efficiently Delete Hundreds of Millions of Rows from a Large MySQL Table Without Indexes