How to ensure the MySQL connection is returned to connection pool with MySQL Python Connector?

Question

I'm using the official python MySQL connector and I want to use its connection pool to manage the connections. The question is, if I get a connection from the pool, an uncaught exception is thrown before the connection is returned to the pool or I just forget to close it, will the pool close the connection automatically? If not, how can I make sure that the connection can be returned to the pool under any circumstances?

For example:

import mysql.connector as mysql

pool = mysql.pooling.MySQLConnectionPool(pool_name = "name", pool_size = 3, pool_reset_session = True, **dbConfig)
for i in range(3):
    cnx = pool.get_connection()
    #if I forget to call cnx.close(), the pool will be exhausted

# now the pool is exhausted
cnx = pool.get_connection() #PoolError is raised

u need "with" context manager

Murali Mopuru
– Murali Mopuru

2015-03-11 13:03:24 +00:00
Commented Mar 11, 2015 at 13:03 — Murali Mopuru
– Murali Mopuru, Commented Mar 11, 2015 at 13:03

Kaz · Accepted Answer · 2019-10-02 23:56:54Z

1

You can use contextlib.closing() as follows.

from contextlib import closing
.....
for i in range(3):  
    with closing(pool.get_connection()) as cnx:  
        # use cnx here
        print cnx
    # cnx.close() is called automatically

answered Oct 2, 2019 at 23:56

Kaz

8467 silver badges11 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to ensure the MySQL connection is returned to connection pool with MySQL Python Connector?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related