MySQL has gone away
stephenREVOLUTION at barncard.com
Thu Mar 8 16:47:08 CST 2007
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".
>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.
>use-revolution mailing list
>use-revolution at lists.runrev.com
>Please visit this url to subscribe, unsubscribe and manage your
s a n f r a n c i s c o
- - - - - - - - - - - -
More information about the use-livecode