MySQL Forums
Forum List  »  Partitioning

Re: partition based upon timestamp column per day
Posted by: santhosh edukulla
Date: March 03, 2011 09:44AM

Thanks Rick for the response.

The reason for partitioning are:
1. Query performance : We have reports which needs data between two dates. Other queries are there as well.
2. Maintenance: User can delete the data greater than a given data after certain date time
3. Insertion: Its a multi core multi processor machine , we learnt that partitioning can help insertion as well.

We use load data infile to insert the records.
Again here we have a question: How many records per csv we can have for load data statement? We currently are maintaining 40000 records. Will adding more can increase the insertion rate?

I was told that timestamp column based partition is more resource incentive compared to date\datetime? If yes, how to partition by day using timestamp column.


Options: ReplyQuote

Written By
Re: partition based upon timestamp column per day
March 03, 2011 09:44AM

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.