RE: Memory Usage.

2011-04-25 Thread Jerry Schwartz
>-Original Message- >From: Andrés Tello [mailto:mr.crip...@gmail.com] >Sent: Monday, April 25, 2011 10:24 AM >To: Mailing-List mysql >Subject: Memory Usage. > >How can I know how memory is being used by Mysql? > >I have 32GB Ram, but I can't make mysql to use more than 12GB Ram , and even >

Re: Memory Usage.

2011-04-25 Thread Reindl Harald
Am 25.04.2011 16:24, schrieb Andrés Tello: > How can I know how memory is being used by Mysql? > > I have 32GB Ram, but I can't make mysql to use more than 12GB Ram , and even > that I have tables over 40GB... > > Thanks! xD depends on storage-engine (myisam or innodb), buffer-sizes, size of th

Re: memory usage

2008-07-22 Thread Ananda Kumar
Hi Joerg, Thanks a lot for the info. regards anandkl On 7/23/08, Joerg Bruehe <[EMAIL PROTECTED]> wrote: > > Hi ! > > > Ananda Kumar wrote: > >> Hi All, >> I have setup slave db. The machine configuration details of this slave is >> same as master. >> >> OS=redhat >> 8 cpu >> 16GB RAM >> >> key_

Re: memory usage

2008-07-22 Thread Joerg Bruehe
Hi ! Ananda Kumar wrote: Hi All, I have setup slave db. The machine configuration details of this slave is same as master. OS=redhat 8 cpu 16GB RAM key_buffer_size=3000M innodb_buffer_pool_size=1M. But when i do top, in the master db Cpu(s): 0.5%us, 0.3%sy, 0.0%ni, 87.2%id, 11.9%wa,

Re: memory usage - mysql tuning!!

2008-02-13 Thread Richard
bruce a écrit : Hi.. Fairly new to mysql, in particular tuning. I have a test mysql db, on a test server. I've got a test app that runs on multiple servers, with each test app, firing/accessing data from the central db server. the central server is on a 2GHz, 1GMem, 100G system. MySQL is the b

Re: Memory usage question

2005-09-22 Thread Dan Nelson
In the last episode (Sep 22), Blumenkrantz, Steve said: > We very recently began replicating data from a master to a slave and > since doing that we've noticed that most of the RAM in the machine 2 > GB is being used with very little (relatively) free (12MB - 50MB). > I've looked at several forums

Re: memory usage probs

2004-03-20 Thread Matthew Hodgson
In case anyone else encounters this particular symptom, it turns out the problem was gcc using some orphaned headers for mysql 3.23.56 sitting in /usr/include/mysql rather than the correct mysql 4.0.17 ones residing in /usr/local/include/mysql, thus yielding all the strange behaviour. M. On Sat,

Re: memory usage

2003-06-23 Thread Jeremy Zawodny
On Mon, Jun 23, 2003 at 07:21:25PM -0500, Miguel Perez wrote: > > Hi, I have a question about the memory that mysql uses, > Here is the info that top command displays: > > 7:39pm up 55 days, 2:51, 1 user, load average: 0.18, 0.08, 0.02 > 54 processes: 53 sleeping, 1 running, 0 zombie, 0 stopp