MySQL max_connections 设置没用 总是 200多 解决

It was indeed limits set by the OS. Resolved it with :

Edit file /usr/lib/systemd/system/mysqld.service
Add at end:

LimitNOFILE=65535
LimitNPROC=65535

$ systemctl daemon-reload

启动mysql
$ systemctl restart  mysqld.service  或 service mysql start

posted on 2018-03-20 11:30  --LP--  阅读(401)  评论(0编辑  收藏  举报

导航