maiadb [ERROR] Error in accept: Too many open files

 tail mariadb.log 

210214 19:12:44 [ERROR] Error in accept: Too many open files

210215  2:26:23 [ERROR] Error in accept: Too many open files

 

 

show variables like 'open_files_limit';

+------------------+-------+

| Variable_name    | Value |

+------------------+-------+

| open_files_limit | 1024  |

+------------------+-------+

 

my.cnf 

==========추가 

[mysqld]

open_files_limit=10000

============================================== 

/etc/systemd/system/multi-user.target.wants/mariadb.service 

 

[Service]

LimitNOFILE=10000

================================

위 경로에 mariadb.service  이 없으면 

찾아보면 /usr/lib 에 있다. 

 

find / -name mariadb.service

/sys/fs/cgroup/systemd/system.slice/mariadb.service

/usr/lib/systemd/system/mariadb.service

 

systemctl daemon-reload

systemctl restart mariadb