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

请使用浏览器的分享功能分享到微信等