Re: 1135 Can't create a new thread (errno 11)...

[Wagner Bianchi]

Remembering what the online manual says about the max_user_connections, "A value of 0 (the default) means “no limit.”"

my.cnf now:


[root@bd7 ~]# 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=0
--innodb_log_file_size=768M
--innodb_log_files_in_group=4
--innodb_log_buffer_size=128M

and the test results...

[...]

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: 4.211 seconds
Minimum number of seconds to run all queries: 4.211 seconds
Maximum number of seconds to run all queries: 4.211 seconds
Number of clients running queries: 1200
Average number of queries per client: 0

Keep track this operations with MySQL Enterprise Monitor, I saw those connections, but just 1008 threads. The rest may be in aborted_connects...

Server version: 5.5.17 MySQL Community Server (GPL)

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

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

I will carry on testing...you're welcome to contribute in order to make MySQL scale more then this...

Wagner Bianchi - [phone]
Profile: bit.ly/toG94v
Blog: wagnerbianchi.com/blog
Twitter: @wagnerbianchijr
Skype: wbianchijr



Edited 1 time(s). Last edit at 12/17/2011 09:08AM by Wagner Bianchi.