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? 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 > > Simone > >> On 8 Mar 2019, at 20:50, Dan Craciun <dany.crac...@gmail.com >> <mailto:dany.crac...@gmail.com>> 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 >> Ntop@listgateway.unipi.it <mailto: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
_______________________________________________ Ntop mailing list Ntop@listgateway.unipi.it http://listgateway.unipi.it/mailman/listinfo/ntop
