FR 2.2.1 rlm_sqlippool / mysql 5.5.31 - deadlocks
aland at deployingradius.com
Mon Nov 25 15:31:22 CET 2013
George Chelidze wrote:
> Investigating the source code for rlm_sqlippool brought me to an idea
> that moving "CLEAR" query to the distinct transaction can help, because
> I can't really see any good reason to keep it in the same transaction
> with "FIND". I have made required minor changes and gave it a try: for
> two days the server is running without a single deadlock.
Looks good. I'll commit a patch.
It should also be doing the CLEAR only once per second. It doesn't
make sense to do it on every FIND. That's just unnecessary overhead.
More information about the Freeradius-Devel