On Thu, Oct 27, 2011 at 12:13 AM, Daniel Menezes <lis...@dmnzs.com.br> wrote: > Yes, there is a large number of rows in the radacct and radposauth tables. > The attribute 'Acct-Interim-Interval' works very well but makes many > records.
Interim update aren't suppose to add records, they simply update existing ones. They DO make the db busier though, since the number of accounting request increased (depending on your environment, the difference can be over a magnitude). > I rotate these tables to archive old records, I think I'll do this every > month. > > Of course, the script wouldn't solve all my problems, but it was very > useful. > Maybe I really need some customization to the backend, I'll think about it. Another thing to consider, IF: - you're pretty sure that your setup is optimized-enough - you already have someone with enough knowledge to look at the system and determine that the bottleneck is in disk I/O (due to frequent random db disk access) - you have limited budget then you might want to try spending your budget to replace the disk with SSD. Get sandforce-based SSD (or any other MLC SSD that have good garbage collection and wear-leveling). Usually they can give you instant performance boost (can be over 10x, depending on your current situation) due to increased available IOPS. -- Fajar - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html