Re: [Ntop] limit mysql storage

Dan, > On 12 Mar 2019, at 10:08, Dan Craciun wrote: > > 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 s

Re: [Ntop] limit mysql storage

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 deletin

Re: [Ntop] limit mysql storage

Dan, > On 11 Mar 2019, at 19:48, Dan Craciun 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 r

Re: [Ntop] limit mysql storage

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

Re: [Ntop] limit mysql storage

"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 wrote: > > Hi, > > I've setup nt

Re: [Ntop] limit mysql storage

Yes, the row count is dropping. I guess I can make a script that deletes everything older than 30 days and run it daily with cron. But then, what is the purpose of the retention days field in the ntopng interface? It's something that's on the to do list, or simply ornamental? Best regards, Dan

Re: [Ntop] limit mysql storage

That being the case, take a row count before pruning and again after pruning.     select count(*) from The row count SHOULD drop after pruning.  The space used by the deleted rows will be filled by new rows as they are stored... That's what "the book" says anyway. On 3/8/19 8:49 PM, Dan Cr

Re: [Ntop] limit mysql storage

Actually, I haven't configured anything, just started ntopng with the -F option and it created the tables. They are innodb. ls -lh total 117G -rw-r- 1 mysql mysql 2.8G Mar  9 06:30 aggrflowsv4#P#p0.ibd -rw-r- 1 mysql mysql 2.8G Mar  9 06:30 aggrflowsv4#P#p1.ibd -rw-r- 1 mysql mysql 2.8

Re: [Ntop] limit mysql storage

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

[Ntop] limit mysql storage

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 sp