Re: [Netdisco] Expiry for logged IP retention ?

[Oliver G. <ol...@cp...>]

Hi Peter

After discussion with another user of Netdisco I recently discovered 
that we do have a longstanding issue relating to exactly this (probably 
the behaviour has been there since Netdisco 2.0 was first created).

Briefly, my understanding is that Netdisco is keeping the IPs where the 
MAC address is still also present. For situations where a MAC is roaming 
and getting different IPs all the time, this can certainly balloon the 
archive (I'm sure there are other scenarios too). For the curious, the 
code is here:

https://github.com/netdisco/netdisco/blob/master/lib/App/Netdisco/DB/ResultSet/Node.pm#L122

If you are really pressed for space you can delete entries from the 
node_ip table where time_last is greater than a given value. There will 
not be any side effect if you just go ahead and do this manually.

I'm not sure when we'll get a fix in, but you are not the only site with 
the issue!

regards,
oliver.

On 2018-01-17 20:13, Peter Grasso wrote:
> Hi guys,
> 
> We have a reasonably large site, and my Netdisco 2 install was getting
> a little sluggish, so I have adjusted the retention levels with:
> 
> #Modified Expiry:
> 
> expire_devices: 14
> 
> expire_nodes: 30
> 
> expire_nodes_archive: 30
> 
> expire_jobs: 14
> 
> This has worked quite nicely, but I cannot find a way to change the
> retention for the logged IP addresses:
> 
> STATISTICS FOR THIS INSTALLATION
> 
> 242 DEVICES WITH 895 IPS
> 
> 8,520 INTERFACES OF WHICH 4,628 ARE UP
> 
> 213 LAYER 2 LINKS BETWEEN DEVICES
> 
> 3,169 NODES LOGGED, OF WHICH 1,400 ARE ACTIVE
> 
> 4,052,047 IPS LOGGED, OF WHICH 66,615 ARE ACTIVE
> 
> STATISTICS LAST GENERATED ON 2018-01-17
> 
> We have 4 million IP addresses logged, and this is the only statistic
> that does not seem to have reduced after I changed the expiry times
> down.
> 
> In real terms we only need to retain about one month's data for IP
> addresses, is there any way to tune this parameter ?
> 
> Regards,
> 
> Peter Grasso
> 
> Network Project Administrator
> ------------------------------------------------------------------------------
> Check out the vibrant tech community on one of the world's most
> engaging tech sites, Slashdot.org! http://sdm.link/slashdot
> 
> _______________________________________________
> Netdisco mailing list
> net...@li...
> https://lists.sourceforge.net/lists/listinfo/netdisco-users