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:
3. Add the following content to the the file /etc/systemd/system/mariadb.service.d/limits.conf: