On Tue, 2006-10-31 at 01:30 -0800, Cabbar Duzayak wrote:
> Hi,
> 
> Could you please tell how I can tell how much memory does mysql server
> allocate on a linux box? I tried doing:
> 
> top -b -n 1 | grep mysql
> 
> But, it printed out bunch of processes for mysql. Are these all using
> shared memory so each line gives you the total amount for mysql? How
> can one interpret the results of this top, i.e. how should I read
> Virtual/Resident/Shared columns for all these processes and find out
> how much shared + (resident + swap: virtual) memory it uses?
> 
> Results of TOP for mysql:
>   PID USER      PR  NI  VIRT  RES  SHR S %CPU %MEM    TIME+  COMMAND
>  8205 mysql     12   0 75524  28M 26896 S     4.8  0.7   3:15   1 mysqld

Looks to me it is only using 28MB Resident Memory.  (not sure why there
are so many instances of mysqld)

  PID USER      PR  NI  VIRT  RES  SHR S %CPU %MEM    TIME+  COMMAND 
26431 mysql     15   0  503m 340m 4444 S  0.0 72.0 466:05.74 mysqld 

I'm using 340M on mine.



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to