啟動mariadb，查看mariadb狀態資訊時：
systemctl start mariadb
systemctl -l status mariadb
報錯
[Warning] Could not increase number of max_open_files to more than 1024 (request: 8131)
[Warning] Changed limits: max_open_files: 1024 max_connections: 594 (was 4096) table_cache: 200 (was 2000)
出現警告資訊：提示最大打開檔案數不能超過1024，但依然能夠啟動mariaDB，
解決方法
- cat /usr/lib/systemd/system/mariadb.service 查看資訊
14 # For example, if you want to increase mysql's open-files-limit to 10000,
15 # you need to increase systemd's LimitNOFILE setting, so create a file named
16 # "/etc/systemd/system/mariadb.service.d/limits.conf" containing:
17 # [Service]
18 # LimitNOFILE=10000
- 根據前面的資訊
mkdir /etc/systemd/system/mariadb.service.d
vim /etc/systemd/system/mariadb.service.d/limits.conf ' //添加 '
[Service]
LimitNOFILE=10000 ' //根據前面的warning資訊，數值只需要大于8131即可，還可以改為infinity '
- 修改完之后，重新加載配置
systemctl --system-daemon-reload
已解決
如圖：
拓展
ulimit -n 查看當前行程的max_open_files
cat /proc/sys/fs/file-max 查看系統最大檔案數
/etc/security/limits.conf是一個很重要的檔案
轉載請註明出處，本文鏈接：https://www.uj5u.com/qita/252057.html
標籤：其他