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
[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
