mysql retention for realtime

n9mfk · Post by **n9mfk** » Fri 03 Jul 2015 10:03 pm

Hi All,
is

'interval',1 WEEK

the correct way to set retention for realtime to set it for 1 week?
thanks beau

mcrossley · Post by **mcrossley** » Sat 04 Jul 2015 8:25 am

Beau, I think you need to give us a bit more context.

Post by **steve** » Sat 04 Jul 2015 9:14 am

If you mean the retention setting in MX, then you just specify the interval value. My instructions do give examples, and one of them is 1 WEEK.

The realtime.txt upload has an optional 'retention' setting, which will cause entries older than the value specified to be deleted from the database after each upload. It should be specified as a MySQL 'interval', e.g. 24 HOUR or 1 DAY or 1 WEEK etc.

If you don't mean that setting, then as Mark says, more context required.

n9mfk · Post by **n9mfk** » Sat 04 Jul 2015 12:29 pm

I should have been a bit clearer I was ask about retention setting in MX
I read

The realtime.txt upload has an optional 'retention' setting, which will cause entries older than the value specified to be deleted from the database after each upload. It should be specified as a MySQL 'interval', e.g. 24 HOUR or 1 DAY or 1 WEEK etc.

I wanted to make sure

Code: Select all

'interval',1 WEEK

is cottect

nitrx · Post by **nitrx** » Sat 04 Jul 2015 1:00 pm

Code: Select all

1 WEEK

should work don't use the word 'ínterval'

Cumulus Support

mysql retention for realtime

mysql retention for realtime

Re: mysql retention for realtime

Re: mysql retention for realtime

Re: mysql retention for realtime

Re: mysql retention for realtime