[sqlalchemy] sqlalchemy only has 1 or 2 tcp connections to mysql server

2014-03-13 Thread Ni Wesley
Hi all, I hit a problem that cannot use the connection pool effectively. engine = create_engine(db_url,pool_size=50,max_overflow=60, echo=engine_echo,pool_recycle=3600) from sqlalchemy.sql.expression import text, bindparam from sqlalchemy.sql import select,insert, delete, update from

Re: [sqlalchemy] sqlalchemy only has 1 or 2 tcp connections to mysql server

2014-03-13 Thread Michael Bayer
On Mar 13, 2014, at 11:51 PM, Ni Wesley nisp...@gmail.com wrote: Hi all, I hit a problem that cannot use the connection pool effectively. messages_writer = DBWriter('messages') connection_writer = DBWriter('sessions_details') messages_details_writer = DBWriter('messages_details')

Re: [sqlalchemy] sqlalchemy only has 1 or 2 tcp connections to mysql server

2014-03-13 Thread Ni Wesley
No, I don't use gevent anymore, everything goes from engine, you can see I have a direct_engine=True to control 在 2014年3月14日星期五UTC+8下午12时22分09秒,Michael Bayer写道: On Mar 13, 2014, at 11:51 PM, Ni Wesley nis...@gmail.com javascript: wrote: Hi all, I hit a problem that cannot use the