"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]> 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] > http://listgateway.unipi.it/mailman/listinfo/ntop
_______________________________________________ Ntop mailing list [email protected] http://listgateway.unipi.it/mailman/listinfo/ntop
