Either way works. Yes, file.files.nr first column is the current number in use. Also note that systemd used to not load the limits.conf file and as such may have its own lower limits on anything started under a systemd service. I think the theory was anything started under systemd should provide any override limits, and that the low defaults were intended to limit the ability of something to overrun the system. Note this: cat /proc/3733/limits will show you the active limits on pid 3733 so find the pid for mariadb and its children and see what their actual limit is. On Mon, Nov 13, 2023 at 3:50 PM Alex <mysqlstudent@xxxxxxxxx> wrote: > > Hi, what is the current way to increase the number of available open files? This is for a mariadb database server I'm trying to configure based on instructions from the database developer to increase the total number of files to 50000. I've added the following to /etc/security/limits.conf and rebooted: > > root - nofile 50000 > > ulimit -n as root now shows: > # ulimit -n > 50000 > > Can this value also be set by using sysctl and setting fs.file-max to 50000? > # sysctl -a|grep file > fs.file-max = 50000 > fs.file-nr = 6864 0 50000 > fs.xfs.filestream_centisecs = 3000 > > Which is the correct way? Also, does fs.file-nr mean there are currently 6864 open files on the system? > > _______________________________________________ > users mailing list -- users@xxxxxxxxxxxxxxxxxxxxxxx > To unsubscribe send an email to users-leave@xxxxxxxxxxxxxxxxxxxxxxx > Fedora Code of Conduct: https://docs.fedoraproject.org/en-US/project/code-of-conduct/ > List Guidelines: https://fedoraproject.org/wiki/Mailing_list_guidelines > List Archives: https://lists.fedoraproject.org/archives/list/users@xxxxxxxxxxxxxxxxxxxxxxx > Do not reply to spam, report it: https://pagure.io/fedora-infrastructure/new_issue _______________________________________________ users mailing list -- users@xxxxxxxxxxxxxxxxxxxxxxx To unsubscribe send an email to users-leave@xxxxxxxxxxxxxxxxxxxxxxx Fedora Code of Conduct: https://docs.fedoraproject.org/en-US/project/code-of-conduct/ List Guidelines: https://fedoraproject.org/wiki/Mailing_list_guidelines List Archives: https://lists.fedoraproject.org/archives/list/users@xxxxxxxxxxxxxxxxxxxxxxx Do not reply to spam, report it: https://pagure.io/fedora-infrastructure/new_issue
