<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
</head>
<body dir="auto">
<div>You are most likely running db pools with a number of worker processes. If you look at the MySQL connections most of them will be idle. If that's the case set the db pool timeout lower. Lower the pool size down. Each worker thread opens a connection
pool to the database. If you are running 10 workers with a min db pool size of 5 and a max of 10. You will have a minimum number of 50 db connections, max 100, per server running that service.</div>
<div id="AppleMailSignature"><br>
</div>
<div id="AppleMailSignature"><br>
</div>
<div id="AppleMailSignature">I would be looking at: pool_timeout, min_pool_size, max_pool_size</div>
<div id="AppleMailSignature"><br>
</div>
<div id="AppleMailSignature"><a href="http://docs.openstack.org/developer/oslo.db/opts.html">http://docs.openstack.org/developer/oslo.db/opts.html</a></div>
<div id="AppleMailSignature"><br>
</div>
<div><br>
On May 30, 2016, at 9:24 AM, Fran Barrera <<a href="mailto:franbarrera6@gmail.com">franbarrera6@gmail.com</a>> wrote:<br>
<br>
</div>
<blockquote type="cite">
<div>
<div dir="ltr">
<div>Hi,</div>
<div><br>
</div>
<div>I'm using Mitaka on ubuntu 16.04 and I have many problems in horizon. I can see this in the logs of all components: "OperationalError: (pymysql.err.OperationalError) (1040, u'Too many connections')" If I increase the max_connections on mysql works well
a few minutes but the same error. Maybe Openstack don't close connections with Mysql. The version of Mysql is 5.7.</div>
<div><br>
</div>
<div>Any suggestions?</div>
<div><br>
</div>
<div>Regards,</div>
<div>Fran</div>
</div>
</div>
</blockquote>
<blockquote type="cite">
<div><span>_______________________________________________</span><br>
<span>OpenStack-operators mailing list</span><br>
<span><a href="mailto:OpenStack-operators@lists.openstack.org">OpenStack-operators@lists.openstack.org</a></span><br>
<span><a href="http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-operators">http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-operators</a></span><br>
</div>
</blockquote>
</body>
</html>