MySQL Errors - Out of Memory

[xuser]

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.

[serversignature]

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:

[logicsupport]

can you try to restart mysql after increase the value of innodb_additional_mem_pool to a high value.

[new_2cPanel]

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

[xuser]

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.

[dannydesiliva]

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