Mysql radius.radacct trying to clean up

Alan Buxey A.L.M.Buxey at
Wed Nov 18 18:12:29 CET 2015


  Yes I tried deleting a months worth of data earlier, locked the table,
and had to kill the query!

dont use MyISAM - use InnoDB as a minimum.

>Maybe easier to truncate during planned downtime, and then run sql from
>cron keeping enough days of data.

yes, out of hours/quiet time crontab entry to do the required housekeeping...deleting
a days worth not too bad.... eg anything older than, say 90 days...big hit the first time its run,
not so the next day

....then plan migration to postgresql  ;-)


More information about the Freeradius-Users mailing list