MySQL Forums
Forum List  »  Partitioning

Hash and Linear Hash partition table not performing well
Posted by: Neeraj Khandelwal
Date: November 27, 2009 03:04AM

Hi,

I've performed benchmarking over on 300Million rows and noticed that the HASH and Linear Hash partition table not performing well compare to regular table.

I've performed different-different use cases with 10 to 1M records in IN clause for the SELECT statement.Also repeated same use cases 2 to 3 times, but I didn't find any use case that outperforming on HASH and Linear HASH table.
Also check the use cases with EXPLAIN PARTITIONS clause and all the use cases was using the partitions.

HELP ME

======
Neeraj

Options: ReplyQuote


Subject
Views
Written By
Posted
Hash and Linear Hash partition table not performing well
6175
November 27, 2009 03:04AM


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.