½â¾öUbuntuÏÂÐÞ¸Ämysql open_files_limit ֵʧЧ

1. Open /lib/systemd/system/mysql.service as super user
2. Add the following lines to the end of it:

LimitNOFILE=infinity
LimitMEMLOCK=infinity

3. Execute sudo systemctl daemon-reload

4. Restart mysql.