Hi, Since you are using LXC, you have to pass an option to change the limit. For docker: docker run --name mariadb --ulimit nofile=65535:65535 mariadb:10.1.35 In LXC: lxc config set mariadb limits.kernel.nofile 65535 -GL Le ven. 2 nov. 2018 à 12:07, <c.monty@web.de> a écrit :
Hi, I have installed MariaDB 10.1.35 in a container (LXC) with Debian 9.5.
Starting the database service I get this warning: Nov 02 03:23:50 ct125-netdot mysqld[25687]: 2018-11-02 3:23:50 140396535071680 [Warning] Could not increase number of max_open_files to more than 4096 (request: 4182)
MariaDB [(none)]> SHOW GLOBAL VARIABLES LIKE 'open_files_limit'; +------------------+-------+ | Variable_name | Value | +------------------+-------+ | open_files_limit | 4096 | +------------------+-------+ 1 row in set (0.00 sec)
Checking MariaDB documentation "Server System Variables" here ( https://mariadb.com/kb/en/library/server-system-variables/#open_files_limit) I get this info: open_files_limit
- *Description:* The number of file descriptors available to mysqld. Increase if you are getting the Too many open files error. If set to 0, then mysqld will reserve max_connections <https://mariadb.com/kb/en/library/server-system-variables/#max_connections>*5 or max_connections <https://mariadb.com/kb/en/library/server-system-variables/#max_connections> + table_open_cache <https://mariadb.com/kb/en/library/server-system-variables/#table_open_cache>*2 (whichever is larger) number of files. Note that MariaDB cannot set this to exceed the hard limit imposed by the operating system, and you may need to change this. For example, by adding the following lines to /etc/security/limits.conf
mysql soft nofile 65535 mysql hard nofile 65535
rebooting, and then create /etc/systemd/system/mysqld.service.d/filelimit.conf or /etc/systemd/system/mariadb.service.d/filelimit.conf (corresponding to the service name).
[Service] LimitNOFILE=infinity
I have modified file /etc/security/limits.conf accordingly: mysql soft nofile 4182 mysql hard nofile 4182
And I have create file /etc/systemd/system/mariadb.service.d/filelimit.conf: root@ct125-netdot:~# more /etc/systemd/system/mariadb.service.d/filelimit.conf [Service] LimitNOFILE=4182
Why is MariaDB writing this warning?
THX
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp