(OT?) Tweaking MySQL57

[Bill Christensen]

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 <ryandesign at macports.org 
> <mailto:ryandesign at macports.org>> 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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.macports.org/pipermail/macports-users/attachments/20170103/61604bb1/attachment.html>