From: Dan Nelson
Date: March 22 2002 7:17pm
Subject: Re: FreeBSD+MySQL
List-Archive: http://lists.mysql.com/mysql/103926
Message-Id: <20020322191705.GC5937@dan.emsphone.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii

In the last episode (Mar 22), Ozette Brown said:
> Andrey,
> 
> Thank you for the reply.
> 
> I read somewhere that when checking your maximum file descriptors your "kern.maxfiles
> should be greater than kern.maxfilesperproc.  My settings are:
> kern.maxfiles = 8232
> kern.maxfilesperproc = 8232
> So, with that said, my kern.maxfiles should be much higher, no (based on your reply)?

If you're really hitting the system's open-file limit, you will see
"file table full" errors in /var/log/messages.  I really doubt this,
though, because you would have problems running anything on the system
if this were the case.  You're probably hitting a per-user resource limit
or need to bump up table_cache in mysql.

What do the following print out (run them after the server has been up
a while):

sysctl kern.maxfiles kern.maxfilesperproc kern.openfiles
limits -n
mysql -e "show variables like 'table_cache'"
mysql -e "show status like 'Open%'"


-- 
	Dan Nelson
	dnelson@stripped