Performance issues

[Imdad Hasan]

Hi Alen,

Right now in current version of my app,

1.) For accounting i am using pre-compiled FreeRADIUS queries with two
tables approach one radacct for live and another for closed sessions.

2.) In update control i am updating in/out octets on another table for
specific user total usage. (Also for Accounting)

3.) For Authentication/Authorization i am still using exec with php script,
i am planning to move on perl, but still confuse because of some old posts
about perl module.

- MySQL server have 32GB RAM and 8-Core CPU with Mysql
READ-COMMITED isolation mode.
- MySQL server CPU usage is max to max 10% to 15% On high load.

- FreeRADIUS server have 4GB RAM and 2-Core CPU.
- FreeRADIUS server CPU usage is around 50 to 75%. but the half of total
usage (around 30%) is by the system kernel itself. mostly these two
function of the kernel.


*5.29%  [kernel]                                      [k]
copy_pte_range.isra.0   4.52%  [kernel]
 [k] zap_pte_range.isra.0*

- MySQL and FreeRADIUS is linked in the local network in one VPC of Amazon
AWS.

- The average load of internet subscriber is around 35k. and i set 5mins
interim update time for every subscriber for accounting.

- most of time is working fine, but some times it's gives below errors and
hangs.. on client sides it's showing *radius time out.*

*Thu Sep 29 07:40:54 2022 : Error: Received conflicting packet from client
MARUTI-OFFICE port 41243 - ID: 74 due to unfinished request in module .
Giving up on old request.*

*Thu Sep 29 07:40:54 2022 : Error: Received conflicting packet from client
Sargasan port 43843 - ID: 39 due to unfinished request in module .  Giving
up on old request.*

*Thu Sep 29 07:40:54 2022 : Error: Received conflicting packet from client
kathlal port 45688 - ID: 18 due to unfinished request in module <queue>.
Giving up on old request.*

*Thu Sep 29 07:40:54 2022 : WARNING: (4098875) WARNING: Module rlm_sql
became unblocked*

*Thu Sep 29 07:40:54 2022 : Error: Received conflicting packet from client
omnet port 54191 - ID: 82 due to unfinished request in module sql.  Giving
up on old request.*

*Thu Sep 29 07:40:54 2022 : Error: Received conflicting packet from client
Vadhvan-GIDC port 50558 - ID: 247 due to unfinished request in module .
Giving up on old request.*

*Thu Sep 29 07:40:54 2022 : Error: Received conflicting packet from client
GULIA port 60073 - ID: 21 due to unfinished request in module .  Giving up
on old request.*

*Thu Sep 29 07:40:54 2022 : Error: Received conflicting packet from client
G_NET port 58334 - ID: 158 due to unfinished request in module <queue>.
Giving up on old request.*

*Thu Sep 29 07:40:54 2022 : Error: Received conflicting packet from client
omnet port 42216 - ID: 84 due to unfinished request in module <queue>.
Giving up on old request.*

*Thu Sep 29 07:40:54 2022 : Error: Received conflicting packet from client
KUHA_1009 port 39064 - ID: 103 due to unfinished request in module
<queue>.  Giving up on old request.*

*Thu Sep 29 07:40:54 2022 : Error: Received conflicting packet from client
mansa port 35213 - ID: 73 due to unfinished request in module <queue>.
Giving up on old request.*

*Thu Sep 29 07:40:54 2022 : Error: Received conflicting packet from client
omnet port 48780 - ID: 83 due to unfinished request in module sql.  Giving
up on old request.*

*Thu Sep 29 07:40:54 2022 : Error: Received conflicting packet from client
omnet port 60583 - ID: 87 due to unfinished request in module <queue>.
Giving up on old request.*

*Thu Sep 29 07:40:54 2022 : Error: Received conflicting packet from client
omnet port 55875 - ID: 86 due to unfinished request in module <queue>.
Giving up on old request.*

*Thu Sep 29 07:40:54 2022 : Error: Received conflicting packet from client
omnet port 50524 - ID: 85 due to unfinished request in module <queue>.
Giving up on old request.*

*Thu Sep 29 07:40:54 2022 : Error: (4098887) Ignoring duplicate packet from
client Skynet-Agra-BNG port 37257 - ID: 1 due to unfinished request in
component <core> module <queue>*

*Thu Sep 29 07:40:54 2022 : WARNING: (4098878) WARNING: Module rlm_sql
became unblocked*



Thanks
Imdad 😊