MySQL Forums
Forum List  »  Partitioning

Re: make number of partitions variable
Posted by: Phil Hildebrand
Date: June 03, 2008 11:54AM

Did you use explain partitions to evaluate the queries in your stored procedure against the tables? (they may be scanning all partitions, or need additional indexes, etc...

You shouldn't loose any data by doing an alter table x engine=innodb;

<note - it could take a while>

Options: ReplyQuote

Written By
Re: make number of partitions variable
June 03, 2008 11:54AM

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.