The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

MySQL Errors - Out of Memory

Discussion in 'General Discussion' started by xuser, Jul 31, 2009.

  1. xuser

    xuser Member

    Joined:
    Jun 21, 2007
    Messages:
    17
    Likes Received:
    0
    Trophy Points:
    1
    I am running Dual Xeon 5405 (8 Cores), CentOS 5 (64 Bit), 12 GB RAM with latest cPanel/WHM.

    There are only 50 domains on this server and none of them cause high load. Everything is running fine except MySQL. It goes down 2-3 times a week on the almost same time.

    I checked /var/lib/mysql/{YOUR HOSTNAME HERE}.err to determine why MySQL failed and I see the following:

    Code:
    090731  0:38:29  InnoDB: Started; log sequence number 0 28420275
    /usr/sbin/mysqld: Out of memory (Needed 1324478464 bytes)
    /usr/sbin/mysqld: Out of memory (Needed 993358848 bytes)
    /usr/sbin/mysqld: Out of memory (Needed 745018368 bytes)
    /usr/sbin/mysqld: Out of memory (Needed 558763008 bytes)
    /usr/sbin/mysqld: Out of memory (Needed 419069952 bytes)
    /usr/sbin/mysqld: Out of memory (Needed 314302464 bytes)
    /usr/sbin/mysqld: Out of memory (Needed 235726848 bytes)
    /usr/sbin/mysqld: Out of memory (Needed 176793600 bytes)
    /usr/sbin/mysqld: Out of memory (Needed 132593664 bytes)
    /usr/sbin/mysqld: Out of memory (Needed 99443712 bytes)
    /usr/sbin/mysqld: Out of memory (Needed 74582016 bytes)
    /usr/sbin/mysqld: Out of memory (Needed 55934976 bytes)
    /usr/sbin/mysqld: Out of memory (Needed 41951232 bytes)
    /usr/sbin/mysqld: Out of memory (Needed 31463424 bytes)
    /usr/sbin/mysqld: Out of memory (Needed 23596032 bytes)
    /usr/sbin/mysqld: Out of memory (Needed 17694720 bytes)
    090731  0:38:29 [Note] /usr/sbin/mysqld: ready for connections.
    Version: '5.0.81-community-log'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Edition (GPL)
    090731  0:39:55 [ERROR] /usr/sbin/mysqld: Out of memory (Needed 3355440 bytes)
    
    InnoDB: memory with malloc! Total allocated memory
    InnoDB: by InnoDB 20625752 bytes. Operating system errno: 12
    InnoDB: Check if you should increase the swap file or
    InnoDB: ulimits of your operating system.
    InnoDB: On FreeBSD check you have compiled the OS with
    InnoDB: a big enough maximum process size.
    InnoDB: Note that in most 32-bit computers the process
    InnoDB: memory space is limited to 2 GB or 4 GB.
    InnoDB: We keep retrying the allocation for 60 seconds...
    090731  0:47:48  InnoDB: We now intentionally generate a seg fault so that
    InnoDB: on Linux we get a stack trace.
    090731  0:47:48 - mysqld got signal 11 ;
    
    Any ideas how to fix?

    Thanks in advance for your help.
     
  2. serversignature

    serversignature Well-Known Member

    Joined:
    Nov 26, 2007
    Messages:
    107
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Bangalore
    Run the below command from your mysql-client and check Threads_connected, Max_used_connections should give you a good clue.

    mysql> show global status;

    Or try out mysqltuner

    To run the script with the default options, run the script without arguments
    Allow MySQL server to run for at least 24-48 hours before trusting suggestions

    mysqltuner : high-performance MySQL tuning script

    ~# mysqltuner

    >> MySQLTuner 0.9.0 - Major Hayden <major@mhtx.net>
    >> Bug reports, feature requests, and downloads at MySQLTuner - MySQLTuner
    >> Run with '--help' for additional options and output filtering
    Please enter your MySQL administrative login:
     
  3. logicsupport

    logicsupport Well-Known Member

    Joined:
    Jun 5, 2007
    Messages:
    138
    Likes Received:
    0
    Trophy Points:
    16
    can you try to restart mysql after increase the value of innodb_additional_mem_pool to a high value.
     
  4. new_2cPanel

    new_2cPanel Registered

    Joined:
    Sep 9, 2009
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    1
    mysqld out of memory

    Do you have a fix for the mysqld out of memory?
    What is the content of your /etc/my.cnf file ?

    I am experiencing the same issue. I do not know how to fix this yet.


    new_2cPanel
     
  5. xuser

    xuser Member

    Joined:
    Jun 21, 2007
    Messages:
    17
    Likes Received:
    0
    Trophy Points:
    1
    Yes. This has been sorted out.

    We are not using standar Kernel on our cPanel boxes and it doesn't seem to be able to run 32-bit binaries. This was breaking /scripts/mysqlup which is run each night.

    We disabled automated MySQL Updates in
    WHM > Update Config > cPanel Package Updates > mysql and since than we don't have any issues.

    We now update MySQL manually.
     
  6. dannydesiliva

    dannydesiliva Member

    Joined:
    Sep 5, 2009
    Messages:
    11
    Likes Received:
    0
    Trophy Points:
    1
    That is clearly a server issue. The MySQL client ran out of memory. I'm surprised any host would not be able to recognize that fact.

    They will probably have to restart MySQL to fix this.

    ____________________________________________________________________________________________________


    John

    dog strollers | car seat for dogs | how to pass a drug test
     
    #6 dannydesiliva, Sep 12, 2009
    Last edited: Sep 14, 2009
Loading...

Share This Page