[CONPY-13] implement pooling Created: 2018-07-24  Updated: 2021-02-15  Resolved: 2019-12-19

Status: Closed
Project: MariaDB Connector/Python
Component/s: Generic
Affects Version/s: None
Fix Version/s: 0.9.52

Type: Task Priority: Critical
Reporter: Diego Dupin Assignee: Georg Richter
Resolution: Fixed Votes: 0
Labels: None


 Description   

like https://dev.mysql.com/doc/connector-python/en/connector-python-connection-pooling.html
new option like MySQL connector :

  • pool_name
  • pool_size

other option I would recommend :

  • acquireTimeout : timeout to get a new connection
  • minDelayValidation : When asking a connection to pool, the pool will validate the connection state with a ping command. "minDelayValidation" permits disabling this validation if the connection has been borrowed recently avoiding useless verifications in case of frequent reuse of connections. 0 would mean validation has to be done each time the connection is asked.

 Comments   
Comment by Georg Richter [ 2018-07-30 ]

I would prefer a generic pooling implementation in Connector/C, so it could be used also by Connector/ODBC,

Comment by Diego Dupin [ 2018-08-20 ]

That would clearly make more sense. I've created CONC-353 to implement that for C/C

Comment by Ralf Gebhardt [ 2019-08-07 ]

Also MariaDB Connector/C++ will need a connection pool, which seconds to get this implemented in C/C

Comment by Ralf Gebhardt [ 2019-12-09 ]

Connection pool was now implemented directly in C/Python.
georg, I have selected fixVersion 0.9.4, is this correct?

Generated at Thu Feb 08 03:29:36 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.