Home > mailing lists

Re: [GENERAL] BDR, wal sender, high system cpu, mutex_lock_common - Mailing list pgsql-general

From	milist ujang
Subject	Re: [GENERAL] BDR, wal sender, high system cpu, mutex_lock_common
Date	October 3, 2017 22:21:56
Msg-id	CACG9ogx0uiuXtUF5MpNa_32nzxcxpnNocLYk+rnwQQFv=7UkpQ@mail.gmail.com Whole thread Raw
In response to	Re: [GENERAL] BDR, wal sender, high system cpu, mutex_lock_common (Craig Ringer <craig@2ndquadrant.com>)
Responses	Re: [GENERAL] BDR, wal sender, high system cpu, mutex_lock_common (Craig Ringer <craig@2ndquadrant.com>)
List	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@2ndquadrant.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

From: Craig Ringer
Date: 03 October 2017, 19:49:55
Subject: Re: [GENERAL] BDR, wal sender, high system cpu, mutex_lock_common

From: Schneider
Date: 04 October 2017, 00:58:03
Subject: Re: [GENERAL] time series data