Python MySQL connection pooling

Question

I've looked through stackoverflow and can see some oldish posts on this and wondered what the current thinking is about pooling connections in Python for MySQL.

We have a set of python processes that are threading with each thread creating a connection to MySQL. This all works fine, but we can have over 150 connections to MySQL.

When I look at the process state in MySQL I can see that most of the connections are asleep most of the time. The application is connecting to a Twitter streaming API so its busy but this only accounts for a few connections.

Is there a good way of adding connection pooling to Python MySQL and can this be done simply without re-writing all of the existing code?

Many thanks.

PT

If you decide you want to re-write code, SQLAlchemy handles this effectively (http://www.sqlalchemy.org) — Adam Morris, Nov 29 '11 at 09:22

score 1 · Answer 1 · answered Nov 29 '11 at 08:37

1

See DBUtils

Maybe you have an abstract layer for MySQL, you can modify this layer to avoid rewriting all the code.

If not, you have to hack your Python-MySQL driver.

answered Nov 29 '11 at 08:37

ukessi

1,381
1
10
15

Python MySQL connection pooling

1 Answers1