19 Jan
2020
19 Jan
'20
8:33 a.m.
On Jan 19, 2020, at 7:47 AM, CESAR MURILO DA SILVA JUNIOR <cesarsj@unipam.edu.br> wrote:
I went to delete the records with more than 30 days (there are 96 million currently) in radacct, and gave a table lock that stopped the wifi in the whole company. The delete was inside a transaction. I believe that if I partition the radacct and radpostauth tables I will be saved from this problem.
That will work. Also, you should be able to use "LIMIT 1234" on queries, so that the entire table isn't locked. Though IIRC MySQL isn't good about that. You should also have cron jobs which regularly delete old data. You can run them daily, if necessary. Alan DeKok.