Welcome to WebmasterWorld Guest from 220.127.116.11
Forum Moderators: open
For some reason, every day or so, my main site will timeout. The other static/php sites that don't use the external MySQL server still work fine on the IIS server. IISReset doesn't do anything to fix it. For some reason the MySQL connection over crossconnect just times out.
The only way to fix this is to restart the IIS/PHP server. Strange eh? Nothing shows up in Event Viewer and both servers appear to be fine, except that the MySQL connection keeps timing out.
Does anyone have any ideas, as I have been battling with this for weeks. The Planet support are looking into it, but its fair to say that its hard for them to fix it without being able to see the problem in action.
Does anyone have any ideas or suggestions on how I can tackle this problem?
What type of database connections are used by the applications -- persistent connects? non-persistent?
Opening too many persistent connects but never closing them may be a problem but should give you some 'too many sessions' error messages.
Is there a firewall in between the 2 servers, which may cut long running sessions?
On Linux systems I would check the logs first, but don't know how the log situation is in Windows -- is there an IIS log you could look into? Does the PHP indeed say 'timeout' only? What is in the MySQL log? Try to gather as much log information you can get, on both ends.
It is using persistant connections, do you think it would help if that was changed? No firewall between the two servers either.
I'll have a look at the logs now and see what I can find.