On Sat, Jan 24, 2004 at 01:56:53PM -0600, Dan Nelson wrote:
> You didn't say what OS you're using, but the below top output looks
> like Linux's procps top, which doesn't tell you your paging rate.  Run
> "vmstat 1" and watch the si and so columns.  Just because swap is being
> used doesn't mean you're thrashing.  You need to know the rate.

It's Linux, yes.

The si and so columns were in the hundreds when I did "vmstat 1", but
I didn't save it at the moment the machine had a high load average and
lots of swap space used.

> No, mysql is taking up 23MB.  Linux creates separate processes for each
> thread, which is why you see lots of mysqlds in top.  They all share
> the same address space, though.  Are you sure you don't maybe have a
> couple dozen apache processes consuming your memory instead?

Well, here's a ps (sorted by memory, greatest memory usage is at the
bottom):

http://lina.aaanime.net/~pmak/memory.txt

At the bottom, it's all mysqld processes. A total of about 1400 MB of
RAM is being used... so if mysqld's memory is all shared, I guess it's
all from the apache processes adding up?

Oh, does anyone know how to make "ps" not show shared memory used by
processes more than once?

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

Reply via email to