Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2005
    Posts
    60

    mysqld in malloc(): error: allocation failed

    I get this error:

    mysqld in malloc(): error: allocation failed

    2-3 times per day. Mysql restarts after this but its not ready for connections in next couple of minutes.. I can restart it during that time and everything will work fine or I can wait for couple of minutes..

    It looks like it has nothing to do with number of users on the site / server..

    Here's my.conf:

    query_cache_limit=1M
    query_cache_size=32M
    query_cache_type=1
    max_user_connections=1000
    max_connections=1500
    interactive_timeout=10
    wait_timeout=10
    connect_timeout=10
    thread_cache_size=128
    key_buffer=400M
    join_buffer=1M
    max_allowed_packet=16M
    table_cache=2048
    record_buffer=1M
    sort_buffer_size=2M
    read_buffer_size=2M
    max_connect_errors=10


    Server:

    AM P4 3.06
    1GB RAM
    FreeBSD 5.2.1
    MySQL 4.1.12


    Any ideas?

    Thanks

  2. #2
    Join Date
    May 2002
    Location
    Moscow
    Posts
    1,490
    try decrease key_buffer=400M to 16M or 32M. Look as very big. Mysql most likely just can't get more memory than you have installed.
    Rustelekom LLC Dedicated server since 2002, RIPE NCC member, LIR, AS51168

  3. #3
    Join Date
    Mar 2005
    Posts
    60
    Originally posted by worldhosting
    try decrease key_buffer=400M to 16M or 32M. Look as very big. Mysql most likely just can't get more memory than you have installed.
    Thanks,

    We'll see if it's going to help..

Posting Permissions

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