looks like i (or ubuntu) have a problem to set ulimits for users ( not admin user ).
here is my configuration of limits.conf:
how to set the ulimit as admin for another user.
/etc/security/limits.conf seems not working ( even after reboot )
here my configuration of limits.conf
#<domain> <type> <item> <value>
#* soft core 0
I have successfully increased the nofile and nproc value for the local users, but I couldn't find a proper solution for the processes launched by systemd. Adding max_open_files to the MariaDB configuration doesn't help.