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
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