Expanding the File Descriptor Limit for a Database Server on GNU/Linux

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.

  1. In a terminal, open the limits configuration file in a text editor:

    $ sudo vi /etc/security/limits.conf

  2. 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
  3. Save and quit.