Re: limit mysql storage
Dan Craciun <[email protected]> Mon, 11 Mar 2019 20:48:34 +0200
| Newsgroups | gmane.linux.ntop.general |
|---|---|
| Message-ID | <[email protected]> |
This is a multi-part message in MIME format. --===============5919405143148517270== Content-Type: multipart/alternative; boundary="------------45FBF6B2A609B7257739E97A" Content-Language: en-US This is a multi-part message in MIME format. --------------45FBF6B2A609B7257739E97A Content-Type: text/plain; charset=windows-1252 Content-Transfer-Encoding: 8bit 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 <[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 > > > _______________________________________________ > Ntop mailing list > [email protected] > http://listgateway.unipi.it/mailman/listinfo/ntop --------------45FBF6B2A609B7257739E97A Content-Type: text/html; charset=windows-1252 Content-Transfer-Encoding: 8bit <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=windows-1252"> </head> <body text="#000000" bgcolor="#FFFFFF"> <div class="moz-cite-prefix">Thank you Simone.<br> <br> I figured out how to get the space back. <br> <br> The question is why doesn't ntopng delete the old data? <br> The "Duration in days of data retention" doesn't do anything?<br> <br> Best regards,<br> Dan<br> <br> On 11-Mar-19 16:35, Simone Mainardi wrote:<br> </div> <blockquote type="cite" cite="mid:[email protected]">"You can use OPTIMIZE TABLE to reclaim the unused space and to defragment the data file. " <div class=""><br class=""> </div> <div class=""><a href="https://dev.mysql.com/doc/refman/8.0/en/optimize-table.html" class="" moz-do-not-send="true">https://dev.mysql.com/doc/refman/8.0/en/optimize-table.html</a></div> <div class=""><br class=""> </div> <div class="">Simone<br class=""> <div><br class=""> <blockquote type="cite" class=""> <div class="">On 8 Mar 2019, at 20:50, Dan Craciun <<a href="mailto:[email protected]" class="" moz-do-not-send="true">[email protected]</a>> wrote:</div> <br class="Apple-interchange-newline"> <div class=""> <div class="">Hi,<br class=""> <br class=""> I've setup ntopng to dump flow data in a MySQL db, with 30 days retention.<br class=""> It's been over 45 days and the data is still there.<br class=""> <br class=""> Furthermore, even if I manually delete the old data, the space occupied<br class=""> is not freed. It grows at a rate of 3GB/day.<br class=""> <br class=""> What is the correct procedure of reusing free space when using MySQL<br class=""> storage?<br class=""> <br class=""> Best regards,<br class=""> Dan Craciun<br class=""> _______________________________________________<br class=""> Ntop mailing list<br class=""> <a href="mailto:[email protected]" class="" moz-do-not-send="true">[email protected]</a><br class=""> <a class="moz-txt-link-freetext" href="http://listgateway.unipi.it/mailman/listinfo/ntop">http://listgateway.unipi.it/mailman/listinfo/ntop</a><br class=""> </div> </div> </blockquote> </div> <br class=""> </div> <br> <fieldset class="mimeAttachmentHeader"></fieldset> <pre class="moz-quote-pre" wrap="">_______________________________________________ Ntop mailing list <a class="moz-txt-link-abbreviated" href="mailto:[email protected]">[email protected]</a> <a class="moz-txt-link-freetext" href="http://listgateway.unipi.it/mailman/listinfo/ntop">http://listgateway.unipi.it/mailman/listinfo/ntop</a></pre> </blockquote> <br> </body> </html> --------------45FBF6B2A609B7257739E97A-- --===============5919405143148517270== Content-Type: text/plain; charset="us-ascii" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Disposition: inline _______________________________________________ Ntop mailing list [email protected] http://listgateway.unipi.it/mailman/listinfo/ntop --===============5919405143148517270==--