On Nov 10, 2017, at 5:57 AM, Andrés Gómez <andres.gomez.ruiz@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.