[samaka4you]

Hello,


In web site made on dupal + mysql. I have roughltu this error :


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

What is the solution of the problem?

FI : MySQL version 5.0.67
and Drupal 6.X


Please help me.

[samaka4you]

for information, I use 1Go of RAM this database and this the configuration :

[mysqld]

tmp_table_size=32M
query_cache_size=32M
thread_cache_size=512
max_connections=500
open_files_limit=3000


skip-locking
key_buffer_size = 64M
max_allowed_packet = 64M
table_cache = 5000
myisam_sort_buffer_size = 64M
sort_buffer_size = 16M
join_buffer_size = 8M
read_buffer_size = 8M
read_rnd_buffer_size = 4M
net_buffer_length = 2K
thread_stack = 256K

max_binlog_cache_size = 1M
max_join_size = 24M
max_seeks_for_key = 2M
max_write_lock_count = 512K
myisam_max_sort_file_size = 4M

interactive_timeout = 25
wait_timeout = 300
connect_timeout = 10
max_connect_errors = 3000

#if you get a long query selecting a lot of data you might want to increase this
query_cache_limit = 32M
query_cache_type = 1

########################
##Configuration Innodb##
##Uncomment the next line to disable Innodb

#skip-innodb

innodb_buffer_pool_size = 32M
innodb_additional_mem_pool_size = 8M

innodb_log_file_size = 10M
innodb_log_buffer_size = 4M

innodb_flush_log_at_trx_commit=1


thanks for your help

[it-iss.com]

There is clearly a problem with your server not having sufficient memory to handle all the requests. You should look to tune your memory usage per connection as this is eating up your server memory. Check out this link: MySQL Bugs: #5656: Can't create a new thread (errno 11)