mysql-error --(ERROR 1135 (HY000): Can't create a new thread (errno 11); if you are not out)

报错信息：

1. ERROR 1135 (HY000): Can't create a new thread (errno 11); if you are not out

解决办法：

1. # 查看限制情况
2. [root@SLAVE_115_28_222_53 ~]# cat /proc/`pidof mysqld`/limits | egrep "(processes|files)"
3. Max processes 1024 unlimited processes
4. Max open files 160000 160000 files
6. ### 解决办法
7. # 调整当前mysqld限制
8. [root@localhost ~]# echo -n "Max processes=514857:514857" > /proc/`pidof mysqld`/limits
10. # 配置文件，增加配置
11. # vim /etc/security/limits.d/90-nproc.conf
12. mysql soft nproc 514857 # 添加这行
14. 解决办法参考：http://blog.itpub.net/26250550/viewspace-1687922/

来自为知笔记(Wiz)

转载于:https://www.cnblogs.com/CongZhang/p/5320470.html