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
Subject
Written By
Posted
Disable redo undo information in ibdata1
August 31, 2018 02:27AM
September 04, 2018 04:29AM
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.