Now and then when our site is very busy, mysql seems to get into a state where tons and tons threads 'stick' in the Opening Tables status... www# mysqladmin proc | grep -c "Opening tables" 188 Any ideas why that is? Anything I can do to try and figure it out? I'm stumped how to procede here. :) As for what else is doing on, beside sleeping threads we have: www# mysqladmin proc | grep -v Opening | grep -v Sleep | grep localhost | 136 | root | localhost | forum | Query | 15 | Writing to net | SELECT * FROM forum WHERE displayorder<>0 AND active=1 ORDER BY parentid,displayorder | | 269 | root | localhost | forum | Query | 19 | Writing to net | SELECT * FROM forum WHERE displayorder<>0 AND active=1 ORDER BY parentid,displayorder | | 314 | root | localhost | forum | Query | 19 | Writing to net | SELECT * FROM forum WHERE displayorder<>0 AND active=1 ORDER BY parentid,displayorder | | 395 | root | localhost | forum | Query | 38 | Writing to net | SELECT * FROM forum WHERE displayorder<>0 AND active=1 ORDER BY parentid,displayorder | | 610 | root | localhost | forum | Query | 4 | closing tables | SELECT sessionhash,userid,host,useragent,styleid FROM session WHERE sessionhash='707795b6e5e7a7b534c | | 679 | root | localhost | | Query | 0 | | show processlist | Just a few selects writing to net... the queries are for many different tables. Forum itself is a MyISAM table. Other tables are using InnoDB. I thought maybe it was related to the innodb_file_io_threads=4 but that shouldn't affect non-InnoDB tables, right? This is on FreeBSD 3.4 with mysql 3.23.37. It is compiled with the optimization flags recommended in the manual for gcc 2.95 on an Intel machine. -Jonathan --- Jonathan Roy - [EMAIL PROTECTED] --------------------------------------------------------------------- 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