centos mysql5.6.3 最大连接数设置无效问题

centos mysql最大连接数设置无效问题

解决方案

参考

https://www.oschina.net/question/853151_241231

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
$ systemctl restart  mysqld.service