How to increase open files limits for MariaDB

Eric Delorme

Introduction

The my.cnf setting for open_files_limit may not be taken as a variable and needs to be set via systemd.

Access the server via SSH as the root user
Create the limits file at the following path if it does not already exist:
```
/etc/systemd/system/mariadb.service.d/limits.conf
```
Paste the following into the file, setting the limit to your desired value:
```
[Service]
LimitNOFILE=40000
```
If the following file exists, the same limit as above must be added here as well:
```
/etc/systemd/system/mariadb.service.d/migrated-from-my.cnf-settings.conf
```
Reload the daemons to apply the setting:
```
systemctl daemon-reload
```
Restart the MariaDB service to update the changes:
```
/scripts/restartsrv_mysql
```