MySQL Forums
Forum List  »  Partitioning

Re: partition and subpartitioning help
Posted by: Rick James
Date: May 18, 2011 11:15PM

Is this your only query?
select * from data where timestamp>='...' and timesatmp<='...'
If so, PARTITION buys you nothing. A plain table with an INDEX starting with timestamp will suffice.

As for the Handler_% questions -- which query was that for? How many rows were in the resultset?

Did you realize you are reaching into an extra partition unnecessarily?
timesatmp<='2009-09-02'
-->
timesatmp<'2009-09-02'
(The classic "midnight bug".)

You have not said what the rest of the CREATE TABLE looks like -- are there UNIQUE keys? Is id AUTO_INCREMENT? Etc.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: partition and subpartitioning help
1404
May 18, 2011 11: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.