I have a new install of mysql 5 on a centos 5 (kernel-pae - hugemem) box. The box has dual xeon procs, 8 gigs of ram, and a massive & fast raid. Here's the deal, I bought this box just for mysql, however, if I try to allocate more than 4gigs of ram to mysql in the my.cnf (buffer pool for innodb), mysql freaks at startup and says it cannot allocate more than 4gigs to a 32bit machine.
So I tried lowering the value from 4G to 3G, still no go, get an error saying malloc cannot allocate xxxxxxxxxxxxxxxxxx.
So then I tried 2G and it works.
How do I get this mysql isntall to USE all or most of the available memory in the system? Its a huge waste if it cannot use it.
Worth 500 points.