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]