<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:quot;
panose-1:0 0 0 0 0 0 0 0 0 0;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:#954F72;
text-decoration:underline;}
p.msonormal0, li.msonormal0, div.msonormal0
{mso-style-name:msonormal;
mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
span.EmailStyle18
{mso-style-type:personal;
font-family:"Calibri",sans-serif;
color:windowtext;}
span.EmailStyle21
{mso-style-type:personal-compose;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-US" link="#0563C1" vlink="#954F72">
<div class="WordSection1">
<p class="MsoNormal">We’re not setting max_pool_size nor max_overflow option presently. I googled around and found this document:<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><a href="https://docs.openstack.org/keystone/stein/configuration/config-options.html">https://docs.openstack.org/keystone/stein/configuration/config-options.html</a><o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Document says:<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">[api_database]<o:p></o:p></p>
<p class="MsoNormal">connection_recycle_time = 3600 (Integer) Timeout before idle SQL connections are reaped.<o:p></o:p></p>
<p class="MsoNormal">max_overflow = None (Integer) If set, use this value for max_overflow with SQLAlchemy.<o:p></o:p></p>
<p class="MsoNormal">max_pool_size = None (Integer) Maximum number of SQL connections to keep open in a pool.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">[database]<o:p></o:p></p>
<p class="MsoNormal">connection_recycle_time = 3600 (Integer) Timeout before idle SQL connections are reaped.<o:p></o:p></p>
<p class="MsoNormal">min_pool_size = 1 (Integer) Minimum number of SQL connections to keep open in a pool.<o:p></o:p></p>
<p class="MsoNormal">max_overflow = 50 (Integer) If set, use this value for max_overflow with SQLAlchemy.<o:p></o:p></p>
<p class="MsoNormal">max_pool_size = None (Integer) Maximum number of SQL connections to keep open in a pool.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">If min_pool_size is >0, would that cause at least 1 connection to remain open until it times out? What are the recommended values for these, to allow unused connections to close before they time out? Is “min_pool_size = 0” an acceptable
setting?<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">My settings are default:<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">[api_database]:<o:p></o:p></p>
<p class="MsoNormal">#connection_recycle_time = 3600<o:p></o:p></p>
<p class="MsoNormal">#max_overflow = <None><o:p></o:p></p>
<p class="MsoNormal">#max_pool_size = <None><o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">[database]:<o:p></o:p></p>
<p class="MsoNormal">#connection_recycle_time = 3600<o:p></o:p></p>
<p class="MsoNormal">#min_pool_size = 1<o:p></o:p></p>
<p class="MsoNormal">#max_overflow = 50<o:p></o:p></p>
<p class="MsoNormal">#max_pool_size = 5<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">It’s not obvious what max_overflow does. Where can I find a document that explains more about these settings?<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><b>From:</b> Gaëtan Trellu <gaetan.trellu@incloudus.com> <br>
<b>Sent:</b> Tuesday, September 3, 2019 1:37 PM<br>
<b>To:</b> Albert Braden <albertb@synopsys.com><br>
<b>Cc:</b> openstack-discuss@lists.openstack.org<br>
<b>Subject:</b> Re: Nova causes MySQL timeouts<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<p class="MsoNormal">Hi Albert,<o:p></o:p></p>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">It is a configuration issue, have a look to max_pool_size and max_overflow options under [database] section. <o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">Keep in mind than more workers you will have more connections will be opened on the database.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">Gaetan (goldyfruit)<o:p></o:p></p>
</div>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<p class="MsoNormal">On Sep 3, 2019 4:31 PM, Albert Braden <<a href="mailto:Albert.Braden@synopsys.com">Albert.Braden@synopsys.com</a>> wrote:<o:p></o:p></p>
<blockquote style="border:none;border-left:solid #CCCCCC 1.0pt;padding:0in 0in 0in 6.0pt;margin-left:4.8pt;margin-top:5.0pt;margin-right:0in;margin-bottom:5.0pt">
<div>
<div>
<p style="margin-bottom:10.5pt;line-height:14.7pt"><span style="font-size:10.5pt;font-family:"quot",serif;color:#4B4B4B">It looks like nova is keeping mysql connections open until they time out. How are others responding to this issue? Do you just ignore the
mysql errors, or is it possible to change configuration so that nova closes and reopens connections before they time out? Or is there a way to stop mysql from logging these aborted connections without hiding real issues?</span><o:p></o:p></p>
<p style="margin:0in;margin-bottom:.0001pt;line-height:14.7pt"><span style="font-size:10.5pt;font-family:"quot",serif;color:#4B4B4B">Aborted connection 10726 to db: 'nova' user: 'nova' host: 'asdf' (Got timeout reading communication packets)</span><o:p></o:p></p>
<p> <o:p></o:p></p>
</div>
</div>
</blockquote>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</div>
</body>
</html>