Increase open-files-limit in MariaDB on CentOS 7 with systemd

搬运工

1. mkdir -p /etc/systemd/system/mariadb.service.d/
   
2. vim /etc/systemd/system/mariadb.service.d/limits.conf
   
3. [Service]
   
4. LimitNOFILE=20000

复制代码

1. systemctl daemon-reload
   
2. systemctl restart mariadb
   

复制代码

1. show global variables like 'open%';

复制代码