Re: BDR, wal sender, high system cpu, mutex_lock_common

From: milist ujang <ujang(dot)milist(at)gmail(dot)com>
To: Craig Ringer <craig(at)2ndquadrant(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: BDR, wal sender, high system cpu, mutex_lock_common
Date: 2017-10-03 16:21:56
Message-ID: CACG9ogx0uiuXtUF5MpNa_32nzxcxpnNocLYk+rnwQQFv=7UkpQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi Craig,

Anyway, this OS is guess OS in vmware (vsphere).
Thank for your response and help.

On Tue, Oct 3, 2017 at 8:49 PM, Craig Ringer <craig(at)2ndquadrant(dot)com> wrote:
>
>
> Can you get stacks please?
>
> Use -g
>

# Events: 2K cpu-clock
#
# Overhead Command Shared Object Symbol
# ........ ........ ................. ............................
#
86.96% postgres [kernel.kallsyms] [k] __mutex_lock_common.isra.5
|
--- __mutex_lock_common.isra.5
read

2.85% postgres [kernel.kallsyms] [k] do_raw_spin_lock
|
--- do_raw_spin_lock
|
|--90.48%-- read
|
|--8.33%-- recv
|
--1.19%-- write

2.44% postgres [kernel.kallsyms] [k] mutex_unlock
|
--- mutex_unlock
read

2.03% postgres [kernel.kallsyms] [k] arch_local_irq_restore
|
--- arch_local_irq_restore
read

1.32% postgres postgres [.] ValidXLogRecord
|
--- ValidXLogRecord

1.25% postgres [kernel.kallsyms] [k] mutex_lock
|
--- mutex_lock
read

--
regards

ujang jaenudin | DBA Consultant (Freelancer)
http://ora62.wordpress.com
http://id.linkedin.com/pub/ujang-jaenudin/12/64/bab

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Schneider 2017-10-03 18:58:03 Re: time series data
Previous Message Craig Ringer 2017-10-03 13:49:55 Re: BDR, wal sender, high system cpu, mutex_lock_common