Open Stack

On 17/04/15 09:20, Qiming Teng wrote:
>
> Wondering if there is something misconfigured in my devstack
> environment, which was reinstalled on RHEL7 about 10 days ago.
> I'm often running into mysql connections problem as shown below:
>
> $ mysql
> ERROR 1040 (HY000): Too many connections
>
> When I try dump the mysql connection list, I'm getting the followng
> result after a 'systemctl restart mariadb.service':
>
> $ mysqladmin processlist | grep nova | wc -l
> 125
>
> Most of the connections are at Sleep status:
>
> $ mysqladmin processlist | grep nova | grep Sleep | wc -l
> 123
>
> As for the workload, I'm currently only running two VMs in a multi-host
> devstack environment.
>
> So, my questions:
>
>    - Why do we have so many mysql connections from nova?
>    - Is it possible this is caused some misconfigurations?
>    - 125 connections in such a toy setup is insane, any hints on nailing
>      down the connections to the responsible nova components?
>

Can you show us the full listing for

mysqladmin processlist

as 125 seems high for a toy setup? How many nova instances are running? 
I have a (single node) devstack setup with 2 nova instances running and 
I have 9 mysql connections to the nova db.

Regards

Mark