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

I'm opening a new topic with the same name because the other was closed too earlier. Just now, I am running two MySQL servers version 5.5.17 with the same problem when reach 1000 connections or more. This case is so serious and I have a cloud server with the same hardware of those both servers just to test it in order to discover the problem.

So, this test environment is running on Red Hat Linux, with MySQL 5.5.17 with default configuration, just have configured *max_connections*, *max_user_connections* and InnoDB logs to reach that number of concurrent operations (this box has 24GB RAM and MySQL Instance have been used only by this test).

[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
--lower_case_table_names=1
--max_connections=6000
--max_user_connections=2000
--thread_concurrency=8
--binlog_format=mixed
--server-id=2
--max_binlog_size=128M
--expire_logs_days=2
--relay-log=relay-log
--relay-log-index=relay-log.index
--relay-log-purge=1
--relay-log-space-limit=256M
--innodb_buffer_pool_size=16G
--innodb_buffer_pool_instances=8
--innodb_additional_mem_pool_size=64M
--innodb_log_file_size=768M
--innodb_log_files_in_group=4
--innodb_file_format=BARRACUDA
--innodb_file_per_table=1

As long as I was running the mysqlslap to simulate connections, I was enabling the options from the configuration file (my.cnf). I got errors just when I enable those variables:

--innodb_write_io_threads=8
--innodb_read_io_threads=8

After configure them, restarted the MySQL server, the mysqlslap has resulted in...

[root@bd7 ~]# mysqlslap --user=root --auto-generate-sql --concurrency=100,200,300,400,500,1000 --number-of-queries=1
Benchmark
Average number of seconds to run all queries: 0.724 seconds
Minimum number of seconds to run all queries: 0.724 seconds
Maximum number of seconds to run all queries: 0.724 seconds
Number of clients running queries: 100
Average number of queries per client: 0

Benchmark
Average number of seconds to run all queries: 1.420 seconds
Minimum number of seconds to run all queries: 1.420 seconds
Maximum number of seconds to run all queries: 1.420 seconds
Number of clients running queries: 200
Average number of queries per client: 0

Benchmark
Average number of seconds to run all queries: 2.704 seconds
Minimum number of seconds to run all queries: 2.704 seconds
Maximum number of seconds to run all queries: 2.704 seconds
Number of clients running queries: 300
Average number of queries per client: 0

Benchmark
Average number of seconds to run all queries: 5.108 seconds
Minimum number of seconds to run all queries: 5.108 seconds
Maximum number of seconds to run all queries: 5.108 seconds
Number of clients running queries: 400
Average number of queries per client: 0

Benchmark
Average number of seconds to run all queries: 5.289 seconds
Minimum number of seconds to run all queries: 5.289 seconds
Maximum number of seconds to run all queries: 5.289 seconds
Number of clients running queries: 500
Average number of queries per client: 0

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

When I let those variables with your default values, MySQL didn't claim about connections any more:

--innodb_write_io_threads=4
--innodb_read_io_threads=4

[root@bd7 ~]# mysqlslap --user=root --auto-generate-sql --concurrency=100,200,300,400,500,1000 --number-of-queries=1
Benchmark
Average number of seconds to run all queries: 0.742 seconds
Minimum number of seconds to run all queries: 0.742 seconds
Maximum number of seconds to run all queries: 0.742 seconds
Number of clients running queries: 100
Average number of queries per client: 0

Benchmark
Average number of seconds to run all queries: 1.739 seconds
Minimum number of seconds to run all queries: 1.739 seconds
Maximum number of seconds to run all queries: 1.739 seconds
Number of clients running queries: 200
Average number of queries per client: 0

Benchmark
Average number of seconds to run all queries: 4.952 seconds
Minimum number of seconds to run all queries: 4.952 seconds
Maximum number of seconds to run all queries: 4.952 seconds
Number of clients running queries: 300
Average number of queries per client: 0

Benchmark
Average number of seconds to run all queries: 3.028 seconds
Minimum number of seconds to run all queries: 3.028 seconds
Maximum number of seconds to run all queries: 3.028 seconds
Number of clients running queries: 400
Average number of queries per client: 0

Benchmark
Average number of seconds to run all queries: 4.567 seconds
Minimum number of seconds to run all queries: 4.567 seconds
Maximum number of seconds to run all queries: 4.567 seconds
Number of clients running queries: 500
Average number of queries per client: 0

Benchmark
Average number of seconds to run all queries: 6.131 seconds
Minimum number of seconds to run all queries: 6.131 seconds
Maximum number of seconds to run all queries: 6.131 seconds
Number of clients running queries: 1000
Average number of queries per client: 0

But, even I run MySQL with default values, I have been getting that error when I set the concurrency = 1200...

[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

[...]

mysqlslap: Error when connecting to server: 2001 Can't create UNIX socket (24)
mysqlslap: Error when connecting to server: 2001 Can't create UNIX socket (24)
mysqlslap: Error when connecting to server: 2001 Can't create UNIX socket (24)
mysqlslap: Error when connecting to server: 2001 Can't create UNIX socket (24)
mysqlslap: Error when connecting to server: 2001 Can't create UNIX socket (24)
mysqlslap: Error when connecting to server: 2001 Can't create UNIX socket (24)
mysqlslap: Error when connecting to server: 2001 Can't create UNIX socket (24)
mysqlslap: Error when connecting to server: 2001 Can't create UNIX socket (24)
mysqlslap: Error when connecting to server: 2001 Can't create UNIX socket (24)
mysqlslap: Error when connecting to server: 2001 Can't create UNIX socket (24)
mysqlslap: Error when connecting to server: 2001 Can't create UNIX socket (24)
mysqlslap: Error when connecting to server: 2001 Can't create UNIX socket (24)

[...]

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

Look what happened with Aborted_Connects...

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

Any advise on this? Thanks for the advice...

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

Edited 4 time(s). Last edit at 12/16/2011 11:42AM by Wagner Bianchi.

Warning: mysql_pconnect() [function.mysql-pconnect]: Can't create a new thread (errno 12)

- I am running MySQL 5.0.45 on Windows Server 2003 / 2GB of Memory / Intel Core 2 @ 2.66Mhz. I am getting lots of errors and I need help: Warning: mysql_pconnect() [function.mysql-pconnect]: Can't create a new thread (errno 12); if you are not out of available memory, you can consult the manual for ...

MySQL Can't create a new thread (errno 35).

I encountering this error : "Can't create a new thread (errno 35). If you are not out of available memory, you can consult the manual for a possible OS-dependent bug" Given below are the details of our db server and the mysql config Server: Windows Server 2003 Intel Xeon RAM 18G MySQL Vari ...

MySQL error 1135, can't create a new thread

OS:windows enterprise 2003 max_connections=700 mysql startup normally when I created a new connection to MYSQL which configed 'thread_connected=70' , it throw exception 'error 1135, can't create a new thread'. After I tried many times, I found the problem was made by windows2003 system which limited ...

Warning: mysql_pconnect() [function.mysql-pconnect]: Can't create a new thread (errno 12); if you are not out of available memory, you can consult the manual for a possible OS-dependent bug in

- I am running MySQL 5.0.45 on Windows Server 2003 / 2GB of Memory / Intel Core 2 @ 2.66Mhz. I am getting lots of errors and I need help: Warning: mysql_pconnect() [function.mysql-pconnect]: Can't create a new thread (errno 12); if you are not out of available memory, you can consult the manual for ...

Can't create a new thread (errno 12); if you are not out of available memory, you can consult the manual for a possible OS-dependent bug: in rails and mysql environment in linux

Yesterday I was facing the problem with Mysql, It throws an error in every rails request, Can't create a new thread (errno 12); if you are not out of available memory, you can consult the manual for a possible OS-dependent bug. Environment: Linux, Mysql and Ruby On Rails. And I looked at mysql error ...

MySQL #1005 - Can't create table '.\catalog\address_book.frm' (errno: 121)

I was just wondering if anyone could help me, i have a database that is very touchy... it will go into the server sometimes and others no. However on my local machine and testing machines i can put this database in no worries! im running MYSQL 4.1.18nt-max Via TCP/IP and the server is using 4.1.1.14 ...

MySQL Can't create table xxx (errno: 150)

folks, I'm trying to create a table with two foreign keys that references two separate tables, but it gives me the above error "(errno: 150)". Here's my SQL code; if I take away the "constraint" part for the last two lines, everything works fine. Is there something wrong with my ...

MySQL can create this table errno 150

CREATE TABLE `floricolor`.`impressao` ( `imp_Id` int(11) NOT NULL AUTO_INCREMENT, `imp_gui_Id` int(11) DEFAULT NULL, `imp_tim_Id` int(11) NOT NULL, `imp_Date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`imp_Id`), KEY `imp_tim_Id_2` (`imp_tim_Id`), KEY `imp ...

MySQL Can't create new thread error

I have an application running phpv4X and mysqlv4 Within a few minutes of testing, I will easily get this warning -- Warning: mysql_connect(): Can't create a new thread (errno 11). -- What could be the problem? I have set memory_limit in php.ini = 512M and also increased mysql "max_allowed_packe ...

Does anyone know how to solve: Can't creat a new thread (errno 1) when login to mysql

After installed the binary version of 4.1.18 in IRIX 6.5.29 and sucessfully loaded the mysqld daemon, the error message shown: Can't create a new thread( errno1 ); if you are not out of available memory, you can consult the manual for a possible OS-Dependent bug. Feel very much appreciate if anyone ...

MySQL Error 1005 Can't create table .frm errno 150

I am a MySQL newbie. I created 3 tables in a database called "link_development" using MySQL Administrator 1.9.1 and MySL Server 5.0.18 32bit Windows. I originally named the primary key field link_development.links.linkid, but Ruby prefers just using "id" for primary key field nam ...

MySQL Can't create temporary table (errno:135)

My application got the following error when trying to create a temporary table: Can't create table '/tmp/#sql5ae_28_1.frm' (errno: 135) The sql prepared statement to create the table is below: create temporary table foo select id from bar limit ?, ?; The database is InnoDB under mysql version 5.0.16 ...

MySQL Unable to create temporary file; errno: 2

I get the following error in my error log frequently. It may pop up when I access or set foreign key constraints, I'm not sure. InnoDB: Error: unable to create temporary file; errno: 2 After I get this error, I can no longer view any of the tables' foreign key constraints until I restart the server. ...

MySQL Not able to create this table with contraint = errno 105

I copied the SQL out of the MYSQL Workbench, but it doesn't appear to work for the second table. I even attempted to modify it a bit, but it will not create the table. Can someone provide assistance or know how to resolve this? I started with a simple example: Country Table (list of country codes an ...

Can't create a new thread (errno 12)...

I'm developing a website that uses PHP and MySQL. It has features such as users registering and logging in, and sending posts and private messages etc.The database so far is small (a handful of test data)...I'm running an apache2 server and mySQL on my machine to test the site.Every now and then, se ...

MySQL ERROR 1005 (HY000) at line 20: Can't create table '.frm' (errno: 604)

I am importing all my data back into the MySQL Cluster however after I import about 34 tables I start getting errors. I have found that I do not receive the errors if I take out the primary key from the rest of the tables. Bellow are the errors I am getting: Processing g_skidoott.out ERROR 1005 (HY0 ...

MySQL Can't create table 'xxx' (errno: 4318)

I have tried to create a table with primary key, unique keys and keys, engine=ndbcluster default charset=latin1 collate=latin1_german1_ci, but I got the error : ERROR 1005 (HY000): Can't create table 'xxx' (errno: 4318) perror 4318 gives me an Illegal error code. What can I do? ...

MySQL #1005 - Can't create table './dbname/aa_survey.frm' (errno: 4318)

I keep receiving this error and have no idea why. The table worked just fine with MyISAM (i know ndbcluster has quite a few restrictions.) Any help would be appreciated! #1005 - Can't create table './dbname/aa_survey.frm' (errno: 4318) Here is the table I am trying to import: (originally the varchar ...

MySQL ERROR 1005 (HY000): Can't create table 'myTable' (errno: 708)

I start the cluster; all work fine. But on attempt to create such table: use myBase; create table myTable ( cod_mod_1 dec(6,0), cod_mod_2 dec(2,0), tip_mod int, cod_st_1 dec(6,0), cod_st_2 dec(2,0), max_kol int, napr_pit_1 int, tok_pit_1 dec(5,3), napr_pit_2 int, tok_pit_2 dec(5,3), napr_pit_3 int, ...

MySQL getting sql error create single entry table

i am trying to create a table with a single entry called semaphore. The semaphore will contain text indicating which entity currently has control of the db The sql statment is working though: CREATE TABLE semaphoreTable ( semaphore TEXT(50) NOT NULL, PRIMARY KEY semaphoreKey (semaphore) ) TYPE = MyI ...

MySQL How do I create a simple database

I have absolutely no experience with databases and thought I would dive right in and figure it out, but after alot of wasted hours I found this forum. My webhosting uses php myadmin as it's database and I am trying to do construct a real estate database that shows a small picture of the house (I wou ...

MySQL Please help with 'create procedure' - truncation problem

I have been agonizing over this for a long time, but, it appears that there seems to be a limitation to the amount of characters one can have in a create procedure declaration. For example, if I try to make this procedure: create procedure insertPatient(lastName varchar, firstname varchar, birthdate ...

MySQL how do I create

on MySQL 4.0.22-standard new database? do I have to create some sort of Privileges? ...

MySQL How do I create an url with a loop that will only show for the records which have an url?

Let's see if I can explain what I need help with good first! Obviously I am new to the database stuff and am getting to be very interested in learning it. Basically I am creating your standard business directory database. I know how to add an url to the output already, but what I need to do is someh ...

MySQL how do u create a relationship?

is there a MySQL software that can create a relationship, or do i have to do it in code, i have a code here, and i need help on wats the error??? This is the code of the first table: CREATE TABLE `rooms` ( `RoomID` int(4) NOT NULL auto_increment, `Name` varchar(100) NOT NULL default '', PRIMARY KEY ...

WM_MOUSEWHEEL messages on Child window create in Thread

How to capture WM_MOUSEWHEEL messages on a child window created (using Win32 API Create function with all the requried params) in a thread. I understand that a child window created in thread should handle its own message loop but the message loop is not getting any MOUSEWHEEL messages whereas i can ...

MySQL How can i create tables that having turkish language character

I have a problem in table names. I want to give a name to my table. But i cant. The name is 'Kişiler'. It have some characters in only turkish language. I change my servers character set to latin5, turkish. Bu tit's not help me. How can i do. i waiting for answers in turkish: Veritabanımdaki bir t ...

MySQL Can a user create a user?

Well guys my host recently had to remove cPannel from the server, so is it possible for my MySQL admin to allow me to create users with my mysql name prefixed like in cPannel? Its not a big deal if I have to use the same user for each DB but its going to bug me till I die if I don't know for sure. ...

MySQL How do I create a Forum?

I´ve got a MySQL Account, and Webspace and a Homepage of course. Now I want to integrate a Forum, but I have not the slightest idea how to do it, and I searched 30minutes, but couldn´t find anything that could help me, somehow. It would be cool if somebody just described what I have to do. Have I ...