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 [email protected]
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
-~----------~----~----~----~------~----~------~--~---
