Mysql radius.radacct trying to clean up

Sophie Loewenthal sophie.loewenthal at
Thu Nov 19 10:06:11 CET 2015

We use Percona with INNODB with one file per table.

Still locked!

On 18-Nov-15 6:12 PM, Alan Buxey wrote:
> hi,
>    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  ;-)
> alan
> -
> List info/subscribe/unsubscribe? See

More information about the Freeradius-Users mailing list