Ask Your Question

recommended settings for max database connections for all openstack services

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

noahjd91 gravatar image

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


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

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

Gnan gravatar image


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

edit flag offensive delete link more


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 -0500 )edit

Get to know Ask OpenStack

Resources for moderators

Question Tools

1 follower


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

Seen: 682 times

Last updated: Oct 07 '15