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.
