MySQL Forums
Forum List  »  Newbie

Re: MySQL Partitioning showing low performance
Posted by: vo ko
Date: March 04, 2013 11:32AM

I have the simular issue with same queries. I compared daily partioned table with creating daily tables. And dayly table works 10+times faster then partioned table.
I my case key index2 with date field is not unique and date field is second (last) field in this key

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.