MySQL Forums
Forum List  »  General

Disable redo undo information in ibdata1
Posted by: james wang
Date: August 31, 2018 02:27AM

Hi All,

For planned MySQL delete (e.g. looping: DELETE FROM a_table LIMIT 10000 WHERE datetime<DATE_SUB(NOW(), INTERVAL 2 YEAR)), I don't wish MySQL to record the redo and undo information in the ibdata1 file (as otherwise it's size increases to hundreds of G).

Is this possible please? Version 5.6.36

Thanks a lot in advance

Options: ReplyQuote


Subject
Written By
Posted
Disable redo undo information in ibdata1
August 31, 2018 02:27AM


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.