How to increase open file limits for Mariadb?

Question

linux

Mar 20 09:59:54 localhost mariadbd: 2022-03-20  9:59:54 0 [Note] /usr/sbin/mariadbd (server 10.7.3-MariaDB-log) starting as process 46091 ...
Mar 20 09:59:54 localhost mariadbd: 2022-03-20  9:59:54 0 [Warning] Could not increase number of max_open_files to more than 32768 (request: 33035)

Help, how to increase the limit of open files for Mariadb?

Answer 1

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

cat > /etc/systemd/system/mariadb.service.d/override.conf <<EOF
LimitNOFILE=65535
LimitMEMLOCK=65535
EOF

systemctl daemon-reload

systemctl restart mariadb

Answer 2

Using ulimits you can increase the limit of open files