innodb tables problem

2002-05-07 Thread Oren Zeev-Ben-Mordehai
I have defined some InnoDB tables and try to feed one of them with 3,000,000 records. Using a script piped to mysql. First I tried to insert the rows one by one. It worked very slow. I didn't wait to see if it ends. Next try was to fill some temporary table with the numbers 1..3,000,000. I was

Re: innodb tables problem

2002-05-07 Thread Heikki Tuuri
- From: Oren Zeev-Ben-Mordehai [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Tuesday, May 07, 2002 3:16 PM Subject: innodb tables problem I have defined some InnoDB tables and try to feed one of them with 3,000,000 records. Using a script piped to mysql. First I tried

Re: innodb tables problem

2002-05-07 Thread Heikki Tuuri
as recommended in section 2 of http://www.innodb.com/ibman.html. Regards, Heikki - Original Message - From: Oren Zeev-Ben-Mordehai [EMAIL PROTECTED] To: Heikki Tuuri [EMAIL PROTECTED] Sent: Tuesday, May 07, 2002 5:26 PM Subject: RE: innodb tables problem my.cnf -- [mysqld