Thursday, February 11, 2016

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.



No comments:

Post a Comment

Cybermap

Internet Storm Center Infocon Status

Internet Storm Center Infocon Status
Internet Storm Center Infocon Status