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