<html>
<head>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<div class="moz-cite-prefix">Thanks Jeff,<br>
<br>
That was extremely helpful. <br>
<br>
On 12/23/16 9:14 AM, Jeff Singleton wrote:<br>
</div>
<blockquote
cite="mid:CALK4vP1O84Eb0Q_gAwEJJSyw13ONQqf9UjTisWGhTJBdr3pKow@mail.gmail.com"
type="cite">
<div dir="ltr">
<div class="gmail_default" style="font-family:"trebuchet
ms",sans-serif;font-size:small">Here is a script I run
against all of my MySQL instances (Both Mac and Linux)...it
will help with identifying some issues with your database
server and shows results against known CVE's.</div>
<div class="gmail_default" style="font-family:"trebuchet
ms",sans-serif;font-size:small"><br>
</div>
<div class="gmail_default"><font face="trebuchet ms, sans-serif"><a
moz-do-not-send="true"
href="https://github.com/major/MySQLTuner-perl">https://github.com/major/MySQLTuner-perl</a></font><br>
</div>
<div class="gmail_default"><font face="trebuchet ms, sans-serif"><br>
</font></div>
<div class="gmail_default"><font face="trebuchet ms, sans-serif"><br>
</font></div>
<input name="virtru-metadata"
value="{"email-policy":{"state":"closed","expirationUnit":"days","disableCopyPaste":false,"disablePrint":false,"disableForwarding":false,"expires":false,"isManaged":false},"attachments":{}}"
type="hidden"></div>
<div class="gmail_extra"><br>
<div class="gmail_quote">On Thu, Dec 22, 2016 at 6:37 AM, Ryan
Schmidt <span dir="ltr"><<a moz-do-not-send="true"
href="mailto:ryandesign@macports.org" target="_blank">ryandesign@macports.org</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0
.8ex;border-left:1px #ccc solid;padding-left:1ex"><span
class=""><br>
On Dec 21, 2016, at 20:45, Bill Christensen wrote:<br>
<br>
> I recently updated one of my servers to MySQL57.
Most of the sites on the server are WordPress - everything
is up to date. Most of the time it's working fine, but a
too large percentage of the time I'm getting "Error
establishing database connection". A short time later
it'll work fine with no changes. Traffic is not extreme.<br>
><br>
> So apparently some MySQL setting is not correct. I
tried to find a place to adjust memory or thread count etc
in my.cnf, but there was pretty much nothing in that
file. Perhaps I was looking in the wrong place?<br>
><br>
> Any hints will be greatly appreciated.<br>
<br>
</span>As I recall, the my.cnf file we ship has only one
setting in it, because that's the only setting that differs
from the defaults. You can add any other settings to the
file if you want additional changes from the defaults.
Consult MySQL documentation to learn what options are
available.<br>
<br>
<a moz-do-not-send="true"
href="http://dev.mysql.com/doc/refman/5.7/en/server-configuration-defaults.html"
rel="noreferrer" target="_blank">http://dev.mysql.com/doc/<wbr>refman/5.7/en/server-<wbr>configuration-defaults.html</a><br>
<br>
</blockquote>
</div>
<br>
</div>
</blockquote>
<br>
<p><br>
</p>
<pre class="moz-signature" cols="72">--
Bill Christensen
<a class="moz-txt-link-freetext" href="http://SustainableSources.com">http://SustainableSources.com</a>
<a class="moz-txt-link-freetext" href="http://LinkedIn.com/in/billc108">http://LinkedIn.com/in/billc108</a></pre>
</body>
</html>