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
4767
June 01, 2011 07:36PM
2488
June 01, 2011 07:46PM
Re: REORGANIZE PARTITION Stuck: (status = setup)
2352
June 02, 2011 10:34PM
2897
June 03, 2011 03:23AM
2884
June 03, 2011 08:28AM
2383
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.