Accounting on SQL - sleep time
Hi dear list. 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. 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). In the mysql process usually appears with 0 or 1 second of duration time: | 3502 | user | FIRST:42048 | radius | Sleep | 1 | | NULL | 0 | 1 | | 3504 | user | FIRST:42050 | radius | Sleep | 1 | | NULL | 0 | 0 | | 3505 | user | FIRST:42052 | radius | Sleep | 1 | | NULL | 0 | 0 | But about the queries from 2nd or 3th server are not closed, so I can see process opened from a lot of time ago: | 1912220 | user | SECOND:36298 | radius | Sleep | 7471 | | NULL | 0 | 0 | | 1913262 | user | SECOND:37010 | radius | Sleep | 7077 | | NULL | 0 | 0 | | 1913816 | user | SECOND:37384 | radius | Sleep | 6871 | | NULL | 0 | 0 | | 1948365 | user | THIRD:39115 | radius | Sleep | 733 | | NULL | 0 | 0 | | 1948368 | user | THIRD:39117 | radius | Sleep | 733 | | NULL | 0 | 0 | | 1948369 | user | THIRD:39118 | radius | Sleep | 733 | | NULL | 0 | 0 | What can I check? Thanks in advance! Regards -- *C. Andrés Gómez R.*
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.
participants (2)
-
Alan DeKok -
Andrés Gómez