报错信息:

  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
  5. ### 解决办法
  6. # 调整当前mysqld限制
  7. [root@localhost ~]# echo -n "Max processes=514857:514857" > /proc/`pidof mysqld`/limits
  8. # 配置文件,增加配置
  9. # vim /etc/security/limits.d/90-nproc.conf
  10. mysql soft nproc 514857 # 添加这行
  11. 解决办法参考:http://blog.itpub.net/26250550/viewspace-1687922/
05-11 17:25