
mysql 启动会报如下警告,如何解决:
[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