mariadb启动报错“Could not increase number of max_open_files to more than 1024 (request: 5035)”

故障截图

解决办法

vim /usr/lib/systemd/system/mariadb.service
#在[service]下面加

[Service]
LimitNOFILE=infinity

验证

systemctl daemon-reload
systemctl   restart  mariadb
systemctl   status   mariadb

 

 

拓展
MySQL报错 “Could not increase number of max_open_files to more than 1024“

修改内核参数

 vim /etc/security/limits.conf

*               soft    nofile          8192
*               hard    nofile          8192

重启系统或临时修改内核参数

 # ulimit -n 8192
 systemctl   restart  mysqld