Hi!
Machiel Richards wrote:
[[...]]
We received an error on a MySQL database this morning which
caused it to be unavailable for connections.
Error:
ERROR 1135 (0): Can't create a new thread (errno 11); if
you are not out of
of the amount of
connections though.
Machiel Richards
MySQL DBA
Relational Database Consulting
-Original Message-
From: joerg.bru...@sun.com [mailto:joerg.bru...@sun.com]
Sent: 30 June 2010 10:53 AM
To: mysql@lists.mysql.com
Cc: Machiel Richards
Subject: Re: Mysql error causing database
Good morning all
Hope everyone is well
We received an error on a MySQL database this morning which
caused it to be unavailable for connections.
Error:
ERROR 1135 (0): Can't create a new thread (errno 11); if
Note that some of the memory settings are per connection, if you have
63 connections, you may have up to 63 copies of the buffers, and you
have pretty huge buffers even with 30GB of memory. Join buffers close to
1 G, tmp_table_size of 2 G, 63 connections could mean upto 63 copies of
these,
@lists.mysql.com
Subject: Re: Mysql error causing database to not accept threads
Note that some of the memory settings are per connection, if you have
63 connections, you may have up to 63 copies of the buffers, and you
have pretty huge buffers even with 30GB of memory. Join buffers close to
1 G