On dim, 2003-02-09 at 19:23, Brion Vibber wrote:
I've managed to catch it in the act; attached are
two snapshots of "SHOW
PROCESSLIST" taken about 45 seconds apart. A whooole bunch of threads
are stuck on the user_newtalk query in "Statistics" state; after about a
minute they fall apart and there are a bunch of cur queries in "Closing
tables" and "Opening tables".
The only information I've dragged up so far on the 'statistics' state is
this thread:
http://forums.devshed.com/archive/4/2002/11/4/46232
Apparently it's something to do with joins... or indexes... or finding
which indexes which are sometimes relevant to joins... Anyway, I'm not
sure how much benefit an index has on a table with 75 rows and only
constant SELECTs, 99% of which are checking for values that *don't*
appear in the table. I've dumped the indexes on user_newtalk for now,
see what that does...
-- brion vibber (brion @
pobox.com)