← Back to team overview

maria-discuss team mailing list archive

Re: New Question: Could not increase number of max_open_files to more than 1024 (request: 1835)

 

Am 17.09.2014 um 22:25 schrieb AskMonty KB:
> A new question has been asked in "MariaDB community" by glennbaker1:
> --------------------------------
> Hello I'm new to mariadb and currently establishing openstack.  I'm investigating an issue and I'm hoping the community can help me resolve the following error.  I have increased the limits.conf and restarted mariadb however it doesn't appear to have resolved the problem as suggested in various posts I have read.
> 
> Error from log
> 
> 40917 15:40:19 [Warning] option 'open_files_limit': unsigned value 18446744073709551615 adjusted to 4294967295
> 140917 15:40:19 [Warning] Could not increase number of max_open_files to more than 1024 (request: 1835)

with systemd you can just set "LimitNOFILE=infinity"

[root@srv-rhsoft:~]$ cat /usr/lib/systemd/system/mysqld.service
[Unit]
Description=MariaDB Database
Before=postfix.service dovecot.service dbmail-imapd.service dbmail-lmtpd.service dbmail-pop3d.service

[Service]
Type=simple
User=mysql
Group=mysql
NoNewPrivileges=yes
ExecStart=/usr/libexec/mysqld --defaults-file=/etc/my.cnf --pid-file=/run/mysqld/mysqld.pid
ExecStartPost=/usr/libexec/mysqld-wait-ready $MAINPID
Environment="LANG=en_GB.UTF-8"
Restart=always
RestartSec=1
TimeoutSec=300
LimitNOFILE=infinity
LimitMEMLOCK=infinity
OOMScoreAdjust=-1000
SysVStartPriority=64
PrivateTmp=true
CapabilityBoundingSet=~CAP_AUDIT_CONTROL CAP_AUDIT_WRITE CAP_DAC_OVERRIDE CAP_NET_ADMIN CAP_NET_BIND_SERVICE
CAP_SETGID CAP_SETUID CAP_SYS_ADMIN CAP_SYS_BOOT CAP_SYS_MODULE CAP_SYS_PTRACE
ReadOnlyDirectories=/etc
ReadOnlyDirectories=/usr
ReadOnlyDirectories=/proc
ReadOnlyDirectories=/sys
ReadOnlyDirectories=/var/lib
ReadWriteDirectories=/var/lib/mysql
InaccessibleDirectories=/boot

InaccessibleDirectories=/home

InaccessibleDirectories=/root

InaccessibleDirectories=/media

[Install]
WantedBy=multi-user.target

Attachment: signature.asc
Description: OpenPGP digital signature


References