Using more than 2GB for user space processes

[Brian]

Hello list,

I have searched the lists but I don't see a clear
answer to running MySQL on a 32-bit Linux server with
more than 2gb allocated to innodb_buffer_pool_size.

Here are the details, and any help or direction to the
right resources would be really appreciated.

Server is 32-bit and has 4GB RAM and 2GB swap
OS is FC2
Kernel is 2.6.9-1.9_FC2hugemem #1 SMP Mon Dec 13
01:31:08 EST 2004 i686 i686 i386 GNU/Linux
MySQL tried is MySQL-server-4.1.12-1 and
MySQL-server-4.1.13-0 from binary RPM's from
mysql.org.

# ulimit -a
core file size        (blocks, -c) 0
data seg size         (kbytes, -d) unlimited
file size             (blocks, -f) unlimited
max locked memory     (kbytes, -l) 32
max memory size       (kbytes, -m) unlimited
open files                    (-n) 1024
pipe size          (512 bytes, -p) 8
stack size            (kbytes, -s) 10240
cpu time             (seconds, -t) unlimited
max user processes            (-u) 61436
virtual memory        (kbytes, -v) unlimited


With the following set, the server works fine:
innodb_buffer_pool_size = 1700M

When I change this to anything above 2000M it fails
with the following error message:
050804 19:11:27  mysqld started
050804 19:11:28 [Warning] Asked for 196608 thread
stack, but got 126976
050804 19:11:29  InnoDB: Error: cannot allocate
2411741184 bytes of
InnoDB: memory with malloc! Total allocated memory
InnoDB: by InnoDB 34049176 bytes. Operating system
errno: 12
InnoDB: Check if you should increase the swap file or
InnoDB: ulimits of your operating system.
InnoDB: On FreeBSD check you have compiled the OS with
InnoDB: a big enough maximum process size.
InnoDB: We keep retrying the allocation for 60
seconds...


I also have a test machine (though with 1GB RAM and
4.5GB swap) running RHEL4 with the following kernel
returning the exact same problem:

2.6.9-11.ELhugemem #1 SMP Wed Jun 8 18:47:48 CDT 2005
i686 i686 i386 GNU/Linux


>From the release notes, the stock FC2 kernel should
allocate 3GB/1GB by default for userspace processes?
This does not happen on my machines.

In the case of the hugemem kernels, the release notes
indicate user space processes can allocate upto 4GB if
it is available. I am not seeing this work either.

Anyone have this working at their site or have any
insight to this?


Brian

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com