Page is a not externally linkable
- Code, Content, and Presentation
-- Databases
---- MySQL Timeout over crossconnect


Romeo - 2:34 pm on Sep 26, 2005 (gmt 0)


Hi Ian,

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.

Regards,
R.


Thread source:: http://www.webmasterworld.com/databases_sql_mysql/44.htm
Brought to you by WebmasterWorld: http://www.webmasterworld.com