From owner-freebsd-questions@FreeBSD.ORG Wed Jun 4 06:29:16 2003 Return-Path: Delivered-To: freebsd-questions@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id C629237B401 for ; Wed, 4 Jun 2003 06:29:16 -0700 (PDT) Received: from mail.bellavista.cz (mail.bellavista.cz [213.235.167.218]) by mx1.FreeBSD.org (Postfix) with ESMTP id D4C4143F85 for ; Wed, 4 Jun 2003 06:29:15 -0700 (PDT) (envelope-from neuhauser@bellavista.cz) Received: from freepuppy.bellavista.cz (freepuppy.bellavista.cz [10.0.0.10]) by mail.bellavista.cz (Postfix) with ESMTP id 8788D4CE for ; Wed, 4 Jun 2003 15:29:14 +0200 (CEST) Received: by freepuppy.bellavista.cz (Postfix, from userid 1001) id 67B292FDAB2; Wed, 4 Jun 2003 15:29:12 +0200 (CEST) Date: Wed, 4 Jun 2003 15:29:09 +0200 From: Roman Neuhauser To: freebsd-questions Message-ID: <20030604132909.GE29699@freepuppy.bellavista.cz> Mail-Followup-To: freebsd-questions Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.5.1i Subject: max open files reached X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 04 Jun 2003 13:29:17 -0000 I have a script run by periodic(8) in the daily batch that is supposed to backup all databases from the local MySQL server using mysqlhostcopy(1). It used to run fine for a few months, but has been failing consistently with ENFILE (23) lately. The box is an Intel Celeron 533 (or some such) with 128 MB RAM. These are all the related sysctl knobs I could find. This is as of 20:40, so the value of kern.openfiles is reasonable. roman@ishtar ~ 1001:0 > sysctl -a kern|grep files kern.maxfiles: 2024 kern.maxfilesperproc: 1821 kern.openfiles: 512 I've cranked the kern.maxfiles value to 4096, and the backup has run to completion again, but am I risking anything? I mean, the fd's cost memory, is there any potential for problems? -- If you cc me or remove the list(s) completely I'll most likely ignore your message. see http://www.eyrie.org./~eagle/faqs/questions.html