back to posts

MySQL / MariaDB max_open_files more than 1024

For me the issue was MySQL max_open_files more than 1024

Edit /etc/security/limits.conf and add the following lines

mysql soft nofile 65535
mysql hard nofile 65535

then reboot.

Then edit /etc/systemd/system/mysqld.service and add


Then restart the db service:

sudo systemctl reload mariadb.service

If you found it useful, please consider signing up to my newsletter. Every week, I share my thoughts on cool stuff I found around the internet. No spam, ever. Unsubscribe any time.