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.
解决Ubuntu下修改mysql open_files_limit 值失效
最新推荐文章于 2022-12-02 15:49:38 发布