[RADIATOR] Query/Sumarise accounting records

[Dave Kitabjian]

I would go back a step and ask: do you really need this data for all
100K users, such as to bill per bandwidth? Or do you just need it to
query individual users on an ad hoc basis? If the latter, then I'd do
the query "on demand" and only for those users for whom it is needed.

Dave

-----Original Message-----
From: radiator-bounces at open.com.au [mailto:radiator-bounces at open.com.au]
On Behalf Of Jim
Sent: Monday, August 10, 2009 10:27 AM
To: radiator at open.com.au
Subject: [RADIATOR] Query/Sumarise accounting records

Hi,

Not really a Radiator specific question but I expect plenty of you have 
done this.

At the moment all our Radius accounting data gets logged to a MySQL 
database with a table per month.  I'd like to be able to easily pull 
data on individual users to see how much they have downloaded on a day 
or month, I would also like to be able to pull Top downloaders per month

etc.  I'm struggling to work out an easy way to do this as adding up 
every accounting Start/Alive/Stop and subtracting traffic counters for 
data done in the previous day/month is going to have a big overhead and 
running this on a per user basis for 100k users will be a huge overhead.

Does anyone have any advice on ways to implement this that are going to 
be slick and scale to many users?  Maybe processing each Radius 
accounting record as they are inserted and updating a seperate table 
contraining usage for that current month/day?

Any pointers appreciated as I have been looking at this a while and 
struggling to come up with a neat way of doing it.

Thanks.

Jim.
_______________________________________________
radiator mailing list
radiator at open.com.au
http://www.open.com.au/mailman/listinfo/radiator