Tuning MySQL DB server

[Vimal Shah]

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 <danceswithcrows at usa.net>wrote:

> From: Vimal Shah <vimals at sokikom.com>
> > 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 at 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 at sokikom.com
Web:    www.sokikom.com

Follow us: twitter.com/sokikom <http://www.twitter.com/sokikom>
Like us: facebook.com/sokikom <http://www.facebook.com/sokikom>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.PLUG.phoenix.az.us/pipermail/plug-discuss/attachments/20121012/689c46f4/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: my.cnf
Type: application/octet-stream
Size: 3779 bytes
Desc: not available
URL: <http://lists.PLUG.phoenix.az.us/pipermail/plug-discuss/attachments/20121012/689c46f4/attachment.obj>