If your database server is likely to have a lot of connected clients, you should expand the file descriptor limit for the user who will run the database server daemon.
How to expand the file descriptor limit for the database server
-
In a terminal, open the limits configuration file in a text editor:
$ sudo vi /etc/security/limits.conf
-
At the end of the file, just before the # End of file line, add the following lines, replacing <username> with the name of the user who runs the database server daemon:
<username> soft nofile 16384 <username> soft nofile 16384
For example, if you installed the database server as a daemon, it will run as user usabatch by default. Hence you would need to add the following lines before # End of file:
usabatch soft nofile 16384 usabatch soft nofile 16384
- Save and quit.
Comments
0 comments
Article is closed for comments.