"Michael Wimpee" <[EMAIL PROTECTED]> writes: > errors into the syslog. Newsgroup posts all seem to prescribe 'sysctl -w > kern.maxfiles=[big number]', but I haven't seen any guidelines for the > value of 'big'. Assume I get excited and do 'sysctl -w > kern.maxfiles=9999999999'. What will happen as I open more and more > files? Is there a formula for calculating good values of 'big' (eg, MB > RAM * SQL_MAX_CONNECTIONS * Pi)? Or do I just keep increasing it until > it's 'big enough'?
Unless you have an a priori method of determining the most file handles that should ever be needed simultaneously, empirical methods are the best choice available -- and will do fine. > Increasing the value (which I've done) indeed fixes the problem, but > I've yet to see a rationale for the stated values people are using and > there *must* be a reason for the defaults (anybody know what it is?). It's a compromise between running out of file handles and wasting memory on the file table. To Unsubscribe: send mail to [EMAIL PROTECTED] with "unsubscribe freebsd-questions" in the body of the message
