Lost connection to MySQL server during query

GEswin · Post by **GEswin** » Mon 22 Aug 2005 12:58

I have at server set

wait_timeout	      28800
interactive_timeout  28800

These are default values, and never experienced any problems. Using mysql 4.1.03 up to 4.1.13a. Perhaps you changed this and there isn't really the need to do it.

Ikar · Post by **Ikar** » Mon 22 Aug 2005 13:30

> I think components should reconnect automatic, like DBX did.

Automatic reconnection is performed but a query not passed to the server again.

In general for cases with unstable connection (GPRS etc) it would be correct to use СachedUpdates along with transactions.

solata · Post by **solata** » Mon 22 Aug 2005 14:32

Anyway the problem is solved with ping and biggest timeout.

I think implementing this in new MyDac release would be great.

Thank you GEswin and Ikar.