re: copy data between very large tables

>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

copy data between very large tables

Hi, 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" st