MySQL Forums
Forum List  »  MySQL Workbench

Re: Faster/more reliable way to delete millions of rows?
Posted by: Alex Duke
Date: June 17, 2017 09:42AM

Appreciate the response! I had kinda looked through that page before, but what I ended up doing ultimately, was increasing the innodb_buffer_pool_size to around 2GB (I have 8GB RAM), or '2155872256'as the value. The query that had taken multiple 24 hour attempts only to fail every time and have to start over, ultimately took ~6700 seconds to complete. Hopefully someone else finds this useful!

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Faster/more reliable way to delete millions of rows?
137
June 17, 2017 09:42AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.