MySQL Forums
Forum List  »  Performance

Number of table Partitions
Posted by: Jawahar muthukrishnan
Date: July 22, 2015 01:24PM

In my application, I am estimating nearly 20 million records being stored EVERY day to a BIG_table.

At the end of each day, I am planning on Aggregating the results from the BIG_table and saving it in SUMMARY_table.

Once aggregation is complete, I would delete all the 20 million records for the previous day.

To improve performance of "delete", I am considering PARTITIONing the table on DATE RANGE.

Based on my design, the maximum number of PARTITIONs I am envisioning is only "2". In Rick James blog on Partition:, he has the following statement:
"Under, say, 5 partitions -- you get very little of the benefits. "

In my case, I think deleting ~20 million records every day will be quicker with PARTITIONs, but after reading Rick's statement, I am a little concerned.

Could someone help.


Options: ReplyQuote

Written By
Number of table Partitions
July 22, 2015 01:24PM
July 24, 2015 03:14PM
July 31, 2015 02:15PM

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.