Bug #60715 Always out of memory
Submitted: 1 Apr 2011 1:58 Modified: 3 May 2011 12:00
Reporter: Wei li Email Updates:
Status: No Feedback Impact on me:
Category:MySQL Server: General Severity:S3 (Non-critical)
Version:Mysql 5.5.10 OS:Linux (Centos 5.2 32bit)
Assigned to: CPU Architecture:Any
Tags: Memory, PAE

[1 Apr 2011 1:58] Wei li
server has 18G memory,4G*4,2G*1. disk format is Ext3. cmake Version is 2.8.4. database size near 10G. Cpu is Xeon 5110 1.60G

In default,32-bit Centos 5.2 only support 4G memory,so i fix a kernel-PAE path and can find all the memory. 

Before that I using mysql 5.5.4 - 5.5.8 and not found any error.

Last week I upgraded to 5.5.10,but always tips "out of memory need xxxxx" in error file, last time tips need repair the database.

max_connections = 512
table_cache = 256
sort_buffer_size = 2M
join_buffer_size = 2M
query_cache_size = 1024M
key_buffer_size = 1024M
read_buffer_size = 1M
read_rnd_buffer_size = 16M
tmp_table_size = 256M
max_heap_table_size = 256M

I moved mysql database to anther 64bit + 8G memory centos 5.5 server, a week without any error.

How to repeat:
[3 Apr 2011 12:00] Valeriy Kravchuk
Please, send the output of:

uname -a
file path_to_mysqld

with path_to_mysqld replaced by a real pathname for the MySQL server binary. Upload also the entire error log.

I doubt 32-bit mysqld will be able to use more than 4G of RAM by default on any OS.
[3 May 2011 23:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".