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!
Subject
Views
Written By
Posted
17463
June 16, 2017 12:42AM
8900
June 16, 2017 11:02AM
Re: Faster/more reliable way to delete millions of rows?
5276
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.