How to Calculate TiDB Data Compression Ratio

Translated
1

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

Original topic: tidb 数据压缩比怎么求出来

| username: Raymond

Excuse me, teachers, how can I check the compression ratio of TiDB data? For example, if there was originally 100G of data, and after compression with RocksDB, it becomes 50G. How can I check the compression ratio?
The size of a certain database queried through SQL statements in information_schema.table, is it the size of a single TiKV replica or the sum of the sizes of all TiKV replicas?

2
| username: 啦啦啦啦啦 | Original post link

You can refer to these two posts:

3
| username: Raymond | Original post link

Hello, teacher. Is the “current storage size” on the PD monitoring panel the sum of the data directories (/tidb-data/tikv-20160/db/) of all TiKV nodes?

4
| username: 啦啦啦啦啦 | Original post link

Yes, this is the size of all the used database space.

5
| username: Raymond | Original post link

Thank you for your reply, teacher.

6
| username: system | Original post link

This topic was automatically closed 60 days after the last reply. No new replies are allowed.