Moi,
every now and then my otherwise happely running mysqld has a thread or two
stuck in the state 'statistics'. If I kill it with `mysqladmin kill <poor
threads id>` it does get registered as 'killed' (According to `mytop`). But
the thread refuses to die. They do die eventually but it can take a few
thousend seconds. I suppose it waits till the 'statistics' state
is over before it accepts its defeat.
The queries which cause this are usually nice > 9 table joins. I don`t care
the take loooong to execute, but it would by nice if killing them actually helped.
Any thoughts?
This is 4.0.7 but I can remember this has happend in < 4.0 as well.
Thanks,
Harmen
(Excuse the subject ;)
--
The Moon is New
tty.nl - 2dehands.nl: 64837
---------------------------------------------------------------------
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
