(OT?) Tweaking MySQL57

[Jeff Singleton]

No problem Bill. Glad to have helped.

On Tue, Jan 3, 2017 at 6:56 PM, Bill Christensen <
billc_lists at greenbuilder.com> wrote:

> 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>
> 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
>>
>>
>
>
> --
> Bill Christensenhttp://SustainableSources.comhttp://LinkedIn.com/in/billc108
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.macports.org/pipermail/macports-users/attachments/20170104/fd121aff/attachment.html>