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" status. We run Mysql version 3.23.52 on a Sun solaris 7 machine and the database directory is located on a NetApp. We configured the my.cnf file to skip-locking and we are not locking any tables explicitly. Any thoughts will be extremely welcome. Thanks Ben & Leon -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]