Re: DBI connection springs back to life

Driver specific behaviour. From DBD::mysql manual:

DBD::mysql has a "reconnect" feature that handles the so-called MySQL "morning bug":
If the server has disconnected, most probably due to a timeout, then by default the driver will reconnect and attempt to execute the same SQL statement again.

However, this behaviour is disabled when AutoCommit is off: Otherwise the transaction state would be completely unpredictable after a reconnect.

Comment on Re: DBI connection springs back to life - how?

Replies are listed 'Best First'.
Re: Re: DBI connection springs back to life - how? by mp (Deacon) on Jul 26, 2002 at 15:18 UTC
Thank you. The version I was using (2.0419) doesn't have that statement in the docs, but apparently must have that feature as well. I think it's time I upgrade DBD::mysql.	[reply]