Skip to content

Instantly share code, notes, and snippets.

@leewin12

leewin12/mysql.service

Created September 6, 2019 13:01
Show Gist options
  • Save leewin12/119c7189440a506b38a0242bccff21c7 to your computer and use it in GitHub Desktop.
Save leewin12/119c7189440a506b38a0242bccff21c7 to your computer and use it in GitHub Desktop.
Download ZIP
Percona MySQL 5.7.x limits config
Raw
mysql.service
$ vim /etc/systemd/system/mysql.service
[Service]
LimitNOFILE = infinity
LimitCore = infinity
LimitMEMLOCK = infinity
$ systemctl daemon-reload
$ service mysql restart
$ ps -ef | grep mysql | awk '{print $2}' | head -n1 | xargs -I{} cat /proc/{}/limits
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment