Ok thanks all, I'm pretty sure a low timeout is all I'll need, but was curious about Null pool. Thanks for the info.
iain On Sat, Sep 20, 2014 at 7:52 AM, Michael Bayer <mike...@zzzcomputing.com> wrote: > > On Sep 20, 2014, at 10:50 AM, Michael Bayer <mike...@zzzcomputing.com> > wrote: > > > On Sep 19, 2014, at 8:43 PM, Iain Duncan <iainduncanli...@gmail.com> > 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? > > > with the important caveat that your app returns connections to the pool > when its idle. If you check out a connection and just hold onto it > somewhere for hours (which you shouldn’t), you can still get that error. > > > I bring this up because, pool_timeout is all you need otherwise. if you > are still getting that error with a low pool_timeout, you may want to look > into connections being released. > > > > > > Is is terribly slower? > > thanks! > Iain > > > On Fri, Sep 19, 2014 at 2:27 PM, Iain Duncan <iainduncanli...@gmail.com> > wrote: > >> Thanks guys! >> >> Iain >> >> On Fri, Sep 19, 2014 at 12:41 PM, Jonathan Vanasco <jvana...@gmail.com> >> 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 reconnect code they used in buildbot : >>> >>> >>> http://twistedmatrix.com/pipermail/twisted-python/2014-June/028410.html >>> >>> >>> >>> -- >>> You received this message because you are subscribed to the Google >>> Groups "sqlalchemy" group. >>> To unsubscribe from this group and stop receiving emails from it, send >>> an email to sqlalchemy+unsubscr...@googlegroups.com. >>> To post to this group, send email to sqlalchemy@googlegroups.com. >>> Visit this group at http://groups.google.com/group/sqlalchemy. >>> For more options, visit https://groups.google.com/d/optout. >>> >> >> > > -- > You received this message because you are subscribed to the Google Groups > "sqlalchemy" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to sqlalchemy+unsubscr...@googlegroups.com. > To post to this group, send email to sqlalchemy@googlegroups.com. > Visit this group at http://groups.google.com/group/sqlalchemy. > For more options, visit https://groups.google.com/d/optout. > > > > -- > You received this message because you are subscribed to the Google Groups > "sqlalchemy" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to sqlalchemy+unsubscr...@googlegroups.com. > To post to this group, send email to sqlalchemy@googlegroups.com. > Visit this group at http://groups.google.com/group/sqlalchemy. > For more options, visit https://groups.google.com/d/optout. > > > -- > You received this message because you are subscribed to the Google Groups > "sqlalchemy" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to sqlalchemy+unsubscr...@googlegroups.com. > To post to this group, send email to sqlalchemy@googlegroups.com. > Visit this group at http://groups.google.com/group/sqlalchemy. > For more options, visit https://groups.google.com/d/optout. > -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy+unsubscr...@googlegroups.com. To post to this group, send email to sqlalchemy@googlegroups.com. Visit this group at http://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/d/optout.