Re: [sqlalchemy] Re: queue pooling, mysql sleeping, for very occasional use apps?

2014-09-19 Thread Jeff Dairiki
On Fri, Sep 19, 2014 at 05:43:46PM -0700, Iain Duncan wrote: > So can anyone tell me what exactly happens with NullPool, I'm not clear > from the docs. Does that mean a fresh connection will be made on a new hit, > and we'll never get the "gone away", but at the expense of slower > connections? Ye

Re: [sqlalchemy] Re: queue pooling, mysql sleeping, for very occasional use apps?

2014-09-19 Thread Iain Duncan
So can anyone tell me what exactly happens with NullPool, I'm not clear from the docs. Does that mean a fresh connection will be made on a new hit, and we'll never get the "gone away", but at the expense of slower connections? Is is terribly slower? thanks! Iain On Fri, Sep 19, 2014 at 2:27 PM,

Re: [sqlalchemy] Re: queue pooling, mysql sleeping, for very occasional use apps?

2014-09-19 Thread Iain Duncan
Thanks guys! Iain On Fri, Sep 19, 2014 at 12:41 PM, Jonathan Vanasco wrote: > Just to add to jeff's response, I had a similar situation with Postgres > under a twisted app a while back. > > Someone else on the twisted list was using Mysql + Twisted + Sqlalchemy > and pointed to some pessimistic

[sqlalchemy] Re: queue pooling, mysql sleeping, for very occasional use apps?

2014-09-19 Thread Jonathan Vanasco
Just to add to jeff's response, I had a similar situation with Postgres under a twisted app a while back. Someone else on the twisted list was using Mysql + Twisted + Sqlalchemy and pointed to some pessimistic reconnect code they used in buildbot : http://twistedmatrix.com/pipermail/twi