Re: PG 8.3 and server load

Поиск
Список
Период
Сортировка
От Scott Marlowe
Тема Re: PG 8.3 and server load
Дата
Msg-id dcc563d10908190919q3b4e6d29ic2e2e786a7c800c4@mail.gmail.com
обсуждение исходный текст
Ответ на Re: PG 8.3 and server load  (Phoenix Kiula <phoenix.kiula@gmail.com>)
Ответы Re: PG 8.3 and server load  (Ivan Voras <ivoras@freebsd.org>)
Список pgsql-performance
On Wed, Aug 19, 2009 at 9:40 AM, Phoenix Kiula<phoenix.kiula@gmail.com> wrote:
> On Wed, Aug 19, 2009 at 11:37 PM, Andy Colson<andy@squeakycode.net> wrote:
>
>>
>> Phoenix:  run top again, and hit the '1' key.  It'll show you stats for
>> each
>> cpu.  Is one pegged and the others idle?
>
> top - 10:38:53 up 29 days, 5 min,  1 user,  load average: 64.99, 65.17,
> 65.06
> Tasks: 568 total,   1 running, 537 sleeping,   6 stopped,  24 zombie
> Cpu0  : 17.7% us,  7.7% sy,  0.0% ni, 74.0% id,  0.7% wa,  0.0% hi,  0.0% si
> Cpu1  :  6.3% us,  5.6% sy,  0.0% ni, 84.4% id,  3.6% wa,  0.0% hi,  0.0% si
> Cpu2  :  5.6% us,  5.9% sy,  0.0% ni, 86.8% id,  1.7% wa,  0.0% hi,  0.0% si
> Cpu3  :  5.6% us,  4.0% sy,  0.0% ni, 74.2% id, 16.2% wa,  0.0% hi,  0.0% si
> Mem:   8310256k total,  8277416k used,    32840k free,    61944k buffers
> Swap:  2096440k total,    16128k used,  2080312k free,  7664224k cached
>

OK, nothing looks odd except, as pointed out, the stopped, zombie and
high load.  The actual amount of stuff running is minimal.

I'm wondering if you've got something causing apache children to crash
and go zombie.  What parts of this setup are compiled by hand?  Are
you sure that you don't have something like apache compiled against
one version of zlib and php-mysql against another?  Not that exact
problem, but it's one of many ways to make a crash prone apache.

В списке pgsql-performance по дате отправления:

Предыдущее
От: Guillaume Cottenceau
Дата:
Сообщение: Re: PG 8.3 and server load
Следующее
От: Kevin Kempter
Дата:
Сообщение: Query tuning