Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

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:
    51
    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:
    66
    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:
    166
    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:
    51
    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:
    51
    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.
     
Loading...

Share This Page