Re: limit mysql storage
Simone Mainardi <[email protected]> Mon, 11 Mar 2019 15:35:13 +0100
| Newsgroups | gmane.linux.ntop.general |
|---|---|
| Message-ID | <[email protected]> |
--===============7576357567462617594== Content-Type: multipart/alternative; boundary="Apple-Mail=_5CE50A67-8B5A-4CD9-8BD7-08A29A77A00A" --Apple-Mail=_5CE50A67-8B5A-4CD9-8BD7-08A29A77A00A Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=us-ascii "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: >=20 > Hi, >=20 > 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. >=20 > Furthermore, even if I manually delete the old data, the space = occupied > is not freed. It grows at a rate of 3GB/day. >=20 > What is the correct procedure of reusing free space when using MySQL > storage? >=20 > Best regards, > Dan Craciun > _______________________________________________ > Ntop mailing list > [email protected] > http://listgateway.unipi.it/mailman/listinfo/ntop --Apple-Mail=_5CE50A67-8B5A-4CD9-8BD7-08A29A77A00A Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=us-ascii <html><head><meta http-equiv=3D"Content-Type" content=3D"text/html; = charset=3Dus-ascii"></head><body style=3D"word-wrap: break-word; = -webkit-nbsp-mode: space; line-break: after-white-space;" class=3D"">"You = can use OPTIMIZE TABLE to reclaim the unused space and to = defragment the data file. "<div class=3D""><br class=3D""></div><div = class=3D""><a = href=3D"https://dev.mysql.com/doc/refman/8.0/en/optimize-table.html" = class=3D"">https://dev.mysql.com/doc/refman/8.0/en/optimize-table.html</a>= </div><div class=3D""><br class=3D""></div><div class=3D"">Simone<br = class=3D""><div><br class=3D""><blockquote type=3D"cite" class=3D""><div = class=3D"">On 8 Mar 2019, at 20:50, Dan Craciun <<a = href=3D"mailto:[email protected]" = class=3D"">[email protected]</a>> wrote:</div><br = class=3D"Apple-interchange-newline"><div class=3D""><div class=3D"">Hi,<br= class=3D""><br class=3D"">I've setup ntopng to dump flow data in a = MySQL db, with 30 days retention.<br class=3D"">It's been over 45 days = and the data is still there.<br class=3D""><br class=3D"">Furthermore, = even if I manually delete the old data, the space occupied<br = class=3D"">is not freed. It grows at a rate of 3GB/day.<br class=3D""><br = class=3D"">What is the correct procedure of reusing free space when = using MySQL<br class=3D"">storage?<br class=3D""><br class=3D"">Best = regards,<br class=3D"">Dan Craciun<br = class=3D"">_______________________________________________<br = class=3D"">Ntop mailing list<br class=3D""><a = href=3D"mailto:[email protected]" = class=3D"">[email protected]</a><br = class=3D"">http://listgateway.unipi.it/mailman/listinfo/ntop<br = class=3D""></div></div></blockquote></div><br = class=3D""></div></body></html>= --Apple-Mail=_5CE50A67-8B5A-4CD9-8BD7-08A29A77A00A-- --===============7576357567462617594== 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 --===============7576357567462617594==--