Skip to main content
Skip to main content

SHOW TABLET STORAGE FORMAT

SHOW TABLET STORAGE FORMAT

description

This statement is used to display tablet storage foramt information (for administrators only)
Grammar:
SHOW TABLET STORAGE FORMAT [VERBOSE]

example

```
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)
```

keywords

SHOW, TABLET, STORAGE, FORMAT