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 值失效
最新推荐文章于 2025-07-04 17:30:19 发布