Can’t create thread to handle new connection(errno= 11)

Hi Team,
I am getting below error in mysql 8.

OS : Ubuntu 8

2021-04-05T23:57:39.048571Z 0 [ERROR] [MY-010249] [Server] Can’t create thread to handle new connection(errno= 11)
2021-04-05T23:58:39.156526Z 0 [ERROR] [MY-000000] [connection_h] Error log throttle: 530 ‘Can’t create thread to handle new connection’ error(s) suppressed
2021-04-05T23:58:39.156554Z 0 [ERROR] [MY-010249] [Server] Can’t create thread to handle new connection(errno= 11)
2021-04-05T23:59:39.158128Z 0 [ERROR] [MY-000000] [connection_h] Error log throttle: 509 ‘Can’t create thread to handle new connection’ error(s) suppressed
2021-04-05T23:59:39.158155Z 0 [ERROR] [MY-010249] [Server] Can’t create thread to handle new connection(errno= 11)
2021-04-06T00:00:00.541130Z 5 [ERROR] [MY-010053] [Server] Event_scheduler::execute_top: Can not create event worker thread (errno=11). Stopping event scheduler

i have below setting .

[mysqld]
max_connect_errors=2000
max_connections=5000
#max_user_connections=500
open_files_limit=100000
key_buffer_size=48M
max_allowed_packet=96M
thread_stack=768K
thread_cache_size=150
max_binlog_size=1000M
max_heap_table_size=64M
table_open_cache=4000
sort_buffer_size=20M
tmp_table_size=10G
read_buffer_size=384K
read_rnd_buffer_size=768K
join_buffer_size=384K
innodb_data_file_path=ibdata1:75M:autoextend
innodb_temp_data_file_path=ibtmp1:75M:autoextend
sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION
lower_case_table_names=1
temptable_max_ram=5G

log-error = /var/log/mysqld.log

[mysqld_safe]
open_files_limit=8192
user =mysql
log-error = /var/log/mysqld.log

[mysqldump]
max_allowed_packet=96M

1 Like