How WhatsApp Deletes Billions of Expired Statuses Daily Without Crashing Its Database

WhatsApp must delete billions of 24-hour Status updates every day, a task that poses serious risks to database performance at its massive scale. Running a single bulk delete query on billions of rows can cause slow queries, storage strain, replication delays, and even service outages. To avoid this, large systems use a technique called batch deletion, which breaks the cleanup work into small chunks — for example, deleting 10,000 rows at a time instead of hundreds of millions at once. This approach keeps individual transactions short, reduces lock contention, lowers memory pressure, and allows normal user activity like uploading or viewing Statuses to continue uninterrupted. The core principle is that the goal of data cleanup is not just deletion, but deletion that does not disrupt the rest of the live system.