MySQL Forums
Forum List  »  Partitioning

REORGANIZE PARTITION Stuck: (status = setup)
Posted by: Shaun Martinec
Date: June 01, 2011 07:36PM

We are using REORGANIZE PARTITION to combine 2 partitions (by range) into a single partition. But, for some reason, the query stays in "setup" status for
a very long time with high CPU usage and no data movement to the temp table. Then, the query completes the move without issue. Is there anything we can do to eliminate or speedup this process. Maybe some way to do the alter by creating a new table with the data and swapping the files using the file system. Any input or referrals would be greatly appreciated. Thanks.

Options: ReplyQuote


Subject
Views
Written By
Posted
REORGANIZE PARTITION Stuck: (status = setup)
4212
June 01, 2011 07:36PM


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.