MySQL Forums
Forum List  »  InnoDB

disable undo buffer for delete query
Posted by: Pavel Dvořák
Date: May 06, 2018 05:39AM

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?

Options: ReplyQuote

Written By
disable undo buffer for delete query
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.