Dan, > On 12 Mar 2019, at 10:08, Dan Craciun <dany.crac...@gmail.com> wrote: > > On 12-Mar-19 10:47, Simone Mainardi wrote: >> It does the delete - you won't be able to find records older than the >> retention if you query the db - but deleting old records doesn't >> automatically translate into mysql recycling unused space. > I'm sorry, but that's not true. > Before I started deleting manually, on March 9, I had data from January > 15th. That's the day I started using MySQl for storing flows. I don't > think any record was actually deleted. > > I manually deleted data older than February 1st. Today is March 12: > > select count(*) from flowsv4 where FIRST_SWITCHED < 1548979200 (Feb 1st) > Result: 0 > > select count(*) from flowsv4 where FIRST_SWITCHED < 1549324800 (Feb 5th) > Result: 17161146 > > I have 1.7M flows between Feb 1st and Feb 4th. I wasnt't supposed to > have anything older than Feb 10, right?
ntopng is supposed to delete old data every day ad midnight local time. If you think it's a bug feel free to file an issue on GitHub. > > Best regards, > Dan Craciun > _______________________________________________ > Ntop mailing list > Ntop@listgateway.unipi.it > http://listgateway.unipi.it/mailman/listinfo/ntop _______________________________________________ Ntop mailing list Ntop@listgateway.unipi.it http://listgateway.unipi.it/mailman/listinfo/ntop
