Reading Historical Data Using the System Variable tidb_snapshot

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】


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

| username: hey-hoho | Original post link

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

| username: xfworld | Original post link

Currently, only TiKV is supported.

| username: wisdom | Original post link

Not supported

| username: OnTheRoad | Original post link

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

| username: gary | Original post link

Not supported

| username: system | Original post link

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