MySQL Forums :: Performance :: 1135 Can't create a new thread (errno 11)...


Advanced Search

Re: 1135 Can't create a new thread (errno 11)...
Posted by: Wagner Bianchi ()
Date: December 16, 2011 11:05AM

Just adding new possibilities, I reconfigured the Linux limits.conf:

mysql soft nofile 10240
mysql hard nofile 40960
mysql soft nproc 10240
mysql hard nproc 40960

...change the thread-max value too...

echo "2065067" > /proc/sys/kernel/threads-max

restart the machine server and try again:


[root@bd7 mysql]# my_print_defaults mysqld
--skip-name-resolve
--skip-external-locking
--port=3306
--socket=/var/lib/mysql/mysql.sock
--query_cache_type=0
--query_cache_size=0
--max_connections=6000
--max_user_connections=2000
[root@bd7 mysql]# mysqlslap --user=root --auto-generate-sql --concurrency=100,200,300,400,500,1000,1200 --number-of-queries=1

[...]

mysqlslap: Error when connecting to server: 1135 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
mysqlslap: Error when connecting to server: 1135 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
mysqlslap: Error when connecting to server: 1135 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
mysqlslap: Error when connecting to server: 1135 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
mysqlslap: Error when connecting to server: 1135 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
mysqlslap: Error when connecting to server: 1135 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
mysqlslap: Error when connecting to server: 1135 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
mysqlslap: Error when connecting to server: 1135 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
mysqlslap: Error when connecting to server: 1135 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
mysqlslap: Error when connecting to server: 1135 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
mysqlslap: Error when connecting to server: 1135 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
mysqlslap: Error when connecting to server: 1135 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
mysqlslap: Error when connecting to server: 1135 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
mysqlslap: Error when connecting to server: 1135 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
Benchmark
Average number of seconds to run all queries: 2.770 seconds
Minimum number of seconds to run all queries: 2.770 seconds
Maximum number of seconds to run all queries: 2.770 seconds
Number of clients running queries: 1200
Average number of queries per client: 0

Again...

mysql> show status like 'Aborted_connects';
+------------------+-------+
| Variable_name | Value |
+------------------+-------+
| Aborted_connects | 621 |
+------------------+-------+
1 row in set (0.00 sec)

Any suggestions to solve this problem?

Wagner Bianchi - +55 31 8654-9510
Profile: bit.ly/toG94v
Blog: wagnerbianchi.com/blog
Twitter: @wagnerbianchijr
Skype: wbianchijr

Options: ReplyQuote


Subject Views Written By Posted
1135 Can't create a new thread (errno 11)... 10442 Wagner Bianchi 12/16/2011 10:58AM
Re: 1135 Can't create a new thread (errno 11)... 18338 Wagner Bianchi 12/16/2011 11:05AM
Re: 1135 Can't create a new thread (errno 11)... 4877 Wagner Bianchi 12/17/2011 09:07AM
Re: 1135 Can't create a new thread (errno 11)... 3999 Wagner Bianchi 12/17/2011 10:06AM
Re: 1135 Can't create a new thread (errno 11)... 3122 Rick James 12/17/2011 10:57AM
Re: 1135 Can't create a new thread (errno 11)... 2573 Wagner Bianchi 12/17/2011 04:02PM
Re: 1135 Can't create a new thread (errno 11)... 2888 Wagner Bianchi 12/20/2011 08:51AM
Re: 1135 Can't create a new thread (errno 11)... 3063 Rick James 12/22/2011 08:27PM
Re: 1135 Can't create a new thread (errno 11)... 4525 Tijl Deneut 01/04/2012 11:21AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.