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