I am using 3.23.33.
I had posted a question asking for ways to improve my insert performance,
and I got a reply asking to use DELAYED.
I used it, but it seems like DELAYED takes twice the time a normal INSERT wud take.
Anything I am missing?
My table has 250000 records and I am using DELETE FROM TABLE .. before issuing the
INSERT command.
i.e. the table is empty when I INSERT.
-Thiru
On Thu, 22 Feb 2001 18:52:48 +0300
"Artem Koutchine" <[EMAIL PROTECTED]> wrote:
-> Hi!
->
-> I am trying to insert 1 000 000 records into a very simple
-> table:
->
-> create table test (
-> a1 tinyint unsigned not null,
-> a2 tinyint unsigned not null,
-> a3 tinyint unsigned not null,
-> a4 tinyint unsigned not null,
-> primary key (a1,a2,a3,a4)
-> );
->
-> So, to make it faster i want to use INSERT DELAYED,
-> however, when i do so, i get a message "Server has gone away"
-> and the in the .err log i see mysqld got signal 11.
->
-> I could not use INSERT DELAY in 3.23.30 and up. never tried it
-> earlier.
->
-> Now other problems detected whatsoever under any amount
-> of load.
->
-> Mysql is 3.23.33 compiled from the tar ball (NOT FROM PORTS)
-> with the options recomended in the ports to stop it from crashing
-> on heavy loads.
->
-> OS: FreeBSD 4.2-STABLE
->
-> Regards,
-> Artem
->
->
-> ---------------------------------------------------------------------
-> 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
->
->
-----------------------------o0o----------------------------------------
"There is no finish line, you can always learn"
"You have to keep pressure on yourself, you have to work on your weaknesses".
Thiru
S/W Engineer, Service Dvlpment Group
Infoseek,Japan
--------------------------------------------------------------------
---------------------------------------------------------------------
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
