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

报错信息：

 
 
 

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

解决办法：

 
 
 

# 查看限制情况
  
  
  
[root@SLAVE_115_28_222_53 ~]# cat /proc/`pidof mysqld`/limits | egrep "(processes|files)"
  
  
  
Max processes 1024 unlimited processes
  
  
  
Max open files 160000 160000 files
  
  
  

  
  
  
### 解决办法
  
  
  
# 调整当前mysqld限制
  
  
  
[root@localhost ~]# echo -n "Max processes=514857:514857" > /proc/`pidof mysqld`/limits
  
  
  

  
  
  
# 配置文件，增加配置
  
  
  
# vim /etc/security/limits.d/90-nproc.conf
  
  
  
mysql soft nproc 514857 # 添加这行
  
  
  

  
  
  
解决办法参考：http://blog.itpub.net/26250550/viewspace-1687922/
 
 
 

来自为知笔记(Wiz)