>We copy data from one table to another using: >insert into TBL1 select * from TBL 2;
>The current database hangs and the process never finish when copying >huge >tables (around 25million rows). Looking at the processlist it states that >the process stays in \"closing table\" or \"wait on cond\" status. You could always look at chunking the data by using progressive LIMIT clauses. INSERT INTO TBL1 SELECT * FROM TBL2 LIMIT 1000000; INSERT INTO TBL1 SELECT * FROM TBL2 LIMIT 1000000,1000000; and so on... Regards, Mike Hillyer www.vbmysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
