From: Michael Widenius
Date: April 22 1999 1:09pm
Subject: File table overflow
List-Archive: http://lists.mysql.com/mysql/2248
Message-Id: <14111.7993.640052.640867@monty.pp.sci.fi>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

>>>>> "Gediminas" == Gediminas Girgzdys <g.girgzdys@stripped> writes:

Gediminas> Hi,
Gediminas> I have one database, one table which is accessed from www via php.
Gediminas> mysql options are: table_cache=100 max_connections=40
Gediminas> Time to time i get error  "Error in accept: File table overflow". After that i can't 
Gediminas> connect to mysqld (timeout), that is "mysqladmin status" does not work.
Gediminas> After that I kill mysqld with "kill `cat /path/servername.pid`"
Gediminas> and start again. But mysqld does not accept connections (without timeout).
Gediminas> It starts working only after 5-10 kill/starts, or maybe some timeout.

Gediminas> What does that error message mean? How can I avoid that? Why mysqld 
Gediminas> does not accept connections after restart?


Hi!

The above is a error message from your OS !  You must set up your OS
to allow one to use more open files (globally or per process)

Please always use the mysqlbug script when posting questions!

Yours,
Monty