Oren, what MySQL version you are running? What OS?
Send me a copy of your my.cnf, the error log 'hostname'.err, and the exact sequence of SQL statements you used to crash InnoDB, including the table CREATE statements. Did InnoDB run out of tablespace? Regarding the performance, did you set innodb_flush_log_at_trx_commit=0 when you tried to use the script to pipe inserts to MySQL? Best regards, Heikki Tuuri Innobase Oy --- Order technical MySQL/InnoDB support at https://order.mysql.com/ See http://www.innodb.com for the online manual and latest news on InnoDB ----- Original Message ----- 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 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 able to do it with Log(3,000,000) inserts. > > select count(*) from TmpTbl; returns 3,000,000 successfully. > > And now I used 'insert null,Num,concat('user',Num) into .. select Num from > TmpTbl' > > (null is for a auto_increment primary key). > > This fails, the mysqld crashed, restarts, trying to roll back the > transaction, > and I've been wating for a long time and the database is still not > responsive. > > Do I need to set some parameters? > > Do you know a better way to do this? > > P.S. > > I'm also using log-bin (so another mysqld will be the slave of this one). > > > > > Oren Zeev-Ben-Mordehai > Infrastructure Engineer > PhoneDo Networks > office: +972-9-951-7771 ext. 204 > fax: +972-9-951-7772 > email: [EMAIL PROTECTED] > > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
