>>>>> "Gediminas" == Gediminas Girgzdys <g.girgzdys@stripped>
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?
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!
|• File table overflow||Gediminas Girgzdys||22 Apr|
| • File table overflow||Michael Widenius||22 Apr|