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
4588
June 01, 2011 07:36PM
2415
June 01, 2011 07:46PM
Re: REORGANIZE PARTITION Stuck: (status = setup)
2269
June 02, 2011 10:34PM
2808
June 03, 2011 03:23AM
2746
June 03, 2011 08:28AM
2307
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.