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