Reading Historical Data Using the System Variable tidb_snapshot

Translated
1

Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.

Original topic: 通过系统变量 tidb_snapshot 读取历史数据

| username: alfred

Reading historical data through the system variable tidb_snapshot is also supported when the query goes through TiFlash, right?

【TiDB Usage Environment】Production Environment / Testing / PoC
【TiDB Version】
【Encountered Problem】
【Reproduction Path】What operations were performed that caused the problem
【Problem Phenomenon and Impact】

【Attachments】

Please provide the version information of each component, such as cdc/tikv, which can be obtained by executing cdc version/tikv-server --version.

2
| username: hey-hoho | Original post link

If you set a snapshot, the query can only go through TiKV. You can test it yourself.

3
| username: xfworld | Original post link

Currently, only TiKV is supported.

4
| username: wisdom | Original post link

Not supported

5
| username: OnTheRoad | Original post link

Setting tidb_snapshot to read historical data can only use the TiKV engine.

6
| username: gary | Original post link

Not supported

7
| username: system | Original post link

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.