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


Then run systemctl daemon-reload and systemctl restart mysql.service.


Popular posts from this blog

How to clean DB from old logs in Magento 1.x

Securing the Pi-hole with fail2ban to prevent DNS Amplification attacks

Apache 2.4 + mod_wsgi + Python 3.7 + Django installation on Centos 7.10