File table overflow

[Michael Widenius]

>>>>> "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