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 值失效
最新推荐文章于 2024-07-05 14:28:22 发布