2013-05-31 - Re: [GRASE-Hotspot] Database improvements for large databases

Header Data

From: Tim White <ti***8@gmail.com>
Message Hash: 1cf949fcef9dadc91cac41e96c6233c5be621133933221041b513ecda01c2a69
Message ID: <51A9338A.3060904@gmail.com>
Reply To: <5195B332.2040900@gmail.com>
UTC Datetime: 2013-05-31 16:34:34 UTC
Raw Date: Sat, 01 Jun 2013 09:34:34 +1000

Raw message 

On 17/05/13 14:33, Tim White wrote:
>
>
> It took a radius database dump from >400Mb down to around 2Mb, so it 
> should help you if you have a very busy network.

And by the looks of things, even this query is way too slow if your 
database is say a year old. I'm going to put an upgrade script in the 
next release that will probably just truncate the radpostauth table, or 
at least remove all but 1000 rows or something (most likely a truncate).
In a database backup (compressed) it went from 2Mb to 150K for a system 
that's been running for over a year. That's a lot of extra crud sitting 
in the database slowing things down and consuming disk space.

Tim

Thread