Big table data truncate or delete
Posted by: Peng Wang
Date: February 23, 2022 07:57AM

hi, experts

I have a requirement to purge data in Mysql databases (versions 5.7 and 8), some of the tables are big, TB level. what would be the best way to purge data?

My question
1. If I truncate table, for example, 1 TB size table, any performance impact for the database? I know truncate has almost no impact in Oracle, but this is Mysql, so I am trying to confirm.
2. If I delete the data for the table, should I delete in small chunks?

Thank you

Options: ReplyQuote

Written By
Big table data truncate or delete
February 23, 2022 07:57AM

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.