On 7 May 2012 02:48, Parnell Springmeyer <[email protected]> wrote:
> I have pool, pool recycle, and max overflow set... Is there something I'm
> missing? Or maybe it's the DB being hit really hard, or maybe a DB
> configuration option???

I've been through this a few times, and the main cause of this is the
server not being hit enough. Then SQLAlchemy holds a bunch of
connections which MySQL has deemed "too old" and drops them from its
side.

On one site I ended up polling the DB via a cron job. Nasty hack, but
it got the job done when none of the other options described worked.

-- 
Raoul Snyman
B.Tech Information Technology (Software Engineering)
E-Mail:   [email protected]
Web:      http://www.saturnlaboratories.co.za/
Blog:      http://blog.saturnlaboratories.co.za/
Mobile:   082 550 3754
Registered Linux User #333298 (http://counter.li.org)

-- 
You received this message because you are subscribed to the Google Groups 
"pylons-discuss" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to 
[email protected].
For more options, visit this group at 
http://groups.google.com/group/pylons-discuss?hl=en.

Reply via email to