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.

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.059 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.