Freeradius-Users Digest, Vol 53, Issue 11

[Ivan Kalik]

> I deactivated buffered-sql and logging directly to mysql by deafult
> module.
> Just one basic question :
> Buffered_SQL is single threaded module? and does not make use of available
> mysql threads to complete the jobs in parallel?

No, but near enough. Detail reader deliberately reads packets at a reduced
rate.

Authentication queries are fast - about 10x faster than accounting
queries. On top of that you should aim to complete authentication as quick
as possible, while if there is a delay in processing accounting data of a
few seconds it's hardly going to get noticed.

Imagine authentication queries as fast cars and acconting queries as a
slow lorries. The idea of buffered-sql is to separate out lorries into a
slow lane and leave motorway clear for fast cars to wizz by.

You can increase the speed at which detail reader works but the effect of
that would be to spread out lorries all over the motorway, slowing the
cars down.

Even if the reader gets stuck and lane with the lorries stops, the
authentication will still work, and new lorries will pile up at the back
of the slow lane. Once you get the lane working again, lorries will be on
their way, again with no impact to authentication (cars).

Ivan Kalik
Kalik Informatika ISP