MySQL Development
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
 
User Name:
Password:
Remember me
 



Go Back   Dev Articles Community ForumsDatabasesMySQL Development

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Display Modes
 
Unread Dev Articles Community Forums Sponsor:
  #1  
Old April 1st, 2004, 04:45 PM
factor9000 factor9000 is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Apr 2004
Posts: 1 factor9000 User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
Unhappy MySql Error Can't create a new thread (errno 11).?

I am getting this error at times when I have light traffic, and the server is not overloaded, and memory is available.
mysql_select_db(): 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 in
Server specification :

Dell poweredge 6650
4 gb RAM
4 Intel XEON 2.7 Ghz

The server runs on Red-hat 7.3
mysql 3.23.55
PHP/4.3.2

/** mysql> show variables; **/


bdb_cache_size 8388600
bdb_max_lock 10000
bdb_shared_data OFF
binlog_cache_size 32768
concurrent_insert ON
datadir /mnt/md0/mysql/
delay_key_write ON
delayed_insert_limit 100
delayed_insert_timeout 300
delayed_queue_size 1000
flush OFF
flush_time 0
have_bdb DISABLED
have_gemini NO
have_innodb YES
have_isam YES
have_raid NO
have_openssl NO
init_file
innodb_additional_mem_pool_size
262144000
innodb_buffer_pool_size 891289600
innodb_data_home_dir /mnt/md0/mysql
innodb_file_io_threads 5
innodb_force_recovery 0
innodb_thread_concurrency 8
innodb_flush_log_at_trx_commit 1
innodb_fast_shutdown ON
innodb_log_buffer_size 8388608
innodb_log_file_size 157286400
innodb_mirrored_log_groups 1
interactive_timeout 60
join_buffer_size 131072
key_buffer_size 891285504
low_priority_updates OFF
lower_case_table_names 0
max_allowed_packet 1048576
max_binlog_cache_size 4294967295
max_binlog_size 1073741824
max_connections 1000
max_connect_errors 10
max_delayed_threads 20
max_heap_table_size 16777216
max_join_size 4294967295
max_sort_length 1024
max_user_connections 0
max_tmp_tables 32
max_write_lock_count 4294967295
net_buffer_length 16384
net_read_timeout 30
net_retry_count 10
net_write_timeout 60
open_files_limit 0
protocol_version 10
record_buffer 8384512
record_rnd_buffer 8384512
query_buffer_size 0
sort_buffer 8388600
sql_mode 0
table_cache 1500
table_type INNODB
thread_cache_size 50
thread_stack 131072
transaction_isolation READ-COMMITTED
timezone CST
tmp_table_size 33554432
tmpdir /tmp/
version 3.23.55-Max-log
wait_timeout 60

thanks

Reply With Quote
Reply

Viewing: Dev Articles Community ForumsDatabasesMySQL Development > MySql Error Can't create a new thread (errno 11).?


Developer Shed Advertisers and Affiliates


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump

Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 


Powered by: vBulletin Version 3.0.5
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.

© 2003-2014 by Developer Shed. All rights reserved. DS Cluster - Follow our Sitemap