Well, the easy way to chunk the inserts is by use of limit. Here is what I used for one of my projects:
Insert ignore into t1 (f1, f2, f3) Select f1, f2, f3 from t2 limit 1000000, 1000000 Inserts 1M records at a time starting from 1M th record in t2 and you can keep incrementing this offset as you progress. This will help in monitoring the table inserts and at the same time move chunks of records from source table. Enjoy! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql
