19 Nov
2015
19 Nov
'15
4:06 a.m.
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 http://www.freeradius.org/list/users.html