Bug #44426 Mysql out of memory
Submitted: 23 Apr 2009 10:42 Modified: 26 Jul 2009 9:33
Reporter: Rafa Manzano Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server Severity:S2 (Serious)
Version:5.1.30 OS:Linux
Assigned to: CPU Architecture:Any
Tags: show table status

[23 Apr 2009 10:42] Rafa Manzano
Description:
When trying to restore a dump of 1.2 million records (400 Mb dump) in to a table mysql gives out of memory. 
mysql process gets 85% of machine memory (2 Gb). 
Error given:
 ERROR 5 (HY000) at line 53: Out of memory (Needed 16384 bytes)

Engine only MyISAM. flag skip innodb set.
file descriptors 30000.

table description attached

How to repeat:
Anytime I try to restore the dump
[23 Apr 2009 10:44] Rafa Manzano
table description

Attachment: table_descr.txt (text/plain), 16.85 KiB.

[23 Apr 2009 10:45] Rafa Manzano
my.cnf used

Attachment: my.cnf (application/octet-stream, text), 6.43 KiB.

[23 Apr 2009 11:15] Valeriy Kravchuk
Thank you for the problem report. Please, send the results of SHOW TABLE STATUS for the table.
[29 Apr 2009 11:27] Valeriy Kravchuk
You have 230 or so partitions in MyISAM table... Please, check if the same problem happens with mysam_sort_buffer_size = 1M and sort_buffer_size = 1M.
[29 Apr 2009 11:52] Rafa Manzano
Thank you, it does not happen now. Can you tell me how the buffer and size variables are used in memory consume for tuning my and other systems?
[29 Apr 2009 11:52] Rafa Manzano
Thank you, it does not happen now. Can you tell me how the buffer and size variables are used in memory consume for tuning my and other systems?
[29 Apr 2009 11:52] Rafa Manzano
Thank you, it does not happen now. Can you tell me how the buffer and size variables are used in memory consume for tuning my and other systems?
[26 Jul 2009 9:33] Valeriy Kravchuk
So this looks like a result of misconfiguration, not a bug.

Check http://dev.mysql.com/doc/refman/5.1/en/memory-use.html and links from there.