Limits für Mariadb erhöhen

https://support.plesk.com/hc/en-us/articles/213938885-Plesk-or-website-are-not-working-Unable-to-connect-to-database-MySQL-server-has-gone-away-Full-server-backup-is-created-with-warning-errno-24-Too-many-open-files

Fehler

ERROR: Plesk\Exception\Database: DB query failed: SQLSTATE[HY000]: General error: 23 Out of resources when opening file '/var/tmp/#sql_5fc_0.MAI' (Errcode: 24), query was: DESCRIBE `sessions`

Hier die Lösung in Skript Form:

#!/bin/bash

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

echo '[Service]

LimitNOFILE=65534' > /etc/systemd/system/mariadb.service.d/limits.conf

systemctl daemon-reload

systemctl restart mariadb