f 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 t
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
@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
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, and