Re: Mysql radius.radacct trying to clean up

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