Skip site navigation (1)Skip section navigation (2)
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: <http://docs.FreeBSD.org/cgi/mid.cgi?001501c2b103$8194dc30$3c01010a>