MySQL Forums
Forum List  »  Newbie

Re: MySQL Partitioning showing low performance
Posted by: Mattias Jonsson
Date: February 28, 2013 06:13AM

I agree with Rick, since there is an index on (column2,column3...) you will hardly gain anything from partitioning on this query (unless you have problem with getting it all into the bufferpool, where partitioning could help by having the hottest partition there).

Also I wonder if you could try 5.6, since I think you are affected by bug#37252, which is fixed in 5.6. Then it should at least have similar performance as a non partitioned table. I would appreciate some feed back on the fix!

Options: ReplyQuote




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.