Tag Archives: “Could not increase number of max_open_files to more than 1024 (request: 5035)”

[Solved] Mariadb Start Error: Could not increase number of max_open_files to more than 1024 (request: 5035)

Fault screenshot

Solution:

vim /usr/lib/systemd/system/mariadb.service
#Addn below the [service]

[Service]
LimitNOFILE=infinity

verification

systemctl daemon-reload
systemctl   restart  mariadb
systemctl   status   mariadb

expand
MySQL reported an error “Could not increase number of max_open_files to more than 1024”
Modify kernel parameters

 vim /etc/security/limits.conf

*               soft    nofile          8192
*               hard    nofile          8192

Restart the system or temporarily modify kernel parameters

 # ulimit -n 8192
 systemctl   restart  mysqld