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 if each connection uses the full buffers, thats close to 200GB!
You should adjust these to cater to the maximum number of connections
expected.
Did you try to check how much free memory you have when the problem occurs?
Am 29.06.2010 10:17, schrieb Machiel Richards:
ERROR 1135 (00000): Can't create a new thread
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org