Hi, On 27.05.2025 14:52, Winfield, Alister (Senior Solutions Architect) via Freeradius-Users wrote:
Last attempt, assuming the connection pool is full and thus no connection delays causing issues.
Connection pool is not full. # cat sel SELECT `ID`, `USER`, `HOST`, `DB`, `COMMAND`, `TIME`, `STATE`, `TIME_MS`, `STAGE`, `MAX_STAGE` FROM `information_schema`.`PROCESSLIST` WHERE db = 'raddbdhcp' AND USER = 'raduser' AND HOST = 'localhost' ORDER BY TIME_MS DESC LIMIT 10; # mysql -u raduser -pradpass raddbdhcp < sel ID USER HOST DB COMMAND TIME STATE TIME_MS STAGE MAX_STAGE 23031 raduser localhost raddbdhcp Sleep 2216 NULL 2216113.858 0 0 23182 raduser localhost raddbdhcp Sleep 2216 NULL 2216017.958 0 0 23183 raduser localhost raddbdhcp Sleep 2216 NULL 2216017.365 0 0 23184 raduser localhost raddbdhcp Sleep 2216 NULL 2216016.864 0 0 23185 raduser localhost raddbdhcp Sleep 2216 NULL 2216016.252 0 0 23186 raduser localhost raddbdhcp Sleep 2216 NULL 2216015.731 0 0 23371 raduser localhost raddbdhcp Sleep 0 NULL 373.294 0 0 23435 raduser localhost raddbdhcp Sleep 0 NULL 372.700 0 0 23420 raduser localhost raddbdhcp Sleep 0 NULL 371.557 0 0 23434 raduser localhost raddbdhcp Sleep 0 NULL 370.378 0 0
Take your ‘average response time in seconds’ and max_pool_size
How to find out 'average response time in seconds' ? Sergey Kodentsev