RHEL 7 increase number of open files for given service

How do I set limits for services such as mysqld (mariadb server) in RHEL 7 when systemd used?


Linux sysadmin blog - Linux/Unix Howtos and Tutorials - Linux bash shell scripting wiki