MySQL Warning like: Could not increase number of max_open_files to more than 65536
cat /etc/my.cnf |grep open_files_limit open_files_limit=73461 But MySQL still shows 65536
MariaDB [(none)]> SHOW VARIABLES LIKE 'open_files_limit'; +------------------+--------+ | Variable_name | Value | +------------------+--------+ | open_files_limit | 65536 | +------------------+--------+ 1 row in set (0.00 sec)
Try to update next files:
/etc/systemd/system/mariadb.service.d/migrated-from-my.cnf-settings.conf
/etc/systemd/system/mysqld.service.d/limits.conf
With the following:
LimitNOFILE=100000 LimitMEMLOCK=100000
MariaDB [(none)]> SHOW VARIABLES LIKE 'open_files_limit'; +------------------+--------+ | Variable_name | Value | +------------------+--------+ | open_files_limit | 100000 | +------------------+--------+ 1 row in set (0.00 sec)
Infinity as value is not good solution as it catches another hard limit in 65536
systemctl daemon-reload systemctl restart mysql