跳到主要内容

SHOW TABLET STORAGE FORMAT

描述

该语句用于显示 Backend 上的存储格式信息(仅管理员使用)

语法

SHOW TABLET STORAGE FORMAT [VERBOSE]

示例

```sql
MySQL [(none)]> show tablet storage format;
+-----------+---------+---------+
| BackendId | V1Count | V2Count |
+-----------+---------+---------+
| 10002 | 0 | 2867 |
+-----------+---------+---------+
1 row in set (0.003 sec)

MySQL [test_query_qa]> show tablet storage format verbose;
+-----------+----------+---------------+
| BackendId | TabletId | StorageFormat |
+-----------+----------+---------------+
| 10002 | 39227 | V2 |
| 10002 | 39221 | V2 |
| 10002 | 39215 | V2 |
| 10002 | 39199 | V2 |
+-----------+----------+---------------+
4 rows in set (0.034 sec)
```

关键字

SHOW, TABLET, STORAGE, FORMAT