ulimit -a
mcedit /etc/sysctl.conf
add:
fs.file-max = 100000
mcedit /etc/security/limits.conf
add (before #end):
* soft nproc 65535
* hard nproc 65535
* soft nofile 65535
* hard nofile 65535
reload sysctl
sysctl -p
MariaDB
mcedit /usr/lib/systemd/system/mariadb.service add (at the end):
LimitNOFILE=65535
LimitNPROC=65535
systemctl daemon-reload
systemctl restart mysqld.service