No problem Bill. Glad to have helped. On Tue, Jan 3, 2017 at 6:56 PM, Bill Christensen < billc_li...@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 <ryandes...@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 > >