On Qui, 2013-06-27 at 09:23 +0100, Rui Miguel Silva Seabra wrote:
> Hi,
>
> We'd like to keep nagios_servicecheks for 14 months of current time but,
> of course, it can get quite big (37GB just for the table with about 6
> months of data).
>
> So I tried partitioning it:
>
> ALTER TABLE nagio
Hi,
We'd like to keep nagios_servicecheks for 14 months of current time but,
of course, it can get quite big (37GB just for the table with about 6
months of data).
So I tried partitioning it:
ALTER TABLE nagios_servicechecks PARTITION BY RANGE(TO_DAYS(end_time)) (
partition p201301 VAL