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