Question: Does tidb or tikv support TTL?

[didip]

Please answer these questions before submitting your issue. Thanks!

1. What did you do?
   If possible, provide a recipe for reproducing the error.

I am currently evaluating both to store large volume of data that is time series in nature. Thus, they don't need to live forever.

2. What did you expect to see?

I am aware that MySQL does not have support for row-level TTL, however I am curious if tidb has plan to implement TTL in the future.

3. What did you see instead?

I couldn't find any reference of TTL in the docs, which makes sense because MySQL does not support TTL.

4. What version of TiDB are you using (tidb-server -V or run select tidb_version(); on TiDB)?

I haven't gotten that far yet, I am just reading the docs at the moment.

[coocood]

@didip
We don't have a plan to support TTL.
You can add a createdAt column in the table and delete the old rows periodically.

[zhexuany]

TiDB may not be a good fit since you mentioned that you are evaluating TiDB to store time-series data.

[didip]

OK, thanks for the quick reply guys!

[SunRunAway]

TTL feature is released with TiDB v6.5: https://docs.pingcap.com/tidb/stable/time-to-live#periodically-delete-expired-data-using-ttl-time-to-live

tracking issue: #39262