MySQL Server connection timeout or keep-alive

[Paul Neuwirth]

> >> Hello,
> >> is it possible to change somewhere the connection timeout to a
> >> MySQL server on the client side?
> >> Or could it be possible to implement a keep-alive?
> >> Everytime the connection is lost, I need to restart gnucash.  
> >
> > I don't think that it's possible from the client. IIUC (and I'm not
> > a MySQL expert, but if you're using it you should be or you should
> > hire one) it's a server-side parameter called wait_timeout.
> >
> > No, we're not going to add a keep-alive.
> > https://stackoverflow.com/questions/23399111/safely-keeping-mysql-connections-alive
> > says that a connection pool is the right way to handle this, but
> > the database abstraction library we use doesn't support that so
> > it's not going to get added any time soon.  
> 
> However if GnuCash fails in a non-recoverable way when you lose the
> connection I would have thought that would be a bug.  What exact
> symptom are you seeing?
> 
> Colin

I am wondering, if no keep-alive is going to be implemented, if a
connection loss could be catched and connect again..
the error message is:
"Unable to save to database."

regards,
paul