RE: INNODB transaction log size

2004-06-29 Thread Victor Pendleton
Keep in my mind that if something does go `wrong` you could possibly have to wait hours for all of your transactions to roll back. -Original Message- From: Michael Lee To: '[EMAIL PROTECTED] ' Sent: 6/28/04 9:35 PM Subject: RE: INNODB transaction log size Victor, Thanks for your reply

INNODB transaction log size

2004-06-28 Thread Michael Lee
Hi, I would like to migrate my DB from Sybase ASE to MySQL INNODB table. Data has been extracted and stored as a file. I want to use the command Load Data Infile to insert the data to MySQL. However, some table contains millions of rows. Can i control the batch size of the loading (e.g.

RE: INNODB transaction log size

2004-06-28 Thread Victor Pendleton
transaction log size Hi, I would like to migrate my DB from Sybase ASE to MySQL INNODB table. Data has been extracted and stored as a file. I want to use the command Load Data Infile to insert the data to MySQL. However, some table contains millions of rows. Can i control the batch size of the loading

RE: INNODB transaction log size

2004-06-28 Thread Michael Lee
` number of inserts. -Original Message- From: Michael Lee To: [EMAIL PROTECTED] Sent: 6/28/04 1:21 AM Subject: INNODB transaction log size Hi, I would like to migrate my DB from Sybase ASE to MySQL INNODB table. Data has been extracted and stored as a file. I want to use the command Load