Programmer DD

Jul 5, 2019 · Databases

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.