Lost connection to MySQL server during query

Discussion of open issues, suggestions and bugs regarding MyDAC (Data Access Components for MySQL) for Delphi, C++Builder, Lazarus (and FPC)
Posts: 186
Joined: Wed 03 Nov 2004 16:57
Location: Spain

Post by GEswin » Mon 22 Aug 2005 12:58

I have at server set

Code: Select all

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.

Posts: 1693
Joined: Thu 28 Oct 2004 13:56

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.

Posts: 12
Joined: Tue 12 Jul 2005 07:29

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.

Post Reply