29 Apr
2015
29 Apr
'15
8:55 a.m.
On Apr 28, 2015, at 5:04 PM, Rygl Aleš <ales@rygl.net> wrote:
We have ~1M of records in radacct table and all of them are on-line sessions. That's the problem. I am cleaning closed sessions every 20s, which removes ~2k records to the "historical" table. Maybe some partitioning or data split could help here.
Ah... 99% of the time people have 1M records, they're historical records. In your situation, you should throw more CPU / disk / memory at the problem. Maybe sharding. With 1M online users, you *don't* want to have a single point of failure. Alan DeKok.