![](https://www.bram.us/wordpress/wp-content/uploads/2021/01/mysql-1568x968.jpg)
Interesting post over at the Flare blog, where they had to delete over 900 million records from a MySQL table. They couldn’t simply run a DELETE FROM table query, as that would lock it: When a deletion query using a WHERE clause starts, it will lock that table. All other queries that are run against …
Continue reading “How to delete lots of rows from a MySQL database without indefinite locking”