Bazooka

Asked: 2022-02-02 02:15:53 +0800 CST2022-02-02 02:15:53 +0800 CST 2022-02-02 02:15:53 +0800 CST

OpenStack: Too many Database idle Connections

I use PostgreSQL as a DB backend for all OpenStack Services on 3 Controllers. When all 3 controllers are started with no load, the number of connections are up to 700. And all of this conns are in idle mode.

Here are the Database parameters in Openstack service conf files:

max_overflow = 50
max_pool_size = 5
pool_timeout = 30
connection_recycle_time = 600

I have changed this parameter to smaller values, but it has not improved anything.

Any ideas why the number of connections are too high?

OpenStack: Too many Database idle Connections

Can you pass user/pass for HTTP Basic Authentication in URL parameters?

Ping a Specific Port

Check if port is open or closed on a Linux server?

How to automate SSH login with password?

How do I tell Git for Windows where to find my private RSA key?

What's the default superuser username/password for postgres after a new install?

What port does SFTP use?

Command line to list users in a Windows Active Directory group?

What is a Pem file and how does it differ from other OpenSSL Generated Key File Formats?

How to determine if a bash variable is empty?

OpenStack: Too many Database idle Connections

0 Answers