Date: Tue, 31 Dec 2002 11:33:23 -0800 From: "Michael Wimpee" <mwimpee@nbusa.com> To: <freebsd-questions@FreeBSD.org> Subject: kern.maxfiles guidelines Message-ID: <001501c2b103$8194dc30$3c01010a@mwimpee>
next in thread | raw e-mail | index | archive | help
Hello, We have a 4.4-RELEASE server in production running primarily MySQL which, under extremely heavy loads, puts a lot of /kernel: file: table is full 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'? 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?). Thanks, Michael Wimpee Network Technician Natural Bodycare mwimpee@nbusa.com To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-questions" in the body of the message
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?001501c2b103$8194dc30$3c01010a>