CODEWITHSUNDEEP
phpmysqlapache
eComEvo
eComEvo

Reputation: 12559

- Large # of MySQL lost connections and failures to connect

I have been seeing a LOT of errors like this in the log files for one of our sites:

In fact, the log files are filling up with these errors. The site in question gets only 500 visitors per day, although it does process 100,000+ queries in a given day when certain background PHP scripts are run.

Connections are always closed explicitly after a script finishes. There are no persistent connections.

This happens with just about every script that is run from time to time and the MySQL server crashes a couple of times a day.

Could this be some sort of configuration issue?

Upvotes: 2

Views: 242

Answers (1)

Courtland Caldwell
Courtland Caldwell

Reputation: 578

I've seen this behavior once before in a stateless three tier architecture with load balancing at each tier. In this instance one of the app tier servers had an old password for the database credentials but all of the other app tier servers had the new correct password. Probably not your issue but your description is pretty identical.

Upvotes: 1

Related Questions