#63 Optimizing radaact table

[Anonymous]

Dear All,

We have been using daloradius in a secondary school on a raspberry pi for two years now. We love it, but radaact table is getting bigger and bigger every day.

• Is it possible to remove deleted users' accounting data with a mysql command?
• When I remove batch users do their accounting data is deleted as well (through 'Delete batch session' page)?

As for maintenance, this is a part of my crontab now:

10 2 * * * mysql -uroot -pXXXX radiusdb --execute="DELETE FROM radpostauth WHERE authdate < CURRENT_DATE() - INTERVAL 2 day"
0 3 * * * mysqlcheck -uroot -pXXXX radiusdb --auto-repair --optimize
45 3 * * * find /var/log/freeradius/radacct/ -mindepth 1 -mtime +31 -delete

Any tips for improvements are greatly appriciated!

(Although, I am getting better at Linux, but I am still a newbie...)

[Bacsó Márton]

It seems that with this command, I can remove accounting data that are older than a year. Now, radacct's size went down to 150Mb from 250.

mysql -uroot -pXXXX radiusdb --execute="DELETE FROM radacct WHERE acctstarttime < CURRENT_DATE() - INTERVAL 365 day"

Is it possible to keep the sum of the usage data and still shrink the size of the database?