Hi,
I try to use SA together with mod_python and its publisher algorithm.
How can I limit the number of opened connections?
I use Mysql as db, Apache2.2.6 prefork, mod_python and SA.
There are only 8 Apache childs running, but a lot more connections open.
I have the problem that connections are never closed, so after some time
the mysql sever doesn't handle any more requests.
A simple script like:
engine = create_engine('mysql://[EMAIL
PROTECTED]/pflaesterer?use_unicode=True&charset=utf8',
encoding = 'utf8', convert_unicode=False,
pool_recycle=1, pool_size=1, echo_pool=True,
strategy='threadlocal')
meta = MetaData()
meta.bind = engine
def index(req):
conn = engine.connect()
conn.close()
return 'hier'
called ten times gives me 10 opened connections.
This is at the moment only for my private Apache but how would I do it right
if I had lots of requests (let's say most of the time 60 -70 Apache childs
running). At work I use PHP (I would prefer Python) and we don't use persistent
connections and no connection pool. So there is no problem with too much opened
connections.
TIA
Karl
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
