On 3/8/19 11:50 AM, Dan Craciun 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
What you're describing suggests the mysql DB was configured with myisam tables
spaces for the storage. It's a pretty common default.
Have a look at the optimize command and perhaps look at converting the table space to innodb with file-per-table. To reconfigure for innodb-file-per-table, the db has to be
restarted and this should be done before converting the tables to innodb. Once to make this change, the myisam to innodb conversion can be done live.
You might also want to look up mysqltuner. It's a perl script that can do some
crude analysis of your mysql instances performance. It's actually fairly
useful.
_______________________________________________
Ntop mailing list
Ntop@listgateway.unipi.it
http://listgateway.unipi.it/mailman/listinfo/ntop
