ERROR 1135 (HY000): Can't create a new thread (errno 11)
from:
https://www.percona.com/blog/2013/02/04/cant_create_thread_errno_11/
错误信息
ERROR 1135 (HY000): 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
# 查看限制情况
[root@localhost ~]# cat /proc/`pidof mysqld`/limits | egrep "(processes|files)"
Max processes 1024 514857 processes
Max open files 65535 65535 files
### 解决办法
# 调整当前mysqld限制
[root@localhost ~]# echo -n "Max processes=514857:514857" > /proc/`pidof mysqld`/limits
# 配置文件，增加配置
# vim /etc/security/limits.d/90-nproc.conf
# add
mysql soft nproc 514857
https://www.percona.com/blog/2013/02/04/cant_create_thread_errno_11/
错误信息
ERROR 1135 (HY000): 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
# 查看限制情况
[root@localhost ~]# cat /proc/`pidof mysqld`/limits | egrep "(processes|files)"
Max processes 1024 514857 processes
Max open files 65535 65535 files
### 解决办法
# 调整当前mysqld限制
[root@localhost ~]# echo -n "Max processes=514857:514857" > /proc/`pidof mysqld`/limits
# 配置文件，增加配置
# vim /etc/security/limits.d/90-nproc.conf
# add
mysql soft nproc 514857
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/26250550/viewspace-1687922/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
