List:General Discussion« Previous MessageNext Message »
From:Ady Wicaksono Date:November 16 2007 8:05pm
Subject:Re: innodb rollback question
View as plain text  
How do you import the data?

Load data from file is faster thought
so better to export myisam -> file and then you do load data from file

make sure you set autocommit=0 to make it faster

On Nov 17, 2007 12:29 AM, B. Keith Murphy <bmurphy@stripped> wrote:

> I have something to throw out.  I just got done importing 140 million
> rows from a myisam table to a innodb table.  While it worked I had a
> thought about 3/4ths of the way through.  What if the transaction had
> been canceled about 130 million rows in?  It would have taken weeks to
> roll back.
> The only way I know of to stop a rollback like that is to bring out the
> sledgehammer and kill the mysql processes and then rip out the entire
> database and re-import.  Faster than the rollback granted - but not very
> elegant.  Not something you want to do on a production server either
> (the only time I had this happen it was in a test environment so there
> were no consequences to my subsequent actions :)
> Any better way to do this?
> Thanks,
> Keith
> --
> MySQL General Mailing List
> For list archives:
> To unsubscribe:


Ady Wicaksono
ady.wicaksono at

innodb rollback questionB. Keith Murphy16 Nov
  • Re: innodb rollback questionAdy Wicaksono16 Nov
    • Re: innodb rollback questionmos18 Nov
Re: innodb rollback questionWilliam Newton16 Nov
  • Re: innodb rollback questionB. Keith Murphy19 Nov