From: | Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> |
---|---|
To: | Jeff Janes <jeff(dot)janes(at)gmail(dot)com> |
Cc: | Josh Berkus <josh(at)agliodbs(dot)com>, pgsql-performance(at)postgresql(dot)org |
Subject: | Re: High CPU usage / load average after upgrading to Ubuntu 12.04 |
Date: | 2013-02-26 21:46:32 |
Message-ID: | CAOR=d=01Hjf5qJxgRuMayjLsAg=KOjk1SfC_xkPkyhDS2NYfJg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
On Tue, Feb 26, 2013 at 2:30 PM, Jeff Janes <jeff(dot)janes(at)gmail(dot)com> wrote:
> On Fri, Feb 15, 2013 at 10:52 AM, Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
> wrote:
>>
>> On Fri, Feb 15, 2013 at 11:26 AM, Josh Berkus <josh(at)agliodbs(dot)com> wrote:
>> > On 02/14/2013 08:47 PM, Scott Marlowe wrote:
>> >> If you run your benchmarks for more than a few minutes I highly
>> >> recommend enabling sysstat service data collection, then you can look
>> >> at it after the fact with sar. VERY useful stuff both for
>> >> benchmarking and post mortem on live servers.
>> >
>> > Well, background sar, by default on Linux, only collects every 30min.
>> > For a benchmark run, you want to generate your own sar file, for
>> > example:
>>
>> On all my machines (debian and ubuntu) it collects every 5.
>
>
> All of mine were 10, but once I figured out to edit /etc/cron.d/sysstat they
> are now every 1 minute.
oh yeah it's every 10 on the 5s. I too need to go to 1minute intervals.
> sar has some remarkably opaque documentation, but I'm glad I tracked that
> down.
It's so incredibly useful. When a machine is acting up often getting
it back online is more important than fixing it right then, and most
of the system state stuff is lost on reboot / fix.
From | Date | Subject | |
---|---|---|---|
Next Message | Josh Berkus | 2013-02-26 23:29:12 | Re: Server stalls, all CPU 100% system time |
Previous Message | Costin Oproiu | 2013-02-26 21:45:57 | pgbench intriguing results: better tps figures for larger scale factor |