MySQL Forums
Forum List  »  Partitioning

Re: Partition behaiour seems abnormal in range partition
Posted by: Rick James
Date: December 20, 2012 02:56PM

Are the partitions of similar size?

To further debug...

SELECT * FROM information_schema.PARTITIONs WHERE table_schema = 'PART_SAMPLE';
(or something like that)

EXPLAIN PARTITIONS SELECT ... -- for a fast partition; then for a slow partition.

You may need to do an OPTIMIZE. Probably only once. Probably it will take a long time (and lock the table).

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Partition behaiour seems abnormal in range partition
1198
December 20, 2012 02:56PM


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.