MySQL Forums
Forum List  »  Partitioning

Re: RE:how to make partititon for my table as required
Posted by: Rick James
Date: April 14, 2011 08:01AM

It would help to see the table. Please do
SHOW CREATE TABLE pvk_table_test_solve1 \G
SHOW TABLE STATUS LIKE pvk_table_test_solve1 \G

You mentioned reading_datetime (in the PRIMARY KEY) and reading_date (in the partition key) -- are they separate fields?
Almost always is it best to have date&time in a single field.

WHERE reading_date >='2009-10-02' AND reading_date <= '2010-10-02'
If reading_date is a DATE, then you are including Oct 2 from both years; did you mean to?
If it is DATETIME or TIMESTAMP, then you are including midnight from 2010-10-02, which is probably a mistake.

Please explain why you think PARTITIONing is useful in your case. (Often people are drawn to PARTITION by false claims.)

Let's see the SELECT statements you will apply to this table. We would like to see if HASH will provide any benefit for them.

Options: ReplyQuote

Written By
Re: RE:how to make partititon for my table as required
April 14, 2011 08:01AM

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.