The MySQL database connection is unstable.

The website uses ECSHOPv2.72 mall program around IP1000 daily. The server is an independent server with a CPU of less than 10% for a long time. There is no pressure on the server. However, the mall program occasionally encounters a problem where MySQL cannot be connected, and the program reports an error. Just refresh it. The probability of a problem occurs about five times a day... the website uses the ECSHOP v2.72 mall program around 10% daily IP1000. The server is an independent server and the CPU is less than for a long time. There is no pressure on the server.
However, the mall program occasionally encounters a problem where MySQL cannot be connected. The program reports an error and refresh it. The probability is about five times a day, the appearance time is not fixed (sometimes it is detected in the early morning), the page is not fixed (the home page, commodity page, and transaction process have been there ).

The server uses WampServer 2.0c (PHP5.2.6 + MySQL5.0.51b), which is almost the default configuration.

I suspect that the number of connections in MySQL is limited, so I searched for max in my. ini, but I didn't find any suspicious problems.

You guys can answer this question ~~~~

Reply content:

The website uses the ECSHOP v2.72 mall program around 10% daily IP1000. The server is an independent server and the CPU is less than for a long time. There is no pressure on the server.
However, the mall program occasionally encounters a problem where MySQL cannot be connected. The program reports an error and refresh it. The probability is about five times a day, the appearance time is not fixed (sometimes it is detected in the early morning), the page is not fixed (the home page, commodity page, and transaction process have been there ).

The server uses WampServer 2.0c (PHP5.2.6 + MySQL5.0.51b), which is almost the default configuration.

I suspect that the number of connections in MySQL is limited, so I searched for max in my. ini, but I didn't find any suspicious problems.

You guys can answer this question ~~~~

Reduce the session expiration time in the configuration file.
Ecshop sessions exist in the database, which frequently reads and writes session-related tables of the database.

I have been impressed with persistent connections before.
In addition, it is best to paste your max value and usage information. Do not search for database parameters in the configuration file and check the maximum usage.
Troubleshooting http://lxneng.iteye.com/blog/451985 similar to the following link