1,修改mysql配置
vim /etc/mysql/mysql.conf.d/mysqld.cnf
添加或修改
max_connections = 2000
2,修改文件句柄数
vim /etc/security/limits.conf
添加或修改
* soft nofile 65535
* hard nofile 65535
3,更改 MySQL 最大文件描述符限制
vim /lib/systemd/system/mysql.service
添加或修改
LimitNOFILE=infinity
LimitNPROC=infinity
4,重启服务
systemctl daemon-reload
systemctl restart mysql.service