How to obtain the MVCC version and write time of a specific row record?

Translated
1

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

Original topic: 如何获取某个行记录的 mvcc 版本和写入时间？

| username: 大飞哥online

I would like to ask if there is any way to see the MVCC historical versions and start_ts time?

Using set @@tidb_snapshot='2023-10-10 14:30:00' can specify the data at a certain point in time.

For example, at 1 minute it is data A, at 2 minutes it is data B, and at 3 minutes it is data C.

Data A - Write time - MVCC version
Data B - Write time - MVCC version
Data C - Write time - MVCC version

In a list format.

2
| username: WalterWj | Original post link

Use this: curl http://{TiDBIP}:10080/mvcc/key/{db}/{table}/{handle}

3
| username: 大飞哥online | Original post link

Can only use API interface methods, are there any others, such as show or built-in functions, built-in tables, etc.?

4
| username: WalterWj | Original post link

Not sure.

5
| username: Fly-bird | Original post link

I don’t know the built-in functions.

6
| username: zhanggame1 | Original post link

SQL doesn’t work, let’s see if other experts have a solution.