解决Ubuntu下修改mysql open_files_limit 值失效

1. Open /lib/systemd/system/mysql.service as super user2. Add the following lines to the end of it:LimitNOFILE=infinityLimitMEMLOCK=infinity3. Execute sudo systemctl daemon-reload4. Restart mysql.