MySQL has gone away

[Stephen Barncard]

this is more likely about the SQL server timeouts -- the server end, 
not your end. Some ISPs put short timeouts on their servers.

Even Dreamhost will drop after a few hours. I built a 'send in time' 
routine to ping the server every 3600 seconds to keep it alive. It 
basically calls itself forever until the app stops or it is told to 
stop. Works great.


>Do you know if there is a relationship between the socket timeout and the
>connection to a MySQL server with the revOpenDatabase function?
>When I am connected to a remote server machine and I don't send a query for
>more than 5 minutes, I obtain the error  "MySQL has gone away".
>PS
>I have tuned the server system variables in order to have a good connection
>(wait_timeout, max_allowad_packets, etc.).
>If I make the connection from the LAN I don't have this error!
>
>Thank you for your suggestions.
>
>Riccardo
>
>_______________________________________________
>use-revolution mailing list
>use-revolution at lists.runrev.com
>Please visit this url to subscribe, unsubscribe and manage your 
>subscription preferences:
>http://lists.runrev.com/mailman/listinfo/use-revolution


-- 


stephen barncard
s a n  f r a n c i s c o
- - -  - - - - - - - - -