How to Check the Number of Rows in Historical Data for a Frequently Updated Table

Translated
1

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

Original topic: 如何查看一张DML频繁的表的历史数据有多少行

| username: 近墨者zyl

What SQL can be used on the TiDB server to check how many historical versions of keys or counts exist for a table with frequent DML operations?

2
| username: buddyyuan | Original post link

You can see this from the execution plan. total_process_keys, total_keys.

image
image1332×566 43 KB

3
| username: 近墨者zyl | Original post link

Thank you. Is there a data dictionary that can be checked, or SQL?

4
| username: system | Original post link

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