Re: REORGANIZE PARTITION Stuck: (status = setup)
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?
Subject
Views
Written By
Posted
4636
June 01, 2011 07:36PM
2427
June 01, 2011 07:46PM
Re: REORGANIZE PARTITION Stuck: (status = setup)
2285
June 02, 2011 10:34PM
2830
June 03, 2011 03:23AM
2779
June 03, 2011 08:28AM
2321
June 03, 2011 02:01PM
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.