Bug #56694 mysql.server + large amounts of memory = cannot allocate error
Submitted: 9 Sep 2010 15:28 Modified: 20 Sep 2010 13:17
Reporter: Lig Isler-Turmelle Email Updates:
Status: Verified Impact on me:
Category:MySQL Server Severity:S3 (Non-critical)
Version: OS:Any
Assigned to: CPU Architecture:Any

[9 Sep 2010 15:28] Lig Isler-Turmelle
When a system has a large amount of RAM in use it is possible that when you restart the server using /etc/init.d/mysql restart - that all the original memory allocated is not freed in time for the restart.

This generates error "cannot allocate X bytes of memory".  mysqld_safe however keeps restarting the server until the memory is freed and then starts it up fine.

How to repeat:
on a system using a large amount of memory, restart the system and watch top

Suggested fix:
correct the code or add sleep into the code to give it more time.