RE: MySQL getting backlogged

2001-09-13 Thread Chris Bolt
> 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 kern.maxfiles is already the same as .maxfiles

Re: MySQL getting backlogged

2001-09-13 Thread btjones
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 M

MySQL getting backlogged

2001-09-12 Thread Chris Bolt
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