.
- Original Message
From: B. Keith Murphy [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Friday, November 16, 2007 10:29:17 AM
Subject: innodb rollback question
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
At 02:05 PM 11/16/2007, you wrote:
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
Ady,
Sure but won't the entire Load Data will still be wrapped in a
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.
: B. Keith Murphy [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Friday, November 16, 2007 10:29:17 AM
Subject: innodb rollback question
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
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 [EMAIL PROTECTED] wrote:
I have something to throw out. I just