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
