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
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