MySQL Bugs: #56694: mysql.server + large amounts of memory = cannot allocate error

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:	None
Category:	MySQL Server	Severity:	S3 (Non-critical)
Version:		OS:	Any
Assigned to:		CPU Architecture:	Any

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
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.