Accounting on SQL - sleep time

[Alan DeKok]

On Nov 10, 2017, at 5:57 AM, Andrés Gómez <andres.gomez.ruiz at gmail.com> wrote:
> I have 3 freeradius servers using the same version and configuration. The
> first one is the primary radius server for many access points and the
> second and third one are the secundary radius server fo the same access
> points.

  Are all 3 servers receiving all the same packets?

  If not, they'll behave differently.

> The behavior should be the same (because I use the same version and
> configuration of freeradius) but in the MySQL server I see that accounting
> queries from the 1st (main) one are closed very fast (least of 1 second).

  Do you have one MySQL server, or multiple servers?

> In the mysql process usually appears with 0 or 1 second of duration time:
> ...
> But about the queries from 2nd or 3th server are not closed, so I can see
> process opened from a lot of time ago:

  That's usually because the tables are lacking indexes.  Or, the queries are highly contended.

> What can I check?

  It's a database problem.

  Alan DeKok.