Thanks Jeff,
That was extremely helpful.
On 12/23/16 9:14 AM, Jeff Singleton wrote:
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.
https://github.com/major/MySQLTuner-perl
On Thu, Dec 22, 2016 at 6:37 AM, Ryan Schmidt <[email protected]
<mailto:[email protected]>> wrote:
On Dec 21, 2016, at 20:45, Bill Christensen wrote:
> 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.
>
> 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?
>
> Any hints will be greatly appreciated.
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.
http://dev.mysql.com/doc/refman/5.7/en/server-configuration-defaults.html
<http://dev.mysql.com/doc/refman/5.7/en/server-configuration-defaults.html>
--
Bill Christensen
http://SustainableSources.com
http://LinkedIn.com/in/billc108
