Mysql Batch insert around 11 GB data from one table to another

Asked Apr 23 '20 at 06:26

Active Apr 23 '20 at 06:26

Viewed 19 times

I want to copy all data from one table to another and also want to minimise downtime by reducing locking time during data copy process.

I am trying to do something like this

INSERT INTO temp_table SELECT * FROM old_table ORDER BY id;

But it's taking around 45 mins to copy. How could i batch process this to reduce lock time.

asked Apr 23 '20 at 06:26

Jeet

1

https://stackoverflow.com/questions/11188427/mysql-efficiently-copy-all-records-from-one-table-to-another – kmoser Apr 23 '20 at 06:34
@kmoser I believe that comment 4 in the link you shared is a good approach !! dump export-import is always faster. – LOKENDRA Apr 23 '20 at 06:37
[pt-archiver](https://www.percona.com/doc/percona-toolkit/LATEST/pt-archiver.html#name) – danblack Apr 23 '20 at 06:41
I am checking with LOCK TABLE option. Will update statistics – Jeet Apr 23 '20 at 06:43

0 Answers0