Dan, > On 11 Mar 2019, at 19:48, Dan Craciun <[email protected]> wrote: > > Thank you Simone. > > I figured out how to get the space back. > > The question is why doesn't ntopng delete the old data? > The "Duration in days of data retention" doesn't do anything?
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. Anyway, we have seen several shortcomings of MySQL when it comes to store flows and decided to build a special-purpose database nIndex. I would encourage you to try it out: https://www.ntop.org/ntopng/say-hello-to-nindex-personal-big-data-system-for-network-flows/ Simone > > Best regards, > Dan > > On 11-Mar-19 16:35, Simone Mainardi wrote: >> "You can use OPTIMIZE TABLE to reclaim the unused space and to defragment >> the data file. " >> >> https://dev.mysql.com/doc/refman/8.0/en/optimize-table.html >> <https://dev.mysql.com/doc/refman/8.0/en/optimize-table.html> >> >> Simone >> >>> On 8 Mar 2019, at 20:50, Dan Craciun <[email protected] >>> <mailto:[email protected]>> wrote: >>> >>> Hi, >>> >>> I've setup ntopng to dump flow data in a MySQL db, with 30 days retention. >>> It's been over 45 days and the data is still there. >>> >>> Furthermore, even if I manually delete the old data, the space occupied >>> is not freed. It grows at a rate of 3GB/day. >>> >>> What is the correct procedure of reusing free space when using MySQL >>> storage? >>> >>> Best regards, >>> Dan Craciun >>> _______________________________________________ >>> Ntop mailing list >>> [email protected] <mailto:[email protected]> >>> http://listgateway.unipi.it/mailman/listinfo/ntop >>> <http://listgateway.unipi.it/mailman/listinfo/ntop> >> >> >> >> _______________________________________________ >> Ntop mailing list >> [email protected] <mailto:[email protected]> >> http://listgateway.unipi.it/mailman/listinfo/ntop >> <http://listgateway.unipi.it/mailman/listinfo/ntop> > _______________________________________________ > Ntop mailing list > [email protected] > http://listgateway.unipi.it/mailman/listinfo/ntop
_______________________________________________ Ntop mailing list [email protected] http://listgateway.unipi.it/mailman/listinfo/ntop
