MySQL Bugs: #60715: Always out of memory

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:	None
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

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

my.cnf
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:
??

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.

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