Re: [sqlalchemy] SQLAlchemy leaves MySQL open connections

Thank you again Simon for more detail. This helps a lot in understanding how pooling works and how should I solve the problems in my system. Ahmad -- SQLAlchemy - The Python SQL Toolkit and Object Relational Mapper http://www.sqlalchemy.org/ To post example code, please provide an MCVE:

Re: [sqlalchemy] SQLAlchemy leaves MySQL open connections

On Mon, Nov 13, 2017 at 4:35 PM, Ahmad Javed wrote: > Thank you Simon. Appreciate your response. Just using session.remove() at > the end of each request is not closing the connection and leave open > connections in MySQL database. One more thing I want to tell that we

Re: [sqlalchemy] SQLAlchemy leaves MySQL open connections

Thank you Simon. Appreciate your response. Just using session.remove() at the end of each request is not closing the connection and leave open connections in MySQL database. One more thing I want to tell that we have deployed Django applications with *uwsgi* and *nginx*. -- SQLAlchemy - The

Re: [sqlalchemy] SQLAlchemy leaves MySQL open connections

On Mon, Nov 13, 2017 at 3:58 AM, Ahmad Javed wrote: > Hi, > > We have implemented web applications using Django and SQLAlchemy framework. > We have distributed system in the company and some API used frequently. > > We are facing a problem where MySQL connections reached

[sqlalchemy] SQLAlchemy leaves MySQL open connections

Hi, We have implemented web applications using Django and SQLAlchemy framework. We have distributed system in the company and some API used frequently. We are facing a problem where MySQL connections reached a maximum limit. In Django applications, we are using SQLAlchemy with *pool engine*