From owner-freebsd-questions Mon Jun 15 22:19:01 1998 Return-Path: Received: (from majordom@localhost) by hub.freebsd.org (8.8.8/8.8.8) id WAA14318 for freebsd-questions-outgoing; Mon, 15 Jun 1998 22:19:01 -0700 (PDT) (envelope-from owner-freebsd-questions@FreeBSD.ORG) Received: from gdi.uoregon.edu (metriclient-2.uoregon.edu [128.223.172.2]) by hub.freebsd.org (8.8.8/8.8.8) with ESMTP id WAA14241 for ; Mon, 15 Jun 1998 22:18:45 -0700 (PDT) (envelope-from dwhite@gdi.uoregon.edu) Received: from localhost (dwhite@localhost) by gdi.uoregon.edu (8.8.8/8.8.8) with SMTP id WAA02825; Mon, 15 Jun 1998 22:18:24 -0700 (PDT) (envelope-from dwhite@gdi.uoregon.edu) Date: Mon, 15 Jun 1998 22:18:24 -0700 (PDT) From: Doug White Reply-To: Doug White To: Luiz Lins cc: "freebsd-questions@FreeBSD.ORG" Subject: Re: File Descriptors... In-Reply-To: <3581A2D0.5F8D7B3A@vecom.com.br> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Sender: owner-freebsd-questions@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.ORG On Fri, 12 Jun 1998, Luiz Lins wrote: > Hi, > > I'm using FreeBSD-2.2.5 RELEASE and Mysql-3.21.30. Developing a new > database, a stuck in a problem: > > My database has thousands of tables, therefore I wrote a Perl script > will create and insert values in the tables. The script works fine but > after create about 125 tables, mysql returns an error that there's too > much opened tables (Error 23). > > Looking into manual, it says I have to increase the number of file > descriptors that my system handle. Here is my (Newbye) question: where > do I change it? Try running `unlimit' before starting the SQL server. Doug White | University of Oregon Internet: dwhite@resnet.uoregon.edu | Residence Networking Assistant http://gladstone.uoregon.edu/~dwhite | Computer Science Major NOTICE: Make sure your mailer replies to dwhite@resnet or I won't get it! To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-questions" in the body of the message