From: Ady Wicaksono (ady.wicaksonogmail.com)
Date: Fri Nov 16 2007 - 14:05:54 CST

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

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 <bmurphyparagon-cs.com> 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: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=ady.wicaksonogmail.com
>
>

--
Regards,

Ady Wicaksono
Email:
ady.wicaksono at gmail.com
http://adywicaksono.wordpress.com/

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]