I had some trouble using insert delayed - I wonder if anyone can shed some
light on the problem.
I have a table for logs that records are inserted into regularly - once
every 10 seconds or so. I tried to update record in the table, but the
update just waited forever, it seemed to be waiting untill the delayed
thread had run.
Next I tried to get a write lock on the table so that I could run the
updates, but that made a huge mess - I could not obtain the lock.
Finally, I tried to flush the tables, but then things were even worse - each
insert delayed query was waiting to create an insert thread, the inserting
threads weren't going aywhere, and new insert threads were piling up faster
than I could kill them. I finally had to restart the server to get back to
normal.
So... it looks like the right way to do it is to stop the inserts into the
tables (or direct them to some alternate table), kill the insert delayed
thread to make it write it's data, and then work on the table? Or is there
a much easier / safer way to go about this?
Thanks,
Ord Millar
---------------------------------------------------------------------
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
