[pgpool-general: 6796] Re: High load average on pgpool server
pengbo at sraoss.co.jp
Fri Dec 20 14:26:44 JST 2019
> QUESTION: What can cause such an increase in server load?
A large number of connections may increase server load.
Which version of pgpool do you use?
On Thu, 19 Dec 2019 13:32:26 +0100
Radosław Szczygieł <radoslaw.szczygiel at interia.pl> wrote:
> Hello PGPOOL team,I have a problem regarding pgpool server load. Our cluster consists of 2 pgpool servers (watchdog) and 2 postgresql servers (master-slave). Within a few days of restarting the pgpool service, the average server load is at a high level load average : 15-20 on 15 min load. After restart pgpool load average drops to low values, but every day there is a successive increase in load average (but count of connections is the same all time). At the highest load average, the RAM usage is about 6,5GB, but the processor is used to the max.QUESTION: What can cause such an increase in server load? Currently, our PG cluster has a size of about 600GB, about 1000 connections to several bases, of which in many cases connections are short but there are many at once with high frequency. Pgpool server with centos 7 have Intel(R) Xeon(R) CPU X5650 @ 2.67GHz and 64GB ram.Below I present part of the configuration of pool connection and life time and attach screen from Icinga moni
tor of load average last 2 weeks.# -----listen_backlog_multiplier = 2 # Set the backlog parameter of listen(2) to # num_init_children * listen_backlog_multiplier. # (change requires restart)serialize_accept = off &nb
sp; # whether to serialize accept() call to avoid thundering herd problem # (change requires restart)reserved_connections = 0#-----------num_init_children = 500 # Number of concurrent sessions allowed # (change requires restart)max_pool = 4 &nbs
p; # Number of connection pool caches per connection # (change requires restart)# - Life time -child_life_time = 300 # Pool exits after being idle for this many secondschild_max_connections = 2005 # Pool exits after receiving that many connections
# 0 means no exitconnection_life_time = 1000 # Connection to backend closes after being idle for this many seconds # 0 means no closeclient_idle_limit = 4000Regards,Radoslaw Szczygiel
Bo Peng <pengbo at sraoss.co.jp>
SRA OSS, Inc. Japan
More information about the pgpool-general