Re: Tuning MySQL DB server

Kezdőlap
Csatolmányok:
Üzenet email-ben
+ (text/plain)
Üzenet törlése
Válasz az üzenetre
Szerző: Matt Graham
Dátum:  
Címzett: Main PLUG discussion list
Tárgy: Re: Tuning MySQL DB server
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 -
To subscribe, unsubscribe, or to change your mail settings:
http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss