Understanding the Output Information of region-properties

Translated
1

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

Original topic: region-properties输出信息解惑

| username: TiDB_C罗

[TiDB Usage Environment] Production Environment / Testing / Poc
[TiDB Version]
[Reproduction Path] What operations were performed to encounter the issue
[Encountered Issue: Issue Phenomenon and Impact]
[Resource Configuration] Go to TiDB Dashboard - Cluster Info - Hosts and take a screenshot of this page
[Attachments: Screenshots/Logs/Monitoring]
I used the following command

tiup ctl:v7.2.0 tikv --host xxx.xxx.xxx.xxx:20160 region-properties -r 1557

to output region information. I couldn’t find the meaning of each field in the documentation. Could the experts please clarify?

mvcc.min_ts: 444087832211881987
mvcc.max_ts: 450427537899126791
mvcc.num_rows: 2382649
mvcc.num_puts: 1441352
mvcc.num_deletes: 978112
mvcc.num_versions: 2463880
mvcc.max_row_versions: 462
writecf.num_entries: 2468127
writecf.num_deletes: 4247
writecf.num_files: 4
writecf.sst_files: 422633.sst, 432163.sst, 438491.sst, 438043.sst
defaultcf.num_entries: 273085
defaultcf.num_files: 4
defaultcf.sst_files: 438469.sst, 438502.sst, 438433.sst, 438486.sst
region.start_key: 7480000000000000ff625f7298fe7a7f8affc380000000000000fa
region.end_key: 7480000000000000ff645f698000000000ff0000020142494e44ff4143434fff554e54ff0000000000fa0397ff99ea4aebc3c00000fe
region.middle_key_by_approximate_size: 7480000000000000ff625f7298fe927c8cff8350000000000000faf9bfc4a42847fffd
2
| username: jiayou64 | Original post link

Here we focus on the mvcc-prefixed data related to mvcc:

  • mvcc.min_ts: The smallest (oldest) tso among all versions in this region
  • mvcc.min_ts: The tso of the latest mvcc version in this region
  • mvcc.num_rows: The number of user-visible keys (including deleted ones) = mvcc.num_put + mvcc.num_delete
  • mvcc.num_put: The number of user-visible keys (excluding deleted ones)
  • mvcc.num_delete: The number of user-visible deleted keys
  • mvcc.num_version: The number of user-visible mvcc versions
  • mvcc.max_row_versions: The number of versions owned by the key with the most versions in this region.
    专栏 - TiDB MVCC 版本堆积相关原理及排查手段 | TiDB 社区
    The expert has introduced this in the column, hope it helps you.
3
| username: 这里介绍不了我 | Original post link

The image is not visible. Please provide the text content for translation.