MySQL Forums
Forum List  »  MyISAM

Alt index search on partitioned table
Posted by: CHap Harrison
Date: February 20, 2014 02:46PM

I have a myISAM table with 30 partitions. The primary key is a SHA1 hash value, which is also used in the partition selection function. I also have an alternate key - an autoincrement integer. Since the alternate key does not include the value used in the partition selection function, selecting on the alternate index can't use a process called (I think) "partition pruning". Therefore, a select for an alternate key must involve searches on all 30 partitions. This much makes sense.

I was recently told that such a search is carried out *serially* -- on one partition after another. I find this hard to believe, since it sounds like something that could be done concurrently. Can anyone confirm this behavior?

mySQL 5.6.14

Options: ReplyQuote

Written By
Alt index search on partitioned table
February 20, 2014 02:46PM
February 24, 2014 05:49PM

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.