MySQL Forums
Forum List  »  Partitioning

Re: MySql Partitioning problem (bug?)
Posted by: Mattias Jonsson
Date: May 16, 2014 06:15AM

Hi K T,

I tried to explain the optimization for small ranges in non-ranged partitioning in the bug you created:
Bug#72600: similar query ranges involve different partitions

So I am basically verifying what Rick said, with the exception for smaller ranges.

If the range is larger than 2 * <number of partitions> and larger than 32 it will not be used for pruning of non range/list partitioning (also know as interval walking)..

Options: ReplyQuote


Subject
Views
Written By
Posted
7237
K T
May 07, 2014 04:39PM
1491
K T
May 10, 2014 03:41PM
1427
K T
May 10, 2014 03:44PM
Re: MySql Partitioning problem (bug?)
1582
May 16, 2014 06:15AM


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.