Relationship between Thread Pool and Sql Pool
Hi, I would like to ask about how the SQL connection pool works in FreeRADIUS. Does each thread use a separate connection from the pool, or can the same connection be used simultaneously by multiple threads? Can I basically say 1 Accounting/Access Request = 1 Thread = 1 Connection from pool?
On Sep 10, 2025, at 3:35 PM, Erdal Emlik via Freeradius-Users <freeradius-users@lists.freeradius.org> wrote:
Hi, I would like to ask about how the SQL connection pool works in FreeRADIUS. Does each thread use a separate connection from the pool, or can the same connection be used simultaneously by multiple threads? Can I basically say 1 Accounting/Access Request = 1 Thread = 1 Connection from pool?
The threads all share a connection pool. But it is impossible for multiple threads to share one connection at the same time. However, as soon as a thread is done using a connection, it is returned to the pool. Another thread can then pick it up from the pool and use it. Alan DeKok.
participants (2)
-
Alan DeKok -
Erdal Emlik