Re: High CPU usage / load average after upgrading to Ubuntu 12.04

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.

In response to

Browse pgsql-performance by date

  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