Increase limits - percona 5.7, centos 7.2

Edit /etc/security/limits.conf and add the following lines mysql soft nofile 65535  mysql hard nofile 65535 Edit /usr/lib/systemd/system/mysqld.service and add LimitNOFILE=infinity  LimitMEMLOCK=infinity Then run systemctl daemon-reload and systemctl restart mysql.service.