Have you also increased your master maxfiles as well? If not, you're not
getting the number of file handles you expect you are. I'd also consider
upgrading to 4.3, as it's much faster than 3.x.
Try this --
sysctl -w kern.maxfiles=16424
"Chris Bolt" <[EMAIL PROTECTED]> wrote:
Right now MySQL is getting really backlogged but I have no idea why. There
are 169 concurrently running queries, and 153 of them are in show the
status
as "Opening tables". A processlist looks something like this (formatted by
Status, Seconds query has been running, and query):
Opening tables 15 SELECT users.username, user...
Opening tables 15 SELECT users.username, user...
[...]
What I don't get is why all those queries are at Opening tables. My
table_cache is currently set to 2048. It's a FreeBSD 3.4-RELEASE box.
$ sysctl kern.maxfilesperproc
kern.maxfilesperproc: 16424
I just reloaded the processlist and now half of the queries are in "closing
tables" state (with running times from 16 to 48 seconds) and the other half
are in "Opening tables" state, with running times all at 1 second. Why are
threads closing tables if the table cache isn't even full?
---------------------------------------------------------------------
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
