Bug #45129 MySQL daemon throw an out-of-memory error and uses all of its memory space
Submitted: 27 May 2009 12:02 Modified: 1 Jun 2009 7:36
Reporter: Ohad Benita Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server Severity:S2 (Serious)
Version:5.1.30 OS:Windows
Assigned to: CPU Architecture:Any
Tags: daemon, Memory, usage

[27 May 2009 12:02] Ohad Benita
Description:
MySQL server started @ May 26th, 16:23 and used about 300 MB of memory. Today, after about 24 hours the process memory usage is about 900MB. It seems like the process use up all its free memory and does not release it.

How to repeat:
Use MysSQL in a normal usage scenario for some time (in our case about 24 hours), the memory usage of the MySQL daemon is very close to the memory limit stated in the ini file.
[27 May 2009 12:54] MySQL Verification Team
Thank you for the bug report. Could you please provide the exactly version 5.1.xx, the Windows OS`s version and your my.ini file. Thanks in advance.
[27 May 2009 13:05] Ohad Benita
Windows OS version : Server 2003, Service Pack 2
MySQL version : 5.1.30

My.ini file is attached
[27 May 2009 13:06] Ohad Benita
My.ini configuration file

Attachment: my.ini (application/octet-stream, text), 9.17 KiB.

[1 Jun 2009 7:36] Sveta Smirnova
Thank you for the feedback.

You have innodb_buffer_pool_size=1024MB. This means InnoDB can use up to 1024MB RAM to cache both indexes and row data. So having 900MB of RAM used is expected and I close the report as "Not a Bug".

If for some reason you think this is not a case and high RAM usage happens because different reason check RAM usage with lower value of this option.