TI - Tech 4.0 - Hacking

  MySQL Server Error – “Can’t Create A New Thread (errno 11)” by  admin OS error 11 is “Resource temporarily unavailable”. The most common cause of receiving this error when trying to create a new thread is having hit the process’s kernel enforced a limit on open file descriptors. The second most common cause is having hit the process’s kernel enforced limit on the number of processes/threads. Here are the factors involved: The system-wide limits: sysctl -e fs.file-max && sysctl -e kernel.threads-max The per-process limits (in a *new* shell): ulimit -n, grep nofile /etc/security/limits.conf and ulimit -u, grep nproc /etc/security/limits.conf. The open_files_limit setting in mysqld (mysql> show global variables like “open_files_limit”;). The other settings within mysqld that can affect the number of open FDs and threads that the process may use (max_connections, thread_cache_size, table_open_cache, table_definition_cache, innodb_open_files, etc.) Assuming that it was...