Troubleshooting

Navigation:  MySQL Governor >

Troubleshooting

Previous pageReturn to chapter overviewNext page

MariaDB 5.5 and MariaDB 10.0: How to set LimitNOFILE correctly for systemd.

 

MariaDB 5.5 and MariaDB 10.0 have only /etc/init.d/mysql file for managing the service, but the file has LSB functions, so it is supported by systemd.

 

For adding extra limits, do the following:

 

1. Run:

 

mkdir /etc/systemd/system/mariadb.service.d/

 

2. Run:

 

touch /etc/systemd/system/mariadb.service.d/limits.conf

 

3. Add the following content to the the file /etc/systemd/system/mariadb.service.d/limits.conf:

 

[Service] 

LimitNOFILE=99999