MySQL Forums
Forum List  »  Partitioning

Re: REORGANIZE PARTITION Stuck: (status = setup)
Posted by: Rick James
Date: June 02, 2011 10:34PM

Why so slow? It depends. To further analyze, please provide
* SHOW CREATE TABLE tbl\G -- engine, indexes
* SHOW TABLE STATUS LIKE 'tbl'\G -- sizes
* SHOW VARIABLES LIKE '%buffer%'; -- cache size
and surround them with [ code ] and [ / code ]
How much RAM do you have?

How big are the two partitions you are combining?

Options: ReplyQuote

Written By
Re: REORGANIZE PARTITION Stuck: (status = setup)
June 02, 2011 10:34PM

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.