Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2010
    Posts
    2

    Unanswered: Can't create a new thread

    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.

  2. #2
    Join Date
    Apr 2010
    Posts
    2
    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

  3. #3
    Join Date
    Sep 2009
    Location
    San Sebastian, Spain
    Posts
    880
    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)
    Ronan Cashell
    Certified Oracle DBA/Certified MySQL Expert (DBA & Cluster DBA)
    http://www.it-iss.com
    Follow me on Twitter

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •