原文是:http://stackoverflow.com/questions/32760202/buffered-warning-changed-limits-max-connections-214-requested-800
总结:
排除是my.cnf路径不对的问题,可能是系统限制了文件打开数量,主要是改这2个地方:
append these two lines to /etc/security/limits.conf
mysql hard nofile 65535
mysql soft nofile 65535
append this line to /usr/lib/systemd/system/mysqld.service (in the [service] section)
LimitNOFILE=65535