RE: Error in accept: Too many open files

2011-04-27 Thread misiaq
Hi, It's quite simple and quick change in *nix. But would recommend to check your server performance first (processlist, tmp tables, slow query log etc). Regards, m "Jerry Schwartz" pisze: > You are seeing *NIX error messages. You need to increase the operating system > settings that control

RE: Error in accept: Too many open files

2011-04-26 Thread Jerry Schwartz
You are seeing *NIX error messages. You need to increase the operating system settings that control the number of files that a process can open. I'm very rusty, and never really used Linux, so I can't tell you the exact parameters. There are probably two: total number of open files, and files pe

Re: Error in accept: Too many open files

2011-04-26 Thread Johan De Meersman
300 is pretty low - MySQL counts every instance of a table in any query as an "open file". A query that uses the same table twice (with an alias, for example) thus counts for two open files. This may also be outside of MySQL, the ulimit for the user running the daemon may have open files restr