List:General Discussion« Previous MessageNext Message »
From:Angela liu Date:December 1 2011 10:26pm
Subject:Re: best way to copy a innodb table
View as plain text  
how to break the table into 100,000 chunks?

thanks


________________________________
 From: Claudio Nanni <claudio.nanni@stripped>
To: Angela liu <yyll2087@stripped> 
Cc: "mysql@stripped" <mysql@stripped> 
Sent: Thursday, December 1, 2011 2:24 PM
Subject: Re: best way to copy a innodb table
 
Sure you can, and you should.

but in case you also update/delete rows from the first table you have to
set up trigger to log changes.
if you are lucky (only inserts) then its easier.

Cheers

Claudio

2011/12/1 Angela liu <yyll2087@stripped>

> Hi, folks:
>
>
> I have a situation:
>
> A large innodb table t1 with 45 million rows, need to have a new table t2
> exactly the same as t1, to copy the data from t1 to t2, I have the
> following query:
>
> create table t2 like t1;
>
> insert into t2 select * from t1;
>
>
> but the above insert may run long time , that can interface with
> performance, is there a way to chunk the insert into the new table? like
> breaking it down into chunks of 100,000 rows ?
>
>
> Thanks




-- 
Claudio
Thread
best way to copy a innodb tableAngela liu1 Dec
  • Re: best way to copy a innodb tableClaudio Nanni1 Dec
    • Re: best way to copy a innodb tableAngela liu1 Dec
  • Re: best way to copy a innodb tableMiguel Angel Nieto1 Dec
    • Re: best way to copy a innodb tablePerrin Harkins2 Jul
  • Re: best way to copy a innodb tableKaren Abgarian2 Dec
  • Re: best way to copy a innodb tableArjun2 Jul
    • Re: best way to copy a innodb tableMichael Dykman2 Jul
    • RE: best way to copy a innodb tableRick James2 Jul