<div dir="ltr"><div style>Jay,</div><div style><br></div><div style>I increased the max_connection to 2000 and so far don't see any issue.</div><div style>After launching 20 VMs the number of connections as follows: </div><div><div><br></div><div>Mon Sep 29 05:05:29 PDT 2014</div><div>Number of open TCP:3306 - 326</div><div>Number of open TCP:3306 nova-api - 34</div><div>Number of open TCP:3306 mysqld - 163</div><div>Number of open TCP:8774 - 66</div><div>Number of nova-api - 98</div></div><div><br></div><div style>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? </div><div style><br></div><div style><br></div><div style>Thanks for the help.</div><div style>Nader.</div><div style><br></div><div><br></div></div><div class="gmail_extra"><br><div class="gmail_quote">On Mon, Sep 29, 2014 at 10:41 AM, Jay Pipes <span dir="ltr"><<a href="mailto:jaypipes@gmail.com" target="_blank">jaypipes@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><span class="">On 09/29/2014 01:34 PM, Nader Lahouti wrote:<br>
</span><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><span class="">
On Mon, Sep 29, 2014 at 9:58 AM, Jay Pipes <<a href="mailto:jaypipes@gmail.com" target="_blank">jaypipes@gmail.com</a><br></span><span class="">
<mailto:<a href="mailto:jaypipes@gmail.com" target="_blank">jaypipes@gmail.com</a>>> wrote:<br>
<br>
On 09/29/2014 12:48 PM, Nader Lahouti wrote:<br>
<br>
Hi Jay,<br>
<br>
I login first and the recreated the problem and here is the log:<br></span>
<a href="http://paste.openstack.org/__show/116776/" target="_blank">http://paste.openstack.org/__<u></u>show/116776/</a><span class=""><br>
<<a href="http://paste.openstack.org/show/116776/" target="_blank">http://paste.openstack.org/<u></u>show/116776/</a>><br>
<br>
<br>
OK. Looks like there isn't anything wrong with your setup. I'm<br>
guessing you have set up Keystone to run in Apache with 10 worker<br>
processes, and you have the workers config option setting in<br>
nova.conf, neutron.conf and all the other project configuration<br>
files set to 0, which will trigger a number of worker processes<br>
equal to the number of CPU cores on your box, which I'm guessing<br>
from looking at your SHOW FULL PROCESSLIST is around 24-32 cores.<br>
<br>
<br>
I haven't modified the default values in *.conf files (I'm using<br>
devstack for installation) for workers setting.<br>
How to check that keystone is using apache with 10 worker process?<br>
And the number of CPU cores on my box is 32.<br>
</span></blockquote>
<br>
OK, as I suspected.<span class=""><br>
<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
Solution: either lower the workers configuration option from 0 to<br>
something like 12, or increase the max_connections setting in your<br>
my.cnf to something that can handle the worker processes from all<br>
the OpenStack services (I'd recommend something like 2000).<br>
<br>
<br>
Just for clarification, regarding the setting of workers option in the<br>
*.conf file:<br>
Fore neutron:<br>
# api_workers = 0<br>
<br>
For nova, what option should be set?<br>
I see these options:<br>
metadata_workers=None (IntOpt)Number of workers for metadata service<br>
</blockquote>
<br></span>
You can keep all those options as-is (the default of 0) and just set your my.cnf max_connections variable to 2000.<div class="HOEnZb"><div class="h5"><br>
<br>
Best,<br>
-jay<br>
<br>
______________________________<u></u>_________________<br>
OpenStack-dev mailing list<br>
<a href="mailto:OpenStack-dev@lists.openstack.org" target="_blank">OpenStack-dev@lists.openstack.<u></u>org</a><br>
<a href="http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev" target="_blank">http://lists.openstack.org/<u></u>cgi-bin/mailman/listinfo/<u></u>openstack-dev</a><br>
</div></div></blockquote></div><br></div>