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)