[openstack-dev] [nova][cinder] (OperationalError) (1040, 'Too many connections') None None

Jay Pipes jaypipes at gmail.com
Mon Sep 29 20:15:27 UTC 2014


On 09/29/2014 03:12 PM, Nader Lahouti wrote:
> Jay,
>
> I increased the max_connection to 2000 and so far don't see any issue.
> After launching 20 VMs the number of connections as follows:
>
> Mon Sep 29 05:05:29 PDT 2014
> Number of open TCP:3306 - 326
> Number of open TCP:3306 nova-api - 34
> Number of open TCP:3306 mysqld - 163
> Number of open TCP:8774 - 66
> Number of nova-api - 98
>
> It seems the default max_connection for Juno in not enough and should be
> changed as you suggested. But the question is what is correct/reliable
> value?

max_connections is not an OpenStack configuration option (therefore 
there isn't a "default max_connections for Juno". It is a MySQL-specific 
option.

Best,
-jay



More information about the OpenStack-dev mailing list