Hello Again Michael, > This makes perfect sense to me, I've been looking at my application > log data this morning and can see the connections being created, > pooled and checked out exactly as I would expect which is a very good > sign. > > I can however see that my application can potentialy see a large > number of connections in use though, perhaps a maximum of around 30 at > any one time due to concurrent 'threads' in the FSM, I'll look into > changing the configuration options and creating a bigger pool, this > will no doubt help the situation. > > Cheers for your advice, > > Heston
So, I've made some changes to my code which as I understand it should bump my connection pool right up, I've done this like so: # Create the engine to the database. # Add a custom overflow and larger pool size, this should help matters. engine = create_engine(connection_string, echo=False, pool_size=42, max_overflow=10) Now, how can I ensure these settings are applied properly? I've enabled logging on the sqlalchemy.pool namespace and get log output like this: 2008-10-20 10:35:46,173 pool.py 212 INFO Created new connection <_mysql.connection open to 'localhost' at 8713904> 2008-10-20 10:35:46,174 pool.py 212 INFO Connection <_mysql.connection open to 'localhost' at 8713904> checked out from pool 2008-10-20 10:35:46,225 pool.py 212 INFO Created new connection <_mysql.connection open to 'localhost' at 87825fc> 2008-10-20 10:35:46,226 pool.py 212 INFO Connection <_mysql.connection open to 'localhost' at 87825fc> checked out from pool 2008-10-20 10:35:46,294 pool.py 212 INFO Connection <_mysql.connection open to 'localhost' at 87825fc> being returned to pool 2008-10-20 10:35:46,327 pool.py 212 INFO Connection <_mysql.connection open to 'localhost' at 8713904> being returned to pool 2008-10-20 10:35:55,938 pool.py 212 INFO Connection <_mysql.connection open to 'localhost' at 87825fc> checked out from pool 2008-10-20 10:35:55,964 pool.py 212 INFO Connection <_mysql.connection open to 'localhost' at 8713904> checked out from pool 2008-10-20 10:35:56,002 pool.py 212 INFO Connection <_mysql.connection open to 'localhost' at 8713904> being returned to pool 2008-10-20 10:35:56,033 pool.py 212 INFO Connection <_mysql.connection open to 'localhost' at 87825fc> being returned to pool This is fine, however, I was hoping it would give me details on my pool size, remaining connections, if it was using the overflow connections etc. Have I gone about this in the correct manor? Many thanks, Heston --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---