Re: Removing old registers from databases larer than 100GB
Posted by: Peter Brawley
Date: March 13, 2017 09:28AM

This needs every table to have a column that tracks row insert date.

Make a complete mysqldump of the db, run the script to create the db under a new name eg mydb_archive, verify that everything is there.

Then in the original, delete rows older than 6 months.

Failing that, you may want to add such tracking columns so you can implement archiving in the future, and meanwhile look at optimising your tables, indexes and queries.

Options: ReplyQuote


Subject
Written By
Posted
Re: Removing old registers from databases larer than 100GB
March 13, 2017 09:28AM


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.