MySQL 5 on CentOS 7 解決 Could not increase number of max_open_files to more than 1024 (request: 1024000)

在CentOS 7 除了 1.要調整/etc/security/limits.conf 的nproc, nofile 以外 mysql soft nofile 65535 mysql hard nofile 65535 mysql soft nproc 65535 mysql hard nproc 65535 2.要加兩個參數到mysql.service設定檔 LimitNOFILE=infinity LimitMEMLOCK=infinity 3.重啟動daemon systemctl daemon-reload systemctl restart mysql.service

才不會在mysql.err 看到

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

這樣的錯誤訊息 ref: https://www.securityinet.com/cloudlinux-7-mysql-open_files_limit-and-max_open_files-setup/