在 MySQL 日志中出现如下警告信息:

[Warning] Buffered warning: Could not increase number of max_open_files to more than 1024 (request: 65535)

解决方法:

sudo cp /lib/systemd/system/mysql.service /etc/systemd/system/
sudo vim /etc/systemd/system/mysql.service
……

阅读全文