Re: MySQL memory allocation

2006-10-31 Thread Ravi Prasad LR
Which thread library is the mysqld linked against? Linuxthreads shows each thread as a separate process in top or ps output. All threads share the same memory. From your output, it is likely that you are using linuxthreads(all pids having the same VSZ and RES memory). Regards, Ravi Cabbar

Re: MySQL memory allocation

2006-10-31 Thread Ow Mun Heng
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 memo

MySQL memory allocation

2006-10-31 Thread Cabbar Duzayak
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 interpre