slow connection on 2 mysql connection. After php4.3.10?

I am quite confident that this case set by php4.3.10 upgrade (also I have some modification for my php scripts at that time)

Let me explain the history:

:: I have three servers.

I have one mysql at specific server. Let's says mysql-A with localhost connection.

Another two mysql-connection coming from separate servers ( 2 servers), let;s say mysql-B and mysql-C with connection:

$DatabaseName = "webappl_db";
$DbHostName = "x.x.x.x"; ==> mysql-A IP
$DbUserName = "webappl_admin";
................

below situation are working for half year until problems came.
I can browse my site from above 3 locations.
Transaction speed from site mysql-B and mysql-C is acceptable and visitors can do their activities very well.


Problem comes one week ago when doing upgrading to PHP4.3.10 for all of servers.

NOW...........
We cannot do activity at mysql-B and mysql-C. They are very slow and sometimes connection timeout.
firstly I suspect server mysql-A and do changing to new one but still same.
Beside that, I can do any actions at mysql-A ...very fast without any timeout nor connection problems.

what;s happen?
Why mysql-A is fast and still can be used?
Why mysql-B and mysql-C run very slow and sometimes timeout?

Please help ME
Any comments and suggestion will be highly appreciated

Robert Xtra

 

 

 

 

Top