Re: Backup and trimming data idea
If you have millions of rows, and you need to purge it after 90 days, then I recommend...
* PARTITION by week. That would be about 14 partitions.
* Have a weekly script that
1. Copies data your 'backup', then
2. ALTER ... DROP PARTITION -- to remove a week's worth of data very efficiently.
Various techniques can be used for "copying" the data. mysqldump. INSERT...SELECT. etc.
Subject
Views
Written By
Posted
3534
June 22, 2012 07:34PM
Re: Backup and trimming data idea
1696
June 23, 2012 05:23PM
1754
June 23, 2012 05:36PM
1776
June 24, 2012 01:51PM
1813
June 25, 2012 10:16AM
1658
June 26, 2012 08:14AM
1758
June 26, 2012 08:46AM
1642
June 27, 2012 08:36AM
1739
June 27, 2012 09:03AM
1603
June 28, 2012 11:19PM
1554
June 29, 2012 07:12AM
1561
June 30, 2012 11:50AM
1635
July 02, 2012 09:47AM
1577
July 03, 2012 01:32PM
1621
July 05, 2012 11:13AM
1795
July 06, 2012 09:57AM
1585
July 07, 2012 10:50AM
1605
July 08, 2012 09:33AM
1595
July 16, 2012 08:08PM
1580
July 21, 2012 10:57PM
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.