mysql increase open file limit; [ERROR] Error in accept: Too many open files

[ERROR] Error in accept: Too many open files

[mysqld]
open_files_limit = 1000000

/etc/security/limits.conf:
mysql soft nofile 1000000
mysql hard nofile 1000000

mysql -e "show global variables like 'open%';"

Leave a Reply

Your email address will not be published. Required fields are marked *