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

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

 

mysql所在系统参数设置太小导致。
系统root账号ulimit -a 查看参数设置都挺大的，但是切换到mysql账号下Max processes=1024

1、修改配置文件参数 vi /etc/security/limits.d/90-nproc.conf
　　*          soft    nproc     1024  改成65535

　　只是修改了系统参数的值，进程的值都得修改。

2、

cat /proc/299474/limits | egrep "(processes|files)"
cat /proc/[pid]/limits
echo -n "Max processes=204800:204800"> /proc/pid/limits
echo -n "Max processes=65535:65535"> /proc/234072/limits