Ask Your Question
0

recommended settings for max database connections for all openstack services

asked 2015-10-06 10:59:33 -0600

noahjd91 gravatar image

updated 2015-10-07 15:15:45 -0600

Hello,

I was wondering if there were some recommended settings for the maximum amount of database connections for openstack. We frequently run into a problem where we cannot perform a certain operation because of "Too many connections" being open to our postgresql databases.

I also noticed that we have several hundred connections to postgresql that seems to stay open for days on end, should the max connections be adjusted or a timeout specified? if so, where should this all be set at?

Thanks all.

edit retag flag offensive close merge delete

1 answer

Sort by ยป oldest newest most voted
0

answered 2015-10-06 12:26:05 -0600

Gnan gravatar image

Hello,

You can try to set max_connections value under /etc/mysql/my.cnf or /etc/my.cnf

edit flag offensive delete link more

Comments

I've already adjusted the max connections from the default which was 100 to 300, and somehow all the openstack services maxed that out as well. Is there some sort of guideline or metric I can follow so that I can properly scale out the max db connections I should set?

noahjd91 gravatar imagenoahjd91 ( 2015-10-07 15:15:22 -0600 )edit

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account.

Add Answer

Get to know Ask OpenStack

Resources for moderators

Question Tools

1 follower

Stats

Asked: 2015-10-06 10:59:33 -0600

Seen: 502 times

Last updated: Oct 07 '15