[Mono-devel-list] MySQL timeout
rykr at comcast.net
Mon Feb 21 23:02:36 EST 2005
What version of the connector are you using? We had a problem similar
to this in an earlier version. Make sure you are using the latest
Fabien Penso wrote:
>Mon, 21 Feb 2005 13:41:09 -0300, tu as dit :
> > Well it sure looks like both mono and the mysql connector are doing
> > the right thing.
> > You is the one that is responsible for dealing with such conditions,
> > if needed, as your try/catches show that you understand how.
>Well I would expect the connector to reconnect for me if there is a
>timeout, mostly if it comes from a lower layer (the socket).
> > The problem is that you should be using the common ADO.NET idiom:
> > Open Connection
> > Execute Query
> > Read Data (if needed)
> > Close Connection
> > That way scales a lot better, even for Desktop Clients, as most
> > ADO.NET providers (connectors) implement connection pooling.
> > We should just determine if the connection pool manager of the mysql
> > connector, aside from killing unused connections after a timeout that
> > can alleviate your problem, has some checkConnectionLiveness feature
> > to avoid throwing that same exception in your face, when reusing a
> > connection...
>I would have tought that is exactly the way not to do so when you use
>that in a daemon with many queries, but I guess I'm wrong again. If the
>mysql connector use a pool manager I guess it's fine, I'll try later
>today to see how it works if I connect for each query.
>Thanks for answering.
>Mono-devel-list mailing list
>Mono-devel-list at lists.ximian.com
More information about the Mono-devel-list