Hi all, I was curious if anyone has been experiencing problems with INSERT DELAYED lately. At the moment, it seems to limited to INSERT DELAYED and tables with a FULLTEXT index. After a while, a lock on table prevents any normal INSERTS or SELECTS (this behavior may require doing both normal and delayed inserts, but I'm not sure... its either that or its the fulltext index. Insert delayed on a fixed size table with no fulltext index and no normal inserts works without error). The lock persists even when the delayed handler is empty (Not_flushed_delayed_rows is zero). I'm using MySQL 3.23.30 So anyway, I tried doing a flush tables. Bad idea!! Bad! It waits for the tables in question, and does not allow new insert delayed handlers to start up. The process list fills up with 'Creating delayed handler' and sends the server down as it fills all possible connection slots. Shutting down does not succeed. I was curious to hear any related stories that might help me create a test case. 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
