Skip navigation links

MySQL Forums :: Partitioning :: Help to optimize subpartition

Advanced Search

Re: Help to optimize subpartition
Posted by: Paki Paki ()
Date: April 21, 2012 04:15PM

Hi, Rick.

There is no problem with dropping the oldest records by truncating and reorganize partitions. It works good and fast.

But the same time we need to do a lot of deletes "in the middle" of table. So we need to do periodical OPTIMIZE for selected partitions.

This table is heavily loaded for write operations. Optimizing one partition can take several minutes. So table (or this partition) is locked for this time.

The idea is to optimize selected subpartitions. This will not take a lot of time because their size is small.

Options: ReplyQuote

Subject Views Written By Posted
Help to optimize subpartition 1824 Paki Paki 04/19/2012 05:28AM
Re: Help to optimize subpartition 1136 Rick James 04/20/2012 06:54PM
Re: Help to optimize subpartition 1090 Paki Paki 04/21/2012 04:15PM
Re: Help to optimize subpartition 1152 Mattias Jonsson 05/02/2012 07:59AM
Re: Help to optimize subpartition 888 Mattias Jonsson 05/02/2012 01:41PM

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.