[sqlalchemy] Re: Ping

2007-03-06 Thread percious
Problem is, using turbogears I don't really have access to the pool_recycle without some horrible monkey patch. FYI, my ping seems to work, so I'm going with that for now. cheers. -percious On Mar 5, 1:00 pm, Sébastien LELONG [EMAIL PROTECTED] securities.fr wrote: I need to ping the Mysql

[sqlalchemy] Re: Ping

2007-03-06 Thread Paul Johnston
Hi, Problem is, using turbogears I don't really have access to the pool_recycle without some horrible monkey patch. Actually, it's easy to specify parameters to create_engine, just include a line like this in your config file sqlalchemy.pool_recycle = 3600 Paul

[sqlalchemy] Re: Ping

2007-03-05 Thread Sébastien LELONG
I need to ping the Mysql database to keep it alive. Is there a simple way to do this with SA? Maybe you'd want to have a look at the pool_recycle argument of create_engine. It'll make the connection pool beeing checked if active, and potentially recycle the connections if they are too old.