[Warning] Buffered warning: Changed limits: max_open_files: 1024 (requested 5000)

[Warning] Buffered warning: Changed limits: table_open_cache: 431 (requested 2000)

在/usr/lib/systemd/system/mysqld.service的[service]下添加如下行：

LimitNOFILE=65535

debian中文件是：/etc/systemd/system/multi-user.target.wants/mysql.service