Hi, On 3/24/06, JP Farias <[EMAIL PROTECTED]> wrote: > > I've just tried turbogears and sqlobject svn versions and the problem > with #565 is still there. > > Have you tried the project I posted as test? The conntest.zip file? > I've used it to find out #565.
Actually, I hadn't tried that. What I did was (as I described in the ticket): 1) set server.thread_pool=10 2) ab -c 5 -n 20 http://localhost:8080/FrontPage (on a wiki 20) 3) mysql-admin processlist Doing this and repeating #2-3 as desired, the mysql connection count stuck at 5, showing a definite use of a connection pool. I just looked at conntest. It's not a normal use case. The common use case is that TurboGears creates the threads for you and manages that database connections/transactions. In this case, you created your own threads. The reason those connections were hanging around is that TG provides implicit transactions in 0.9. So, the transactions were being created but never closed. I added one line to conntest's controllers.py and all was well: def simpleThreadTest(): obj = TestClass(test='creating an object') time.sleep(1) hub.end() Kevin --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "TurboGears" 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/turbogears -~----------~----~----~----~------~----~------~--~---
