copy data between very large tables

2003-10-16 Thread virtual user for ouzounis cgi
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

re: copy data between very large tables

2003-10-16 Thread mhlists
gt;We copy data from one table to another using: gt;insert into TBL1 select * from TBL 2; gt;The current database hangs and the process never finish when copying gt;huge gt;tables (around 25million rows). Looking at the processlist it states that gt;the process stays in \closing table\ or