MySQL Forums
Forum List  »  Partitioning

Partition selection on join queries
Posted by: Bobby Boy
Date: March 14, 2011 02:48AM

Does partition selection work in queries with JOIN-ed range-partitioned table?

------------

Here is a problem ( http://bugs.mysql.com/bug.php?id=26630 ) .
Looking at EXPLAIN PARTITIONS shows that all (pruned..) partitions at joined table are accessed.

And.. Some people ( http://s.petrunia.net/blog/?p=17 ) suspects it will never be fixed .

But.. Another people say it works ( http://forge.mysql.com/worklog/task.php?id=4128 ) but we just can't see it at EXPLAIN..

And.. Community documentation ( http://forge.mysql.com/wiki/MySQL_Internals_Optimizer#Partition_selection ) tells us it should work.

------------

Question1: Does partition selection actually work Mysql 5.1.55 ?

Question2: Is there any way to detect if partition selection was used?
"explain partitions" does not work, "flush status; show status like 'Handler%';" just shows increasing of Handler_read_key value.

Options: ReplyQuote


Subject
Views
Written By
Posted
Partition selection on join queries
3103
March 14, 2011 02:48AM


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.