MariaDB: Could not increase number of max_open_files to more than...

При запуске MariaBD выдает следующие предупреждения:

[Warning] Could not increase number of max_open_files to more than 16384 (request: 160184)
[Warning] Changed limits: max_open_files: 16384 max_connections: 151 (was 151) table_cache: 8101 (was 10000)

1 2	[Warning] Could not increase number of max_open_files to more than 16384 (request: 160184) [Warning] Changed limits: max_open_files: 16384 max_connections: 151 (was 151) table_cache: 8101 (was 10000)

Решением будет, поднять эти значения для демона.

необходимо проверить файлы ( при их наличии ) и проверить ограничения

/etc/systemd/system/mariadb.service.d/nofile.conf
/etc/systemd/system/mariadb.service.d/migrated-from-my.cnf-settings.conf
/etc/systemd/system/mysqld.service.d/limits.conf
/usr/lib/systemd/system/mariadb.service
/usr/lib/systemd/system/mariadb.service
/etc/systemd/system/mysql.service
/etc/systemd/system/mysqld.service

/etc/systemd/system/mariadb.service.d/nofile.conf

/etc/systemd/system/mariadb.service.d/migrated-from-my.cnf-settings.conf

/etc/systemd/system/mysqld.service.d/limits.conf

/usr/lib/systemd/system/mariadb.service

/etc/systemd/system/mysql.service

/etc/systemd/system/mysqld.service

найти надо следующие параметры:

LimitNOFILE= 
LimitMEMLOCK=

1 2	LimitNOFILE= LimitMEMLOCK=

Устанавливаем значения

[Service]
LimitNOFILE=infinity
LimitMEMLOCK=infinity

[Service]

LimitNOFILE=infinity

LimitMEMLOCK=infinity

и перезапускаем MaridDB

systemctl daemon-reload
systemctl restart mysql

1 2	systemctl daemon-reload systemctl restart mysql