From: | Bill Moran <wmoran(at)collaborativefusion(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: high %system time |
Date: | 2006-06-06 13:26:04 |
Message-ID: | 20060606092604.7d10a61e.wmoran@collaborativefusion.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Tue, 06 Jun 2006 09:19:10 -0400
Jacob Coby <jcoby(at)listingbook(dot)com> wrote:
> We recently upgraded from php 4.3.10 to 5.1.2, and the %system time has
> skyrocketed:
>
> Cpu(s): 42.8% us, 43.6% sy, 0.0% ni, 11.3% id, 2.2% wa, 0.2% hi, 0.0% si
> Mem: 8312844k total, 7566168k used, 746676k free, 22356k buffers
> Swap: 2040244k total, 520k used, 2039724k free, 6920384k cached
>
> it used to be around 5% to 10%. The server is a quad-xeon dell pe 6650
> running CentOS 4.2 with 8G of RAM running pg 8.1.1.
>
> How can I determine what is causing such high system load? it seems to
> have immediately jumped with the php upgrade.
This sounds more like a PHP question than a PostgreSQL question.
However, we had a similar problem recently, and I ran ktrace (on FreeBSD)
to track down the system calls. 2 things jumped out:
1) pg_connect() creates a LOT of system time compared to pg_pconnect()
2) require_once() and include_once() are truly evil.
HTH.
--
Bill Moran
Collaborative Fusion Inc.
From | Date | Subject | |
---|---|---|---|
Next Message | Jacob Coby | 2006-06-06 13:37:16 | Re: high %system time |
Previous Message | Jacob Coby | 2006-06-06 13:19:10 | high %system time |