Ending a connection pool in mysql-connector-python

Question

I have a connection pool that I create using mysql-connector-python:

dbconfig = {
        "database": db,
        "user":     "user"
}    
cnxpool = mysql.connector.pooling.MySQLConnectionPool(pool_name = appname,
                                  pool_size = 5,
                                  **dbconfig)

In the mysql-connector API, there doesn't appear to be a method for ending a connection pool. Is there a way to end a connection pool?

DorElias · Accepted Answer · 2015-09-06 09:26:10Z

4

According to this: http://dev.mysql.com/doc/connector-python/en/connector-python-connection-pooling.html

You can just call the close() method of the pool

EDIT :

As commented, this will not close the pool, it will only return the connection to the pool.

I looked at this source code https://github.com/mysql/mysql-connector-python/blob/master/lib/mysql/connector/pooling.py

And it looks like the only method that will do it is _remove_connections but it is intended for testing.

edited Sep 6, 2015 at 9:26

answered Sep 6, 2015 at 8:51

DorElias

2,31316 silver badges18 bronze badges

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

3 Comments

Mark Over a year ago

According to the docs, that method is for returning an individual connection to the pool. It doesn't look like that method can be called on a pool. Am I wrong?

Mark Over a year ago

It says "mostly for testing", but looks like it will accomplish what I want. I will test it to make sure.

Magnus Lind Oxlund Over a year ago

The GitHub link is dead. Here's a live one.

Collectives™ on Stack Overflow

Ending a connection pool in mysql-connector-python

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related