MySQL Forums
Forum List  »  Partitioning

Re: Help to optimize subpartition
Posted by: Rick James
Date: April 20, 2012 06:54PM

OPTIMIZEing a partition leads to OPTIMIZEing the entire table. (This is a known bug; I found it the hard way.) The workaround is to REORGANIZE the one partition that you want to OPTIMIZE.

What benefit do you hope to get from this partitioning? Will you be dropping "old" partitions? The HASHed subpartitions seem to be useless.

Do you do lots of DELETEs? Otherwise, why do you need OPTIMIZE?

Options: ReplyQuote

Written By
April 19, 2012 05:28AM
Re: Help to optimize subpartition
April 20, 2012 06:54PM
April 21, 2012 04:15PM

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.