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
4824
June 01, 2011 07:36PM
2524
June 01, 2011 07:46PM
Re: REORGANIZE PARTITION Stuck: (status = setup)
2384
June 02, 2011 10:34PM
2923
June 03, 2011 03:23AM
2923
June 03, 2011 08:28AM
2411
June 03, 2011 02:01PM
Sorry, you can't reply to this topic. It has been closed.
This forum is currently read only. You can not log in or make any changes. This is a temporary situation.
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.