MySQL Forums
Forum List  »  Partitioning

How about the partition affect the INSERT performance?
Posted by: Jiang Jianping
Date: January 10, 2008 10:30AM

We have an application which need great insert performance: we need to keep the most current 90 days data, there are about 60M records a day and We must insert 200000 records within 5 minutes successfully. Please give me suggestion how to do the partition properly or other solutions:

My plan is use both partition and sub partition: The first level partition is based on day of 365 (that's 365 partitions, so that I can move stale records easily), the second level function I want to use hash function based on customer name.

Best

Options: ReplyQuote


Subject
Views
Written By
Posted
How about the partition affect the INSERT performance?
4635
January 10, 2008 10:30AM


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.