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!

MySQL Errors - Out of Memory

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

  1. xuser

    xuser Member

    Jun 21, 2007
    Likes Received:
    Trophy Points:
    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:

    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

    Nov 26, 2007
    Likes Received:
    Trophy Points:
    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 <>
    >> Bug reports, feature requests, and downloads at MySQLTuner - MySQLTuner
    >> Run with '--help' for additional options and output filtering
    Please enter your MySQL administrative login:
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. logicsupport

    logicsupport Well-Known Member

    Jun 5, 2007
    Likes Received:
    Trophy Points:
    can you try to restart mysql after increase the value of innodb_additional_mem_pool to a high value.
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  4. new_2cPanel

    new_2cPanel Registered

    Sep 9, 2009
    Likes Received:
    Trophy Points:
    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.

  5. xuser

    xuser Member

    Jun 21, 2007
    Likes Received:
    Trophy Points:
    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.

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice