How to update millions of records in MySQL?
Start Data Engineering
JANUARY 30, 2021
Introduction Setup Problems with a single large update Updating in batches Conclusion Further reading Introduction When updating a large number of records in an OLTP database, such as MySQL, you have to be mindful about locking the records. If those records are locked, they will not be editable(update or delete) by other transactions on your database.
Let's personalize your content