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? Best regards, Dan Craciun _______________________________________________ Ntop mailing list [email protected] http://listgateway.unipi.it/mailman/listinfo/ntop
