What is the best solution for database connection pooling in python?

by

In MySQL?

I’d say don’t bother with the connection pooling. They’re often a source of trouble and with MySQL they’re not going to bring you the performance advantage you’re hoping for. This road may be a lot of effort to follow–politically–because there’s so much best practices hand waving and textbook verbiage in this space about the advantages of connection pooling.

Connection pools are simply a bridge between the post-web era of stateless applications (e.g. HTTP protocol) and the pre-web era of stateful long-lived batch processing applications. Since connections were very expensive in pre-web databases (since no one used to care too much about how long a connection took to establish), post-web applications devised this connection pool scheme so that every hit didn’t incur this huge processing overhead on the RDBMS.

Since MySQL is more of a web-era RDBMS, connections are extremely lightweight and fast. I have written many high volume web applications that don’t use a connection pool at all for MySQL.

This is a complication you may benefit from doing without, so long as there isn’t a political obstacle to overcome.

More Related Contents:

  1. Python read from txt and save into mysql
  2. MySQL parameterized queries
  3. Lost connection to MySQL server during query
  4. How to install Python MySQLdb module using pip?
  5. Does Python support MySQL prepared statements?
  6. How to convert SQL Query result to PANDAS Data Structure?
  7. How do I get the “id” after INSERT into MySQL database with Python?
  8. Escape string Python for MySQL
  9. How to install MySQLdb (Python data access library to MySQL) on Mac OS X?
  10. pip install mysqlclient returns “fatal error C1083: Cannot open file: ‘mysql.h’: No such file or directory
  11. Cannot return results from stored procedure using Python cursor
  12. How do I get a raw, compiled SQL query from a SQLAlchemy expression?
  13. Inserting a Python datetime.datetime object into MySQL
  14. MySQL — Joins Between Databases On Different Servers Using Python?
  15. How to retrieve SQL result column value using column name in Python?
  16. Is the Session object from Python’s Requests library thread safe?
  17. Using a Python dict for a SQL INSERT statement
  18. Bulk insert with SQLAlchemy ORM
  19. RuntimeError: working outside of application context
  20. Why are some mysql connections selecting old data the mysql database after a delete + insert?
  21. ImportError: No module named MySQLdb
  22. Can’t install mysql-python (newer versions) in Windows
  23. Using Django database layer outside of Django?
  24. How to move a model between two Django apps (Django 1.7)
  25. How do i cast char to integer while querying in django ORM?
  26. flake8 complains on boolean comparison “==” in filter clause
  27. How do I get time from a datetime.timedelta object?
  28. Python issue:Unable to find vcvarsall.bat [duplicate]
  29. pip install mysqlclient : Microsoft Visual C++ 14.0 is required
  30. Installing mysql-python on Centos

Leave a Comment