My delayed_insert_timeout is the default 300 seconds. Why then would I have DELAYED threads that have been idle for 14+ hours?
+------+----------+-------------------+--------+----------------+-------+--- -----------------+------------------+ | Id | User | Host | db | Command | Time | State | Info | +------+----------+-------------------+--------+----------------+-------+--- -----------------+------------------+ | 414 | DELAYED | localhost | by_323 | Delayed_insert | 51314 | Waiting for INSERT | | | 415 | DELAYED | localhost | by_323 | Delayed_insert | 51316 | Waiting for INSERT | | | 420 | DELAYED | localhost | by_323 | Delayed_insert | 51014 | Waiting for INSERT | | | 421 | DELAYED | localhost | by_323 | Delayed_insert | 51014 | Waiting for INSERT | | | 425 | DELAYED | localhost | by_323 | Delayed_insert | 51030 | Waiting for INSERT | | | 426 | DELAYED | localhost | by_323 | Delayed_insert | 50715 | Waiting for INSERT | | | 427 | DELAYED | localhost | by_323 | Delayed_insert | 50718 | Waiting for INSERT | | | 431 | DELAYED | localhost | by_323 | Delayed_insert | 50414 | Waiting for INSERT | | | 432 | DELAYED | localhost | by_323 | Delayed_insert | 50414 | Waiting for INSERT | | | 435 | DELAYED | localhost | by_323 | Delayed_insert | 50116 | Waiting for INSERT | | | 436 | DELAYED | localhost | by_323 | Delayed_insert | 50114 | Waiting for INSERT | | | 440 | DELAYED | localhost | by_323 | Delayed_insert | 49815 | Waiting for INSERT | | ... I'm running MySQL 4.0.2-alpha. Thanks! Lance --------------------------------------------------------------------- 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
