Hello again!
In the prev episode i said that when i do INSERT DELAYED
mysql just catches sig 11, crashes and restarts. No record
inserted whatsoever. Nothing is written into the update log.
Here is a sample (even though it says 1 row affected, it is
actually not affected. nothing is inserted):
mysql> insert delayed into aaa (aid, aname) values (111,'hello');
Query OK, 1 row affected (0.00 sec)
mysql> 010301 20:17:22 mysqld restarted
In the error log:
010301 20:16:27 mysqld started
/usr/local/mysql/bin/mysqld: ready for connections
mysqld got signal 11;
The manual section 'Debugging a MySQL server' tells you how to use a
stack trace and/or the core file to produce a readable backtrace that
may
help in finding out why mysqld died
010301 20:17:22 mysqld restarted
/usr/local/mysql/bin/mysqld: ready for connections
I use FreeBSD 4.2-STABLE (cvsupped and rebuild last sunday),
MySQL 3.23.33. Compiled using the options which are used in the
FreeBSD port of mysql to make it stable on high loads. But it is build
from the original tar ball taken from www.mysql.com. That does not
matter, since patches for mysql on FreeBSD
are minimal and not really needed.
Sinisa recommended to try precompiled binary for FreeBSD. I did.
Same story - keeps crashing on INSERT DELAYED. (not to mention
that i hate to use precompiled stuff, because it is never configured
as i want it to be).
What's going on? I really need INSERT DELAYED since i need
to insert millions of records in a short time for development and
testing purposes.
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
