MySQL Connection Probelms with PHP

OK Im having trouble with connections to a MySQL (3.23.55) server (through PHP scripts).


When using mysql_connect & closing the connection at the end of the page, the server load is around 0.4 - 0.8. Now when using pconnect is decreses dramatically to 0.01 - 0.35 ish.

Probelm is when its peak of the day and im using pconnect, some new visitors wont be able to get on. They get a connection error (the error number is 111).

I have tried a number of things to solve this some have helped but I still have the same problem.

Things Ive tried:

1. Decreased "wait timeout" from default to 40 seconds.
2. Increased "max connections".
3. Increased "thread cache size".

Any ideas on how to solve the problem? Will upgrading to v4 help?

Thanks in advance.

 

 

 

 

Top