Tag: open_files_limit

Centos 7 systemd increase MySQL open_files_limit

1241  admin  
(last edited )

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… Read the rest