Fix MySQL "[ERROR] : Too many open files" on start

解决方法参考地址
https://gist.github.com/fedir/a02d87a2f4ea53a961fe25256961bfdf

Check system limtis

cat /proc/$(cat /var/run/mysqld/mysqld.pid)/limits

Update system limits

$ vim /etc/security/limits.conf

最后加上

mysql soft nofile 65535
mysql hard nofile 65535

重启服务器

$ reboot

添加文件

$ mkdir -p /etc/systemd/system/mysql.service.d/
$ vim /etc/systemd/system/mysql.service.d/limits.conf

填写如下内容

[Service]
LimitNOFILE=infinity

启动

$ systemctl daemon-reload
$ systemctl restart mysqld

Check system limtis again

cat /proc/$(cat /var/run/mysqld/mysqld.pid)/limits