> My troubles continue with INSERTs (i posted a message about INSERT
> DELAYED crushing a server before). Now, I have this:
We are running Linux and MySQL 3.23.30 and have similar problems. In
particular we have a lot of INSERT DELAYEDs into a fixed table, and REPLACE
DELAYED into a variable size table. At some point the handlers never finish
a query and then fill up handler, then fill up all other processes with
queries that are waiting for the table and then I have to kill -9 it from
the commandline.
This only seems to happen if the tables are really big for the REPLACEs.
I've tested it starting with multi-GB tables and then with empty ones. I see
the slow query and lock up situation with the bigger tables.
I can't make a real test case, save for copying from one multiGig table into
another, perhaps, while also streaming in other log data into the logging
table we have. I wish we could have a replay software so it gets the timing
the same to see what is going on thread-wise.
Oh, well. Let me know if you figure this out.
Sincerely,
Steven Roussey
Network54.com
http://network54.com/?pp=e
---------------------------------------------------------------------
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
