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
