What is the compaction compression ratio of SST files?

Translated
1

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

Original topic: SST文件的compaction压缩率是多少？

| username: alfred

【TiDB Usage Environment】Production\Testing Environment\POC
【TiDB Version】
【Encountered Issues】
【Reproduction Path】What operations were performed that caused the issue
【Issue Phenomenon and Impact】
【Attachments】

  • Relevant logs, configuration files, Grafana monitoring (https://metricstool.pingcap.com/)
  • TiUP Cluster Display information
  • TiUP Cluster Edit config information
  • TiDB-Overview monitoring
  • Corresponding module’s Grafana monitoring (if any, such as BR, TiDB-binlog, TiCDC, etc.)
  • Corresponding module logs (including logs from 1 hour before and after the issue)

If the question is related to performance optimization or troubleshooting, please download the script and run it. Please select all the terminal output and copy-paste it for upload.

2
| username: CuteRay | Original post link

You can refer to the Grafana monitoring panel
TiKV Monitoring Metrics Detailed Explanation | PingCAP Docs

  • Compression ratio: The compression ratio of each level

You can refer to this monitoring item.

3
| username: alfred | Original post link

Compression ratio: Where can I find the compression ratio and file size for each layer?

4
| username: Meditator | Original post link

It seems that it’s not on Grafana, but there are rocksdb.info and raftdb.info files under the data directory, which contain records like this:

image
image1398×146 7.01 KB

5
| username: alfred | Original post link

Is this displaying real-time statistics?

6
| username: Meditator | Original post link

It can be said to be nearly real-time.

7
| username: alfred | Original post link

Okay, thank you.

8
| username: system | Original post link

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