[openstack-dev] [nova] Mysql db connection leaking?
tengqim at linux.vnet.ibm.com
Thu Apr 16 21:20:06 UTC 2015
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:
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
Most of the connections are at Sleep status:
$ mysqladmin processlist | grep nova | grep Sleep | wc -l
As for the workload, I'm currently only running two VMs in a multi-host
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?
More information about the OpenStack-dev