FR-1.1.2 dies with error

Alexander Serkin als at
Wed Aug 16 16:55:41 CEST 2006

Alan DeKok wrote:
> Alexander Serkin <als at> wrote:
>>>   I know of Oracle installations with 400k users.  And the default
>>> schema works with installations of millions of users.
>> do you mean 400k active simultaneous connections? And do they use 
>> accounting updates (Interim-Update records)?
>   There are no simultaneous connections in RADIUS.

Oh, sorry. I didn't mean simultaneous connections. I meant the amount of 
online users. We have up to ~4500 online connections for ~170k subscribers.

>   I mean 400k users, many of whom are online at the same time, and
> sending accounting updates.
>> The table is about 37 million records since april 2005.
>   Is it indexed?

yes it is indexed by all columns which take part in "where" clauses of 
the select and update queries.

>   And why do you have a years worth of data available to your RADIUS
> server?  It's completely unnecessary.
>   You may need a years worth of data available for your billing
> software, and long-term records, but those things don't need one
> second response time.  Change your tables so that you have "current"
> data (i.e. last month or so) available to FreeRADIUS, and leave the
> year-old data in another table that the server doesn't use.

We will. This is subject to discuss with our DBAs.
Thanks for your comments, Alan.

Sincerely Yours,

More information about the Freeradius-Users mailing list