Michal Taborsky | 27 Oct 2011 18:06
Picon
Favicon
Gravatar

Drop old raw metric data

Hi,


our database is getting quite big and a little difficult to manage. I'd like to archive the old metric data. I am pretty sure the metric_numeric_archive_* and metric_text_archive_* tables are not used anywhere after the metrics are rolled-up, but I want to be sure.

What I want to do is dump the data out of the database for the tables metric archive tables, say a year back, and then drop these tables. Anyone has any good reasons why I shouldn't do that?

--
Michal Taborsky
_______________________________________________
Reconnoiter-users mailing list
Reconnoiter-users <at> lists.omniti.com
http://lists.omniti.com/mailman/listinfo/reconnoiter-users
Theo Schlossnagle | 30 Oct 2011 23:47
Favicon
Gravatar

Re: Drop old raw metric data

nothing uses it, it is safe to delete.

2011/10/27 Michal Taborsky <michal <at> taborsky.cz>:
> Hi,
> our database is getting quite big and a little difficult to manage. I'd like
> to archive the old metric data. I am pretty sure the
> metric_numeric_archive_* and metric_text_archive_* tables are not used
> anywhere after the metrics are rolled-up, but I want to be sure.
> What I want to do is dump the data out of the database for the tables metric
> archive tables, say a year back, and then drop these tables. Anyone has any
> good reasons why I shouldn't do that?
> --
> Michal Taborsky
> http://www.taborsky.cz
>
> _______________________________________________
> Reconnoiter-users mailing list
> Reconnoiter-users <at> lists.omniti.com
> http://lists.omniti.com/mailman/listinfo/reconnoiter-users
>
>

--

-- 
Theo Schlossnagle

http://omniti.com/is/theo-schlossnagle
Michal Taborsky | 31 Oct 2011 12:55
Picon
Favicon
Gravatar

Re: Drop old raw metric data

Thanks, I thought so. I've submitted a pull request with a function to drop the old data, should be safe to use, it will not drop data still required for rollups.



--
Michal Taborsky


2011/10/30 Theo Schlossnagle <jesus <at> omniti.com>
nothing uses it, it is safe to delete.

2011/10/27 Michal Taborsky <michal <at> taborsky.cz>:
> Hi,
> our database is getting quite big and a little difficult to manage. I'd like
> to archive the old metric data. I am pretty sure the
> metric_numeric_archive_* and metric_text_archive_* tables are not used
> anywhere after the metrics are rolled-up, but I want to be sure.
> What I want to do is dump the data out of the database for the tables metric
> archive tables, say a year back, and then drop these tables. Anyone has any
> good reasons why I shouldn't do that?
> --
> Michal Taborsky
> http://www.taborsky.cz
>
> _______________________________________________
> Reconnoiter-users mailing list
> Reconnoiter-users <at> lists.omniti.com
> http://lists.omniti.com/mailman/listinfo/reconnoiter-users
>
>



--
Theo Schlossnagle

http://omniti.com/is/theo-schlossnagle

_______________________________________________
Reconnoiter-users mailing list
Reconnoiter-users <at> lists.omniti.com
http://lists.omniti.com/mailman/listinfo/reconnoiter-users

Gmane