Matt, I've attached the my.cnf file. You may be right about the 3G. *"ps auxw | grep /usr/sbin/mysqld" :* mysql 10995 0.1 8.7 7086136 716240 ? Ssl 17:44 0:03 /usr/sbin/mysqld root 15235 0.0 0.0 7684 844 pts/2 S+ 18:22 0:00 grep --color=auto /usr/sbin/mysqld On Fri, Oct 12, 2012 at 2:02 PM, Matt Graham wrote: > From: Vimal Shah > > This led to the discovery that 32-bit version of Ubuntu will not allow > > MySQL to use any more that 2GB. > > This seems odd, since a single process on 32bit should be able to malloc() > 3G. > > > 64-bit Ubuntu 10.04, I am *still unable to get to the box to use all the > > memory*. I feel that the DB server should be using more RAM. Can someone > > point out the flaws in my process or > > What's your my.cnf look like? If there isn't one, what's the text you get > back from "ps auxw | grep /usr/sbin/mysqld" ? The defaults for the innodb > buffer pool/key buffer/sort buffer and all those things are probably > smaller > than they should be for a machine that's got 8G and is a dedicated DB box. > > -- > Matt G / Dances With Crows > The Crow202 Blog: http://crow202.org/wordpress/ > There is no Darkness in Eternity/But only Light too dim for us to see > > --------------------------------------------------- > PLUG-discuss mailing list - PLUG-discuss@lists.plug.phoenix.az.us > To subscribe, unsubscribe, or to change your mail settings: > http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss > -- Vimal (rhymes with Kimmel) Shah VP of Engineering Sokikom Mobile: (480) 752-9269 Email: vimals@sokikom.com Web: www.sokikom.com Follow us: twitter.com/sokikom Like us: facebook.com/sokikom