Re: High CPU usage / load average after upgrading to Ubuntu 12.04 - Mailing list pgsql-performance

From Scott Marlowe
Subject Re: High CPU usage / load average after upgrading to Ubuntu 12.04
Date
Msg-id CAOR=d=01Hjf5qJxgRuMayjLsAg=KOjk1SfC_xkPkyhDS2NYfJg@mail.gmail.com
Whole thread Raw
In response to Re: High CPU usage / load average after upgrading to Ubuntu 12.04  (Jeff Janes <jeff.janes@gmail.com>)
List pgsql-performance
On Tue, Feb 26, 2013 at 2:30 PM, Jeff Janes <jeff.janes@gmail.com> wrote:
> On Fri, Feb 15, 2013 at 10:52 AM, Scott Marlowe <scott.marlowe@gmail.com>
> wrote:
>>
>> On Fri, Feb 15, 2013 at 11:26 AM, Josh Berkus <josh@agliodbs.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.


pgsql-performance by date:

Previous
From: Jeff Janes
Date:
Subject: Re: High CPU usage / load average after upgrading to Ubuntu 12.04
Next
From: Josh Berkus
Date:
Subject: Re: Server stalls, all CPU 100% system time