Waldomiro wrote:
Hi,
I have one of my database server that I run the "top" command:
top - 16:16:30 up 42 days, 13:23, 4 users, load average: 3.13, 3.52,
3.36
Tasks: 624 total, 1 running, 623 sleeping, 0 stopped, 0 zombie
Cpu(s): 1.4%us, 1.1%sy, 0.0%ni, 84.4%id, 12.9%wa, 0.0%hi,
0.2%si, 0.0%st
Mem: 16432240k total, 16344596k used, 87644k free, 27548k buffers
Swap: 10241428k total, 3680860k used, 6560568k free, 6230376k cached
I´m afraid of two things, one is the "load average", I think 3 is too
much, another is the "swap", almost 4GB of swap, I think that is too
much swap.
Am I right?
Can I use those indicators to know if my database is ok?
Top only provides limited information about your system performance.
disk IO is real important too, yous show 13% IO Wait there, indication
that the processes are spedning a signficant amount of time waiting for
disk. you can monitor disk IO by iostat -x <interval> (you may need
to install the 'sysstat' package for your linux distribution). a
load facgtor of 3 means three processes are active.
how many cores do you have? what processes are active? those are
some other questions worth asking ...
as far as 'database is OK', well, is it performing adequately? is your
data intact? if so, then I'd say yes, its performing OK.
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
