On Mon, 4 Oct 2004, cris boisvert wrote: > My Mysql database is about 50 megs right now.. because of the accounting > table. > How large does most people let it get before rolling it? > > I Guess other people will just roll it on a Time/Date basis in cron.. > > But what if I want to keep it for a year so I can pull stats out of it? > Can it get to a couple of gig without problems? > > What is everyone else doing?
I 've got a 2.4GB innodb file with no problems. Though i would strongly recommend against maintaining full accounting for a year on your main radacct table. You could move old accounting (a few months old) to a different radacct table if you want, or you could just keep aggregated accounting on a different table for statistical purposes. The reason is that the larger your table, the more your indexes wont work correctly (a lot of rows for the same username, sessionid etc). -- Kostas Kalevras Network Operations Center [EMAIL PROTECTED] National Technical University of Athens, Greece Work Phone: +30 210 7721861 'Go back to the shadow' Gandalf - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
