Skip site navigation (1)Skip section navigation (2)
Date:      Mon, 15 Jun 1998 22:18:24 -0700 (PDT)
From:      Doug White <dwhite@gdi.uoregon.edu>
To:        Luiz Lins <luigi@vecom.com.br>
Cc:        "freebsd-questions@FreeBSD.ORG" <freebsd-questions@FreeBSD.ORG>
Subject:   Re: File Descriptors...
Message-ID:  <Pine.BSF.3.96.980615221812.2150l-100000@gdi.uoregon.edu>
In-Reply-To: <3581A2D0.5F8D7B3A@vecom.com.br>

next in thread | previous in thread | raw e-mail | index | archive | help
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



Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?Pine.BSF.3.96.980615221812.2150l-100000>