On sab, 2003-02-08 at 17:46, Brion Vibber wrote:
My recollection of looking at the SHOW PROCESS list
during peak times is
that these queries were usually sitting in "Statistics" or "Opening
tables" state. (What _is_ "Statistics"? The online manual doesn't
seem
to explain it.)
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".
-- brion vibber (brion @
pobox.com)