From: Date: September 13 2001 7:47pm Subject: Re: MySQL getting backlogged List-Archive: http://lists.mysql.com/mysql/85436 Message-Id: MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii 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" 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?