MySQL Accounting records advice

[Mike Poole]

Using FreeRADIUS 2.1.12 with MySQL 5.5.

Not a freeradius request per se but just wanted to know if others have ideas on accounting records in sql.

We've a mid-size ISP and recently turned on accounting writes to SQL for CALEA.  The table has grown enormously and now dwarfs our other databases (20+ GB in about three months).

Has anyone run into this and did you solve it?  I'm thinking we should be archiving the table and clearing it out on a regular basis either to a file share or mysql  ARCHIVE engine db.

Perhaps even changing the way we do accounting in mysql would be better.  A lot of what we do is constrained by mgmt so not always the most efficient.

Thanks for your help.  Freeradius has worked great for us!

Mike