Can't create a new thread (errno 11)

yybmsrs

failed: Can't create a new thread (errno 11); if you are not out of available memory, you can consult the manual for a possible OS-dependent bug


超过可用内存？这个内存是怎么算的呢？

my.cnf如下：
key_buffer = 384M
max_allowed_packet = 1M
table_cache =512
sort_buffer_size = 2M
read_buffer_size = 2M
read_rnd_buffer_size = 4M
myisam_sort_buffer_size = 64M
thread_cache = 8
query_cache_size= 32M
max_connections =   512
max_connect_errors = 128
max_error_count = 128

shawn53

假如你使用innodb引擎
mem=max_connections*（sort_buffer_size+join_buffer_size+read_buffer_size+read_rnd_buffer_size+thread_stack）

yybmsrs

回复 2# shawn53


    myisam呢

shawn53

回复 3# yybmsrs


    这是在假设全是innodb时候的一个估算，