Re: [sqlalchemy] Curious about the rationale behind the design of the pool_recycle setting

2017-10-27 Thread André Caron
day, October 27, 2017 at 10:26:50 AM UTC-4, André Caron wrote: >> >> FYI, I tried this out and updated my GitHub project to reflect your >> excellent insight. >> > > Since your connections were large enough to notice an effect in > production, if you have spare time I

Re: [sqlalchemy] Curious about the rationale behind the design of the pool_recycle setting

2017-10-27 Thread André Caron
FYI, I tried this out and updated my GitHub project to reflect your excellent insight. Thanks again! André On Thu, Oct 26, 2017 at 11:40 PM, André Caron <andre.l.ca...@gmail.com> wrote: > Thanksl Mike and Jonathan! I wasn't expecting such good advice and such > detailed response

Re: [sqlalchemy] Curious about the rationale behind the design of the pool_recycle setting

2017-10-26 Thread André Caron
Thanksl Mike and Jonathan! I wasn't expecting such good advice and such detailed responses so quickly :-) > The rationale they give is sort of along the lines of what my thinking was as well, that of the "misbehaving database connection" that leaks memory either on the client or server and needs

[sqlalchemy] Curious about the rationale behind the design of the pool_recycle setting

2017-10-26 Thread André Caron
Hi there! It's my first time on this list. Don't be shy to tell me if this isn't the right channel to discuss this :-) When looking at MySQL metrics on our production deployment of MySQL, I noticed a hammer effect in the number of new connections to MySQL. In short, when there is a sudden