Centos 7 systemd increase MySQL open_files_limit

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

Similar Posts:

Leave a Reply

Your email address will not be published. Required fields are marked *