disable undo buffer for delete query
hi
can I disable undo buffer for DELETE query?
I don't see a point for rollbacking delete query when it fails, I want to delete the data even if the query fails halfway
I accidentally run delete query for millions of rows. I wanted to delete the data but in safer way.
At some point rollback occured and it effectively killed whole cluster.
Is there a way to prevend this?
Can mysql auto commit delete query in smaller chunks instead of one huhe?
thanks
Subject
Views
Written By
Posted
disable undo buffer for delete query
1663
May 06, 2018 05:39AM
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.