MySQL Forums
Forum List  »  Partitioning

Advanced Search
New Topic

Re: Hash and Linear Hash partition table not performing well
Posted by: Mattias Jonsson
Date: December 07, 2009 04:44AM

How many partitions are you using, and what kind of queries (small and simple or large prunable scans) are you running?

Currently MySQL must open and lock every partition before pruning, which gives a certain overhead for each partition, so when using too many partitions the time increases for each statement, and can be too much for small simple queries, which leads to bad performance, see bug#37252, bug#47261, bug#48846.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Hash and Linear Hash partition table not performing well
6378
Neeraj Khandelwal
November 27, 2009 03:04AM
Re: Hash and Linear Hash partition table not performing well
3092
Rick James
December 05, 2009 11:49PM
Re: Hash and Linear Hash partition table not performing well
3139
Neeraj Khandelwal
December 08, 2009 03:42AM
Re: Hash and Linear Hash partition table not performing well
3624
Rick James
December 09, 2009 08:08PM
Re: Hash and Linear Hash partition table not performing well
2892
Mattias Jonsson
December 07, 2009 04:44AM
Re: Hash and Linear Hash partition table not performing well
2724
Neeraj Khandelwal
December 08, 2009 01:05AM
Re: Hash and Linear Hash partition table not performing well
3580
Mattias Jonsson
December 22, 2009 03:29AM


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.