Question

Solved1.22K views12th July 2023MySQL TTL

1

Jeff Douglass 860 27th October 2022 1 Comment

In DM 10.1 CU16 (MySQL based) the TTL setting for Day records states that the minimum value is 15 days 12 hours and this is also the min value the slider will produce. However, it will allow the user to enter zero or will automatically enter zero if you select the 'X' option.

Question:

What does DM do when it is set to zero?

Thanks

Marieke Goethals [SLC] [DevOps Catalyst] Selected answer as best 12th July 2023

Jeff Douglass commented 27th October 2022

FYI my testing shows that with TTL =0 (for day data) the DM dbase cleaning logic/queries will attempt to delete all day data older than the current datetime which makes sense, but I just want to make sure this is safe to do.
Thanks

1 Answer

FYI my testing shows that with TTL =0 (for day data) the DM dbase cleaning logic/queries will attempt to delete all day data older than the current datetime which makes sense, but I just want to make sure this is safe to do.
Thanks

score 0 · Answer 1 · 2022-10-28T07:48:42+00:00

Jeff,

Indeed, this will turn into a query that will delete all the records that are older than the current datetime. Basically, we add the TTL timespan to the current time when the cleaning thread goes off to create the query and clear everything older than that time for a specific window.

Minimum TTL for Day records

1 Answer