Another technique to avoid impact to the source database is to create your
target as MyISAM, pump your records into that (no ACID overhead) and at the
end :
ALTER mytable engine=InnoDb
The alter can take awhile but it will impose no strain on the source server
at all.
On Tue, Jul 2, 2013 at 3:48 AM, Arjun <na...@yahoo.com> wrote:
> 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
>
>
--
- michael dykman
- mdyk...@gmail.com
May the Source be with you.
