rowsets

Name

SinceVersion 1.2

rowsets

description

rowsets 是doris内置的一张系统表，存放在information_schema数据库下。通过 rowsets 系统表可以查看各个BE 当前rowsets情况。

rowsets表结构为：

1. MySQL [(none)]> desc information_schema.rowsets;
2. +------------------------+------------+------+-------+---------+-------+
3. | Field                  | Type       | Null | Key   | Default | Extra |
4. +------------------------+------------+------+-------+---------+-------+
5. | BACKEND_ID             | BIGINT     | Yes  | false | NULL    |       |
6. | ROWSET_ID              | VARCHAR(*) | Yes  | false | NULL    |       |
7. | TABLET_ID              | BIGINT     | Yes  | false | NULL    |       |
8. | ROWSET_NUM_ROWS        | BIGINT     | Yes  | false | NULL    |       |
9. | TXN_ID                 | BIGINT     | Yes  | false | NULL    |       |
10. | NUM_SEGMENTS           | BIGINT     | Yes  | false | NULL    |       |
11. | START_VERSION          | BIGINT     | Yes  | false | NULL    |       |
12. | END_VERSION            | BIGINT     | Yes  | false | NULL    |       |
13. | INDEX_DISK_SIZE        | BIGINT     | Yes  | false | NULL    |       |
14. | DATA_DISK_SIZE         | BIGINT     | Yes  | false | NULL    |       |
15. | CREATION_TIME          | BIGINT     | Yes  | false | NULL    |       |
16. | NEWEST_WRITE_TIMESTAMP | BIGINT     | Yes  | false | NULL    |       |
17. +------------------------+------------+------+-------+---------+-------+

Example

1. select * from information_schema.rowsets where BACKEND_ID = 10004 limit 10;
2. +------------+--------------------------------------------------+-----------+-----------------+--------+--------------+---------------+-------------+-----------------+----------------+---------------+------------------------+------------------------+
3. | BACKEND_ID | ROWSET_ID                                        | TABLET_ID | ROWSET_NUM_ROWS | TXN_ID | NUM_SEGMENTS | START_VERSION | END_VERSION | INDEX_DISK_SIZE | DATA_DISK_SIZE | CREATION_TIME | OLDEST_WRITE_TIMESTAMP | NEWEST_WRITE_TIMESTAMP |
4. +------------+--------------------------------------------------+-----------+-----------------+--------+--------------+---------------+-------------+-----------------+----------------+---------------+------------------------+------------------------+
5. |      10004 | 02000000000000994847fbd41a42297d7c7a57d3bcb46f8c |     10771 |           66850 |      6 |            1 |             3 |           3 |            2894 |         688855 |    1659964582 |             1659964581 |             1659964581 |
6. |      10004 | 020000000000008d4847fbd41a42297d7c7a57d3bcb46f8c |     10771 |           66850 |      2 |            1 |             2 |           2 |            2894 |         688855 |    1659964575 |             1659964574 |             1659964574 |
7. |      10004 | 02000000000000894847fbd41a42297d7c7a57d3bcb46f8c |     10771 |               0 |      0 |            0 |             0 |           1 |               0 |              0 |    1659964567 |             1659964567 |             1659964567 |
8. |      10004 | 020000000000009a4847fbd41a42297d7c7a57d3bcb46f8c |     10773 |           66639 |      6 |            1 |             3 |           3 |            2897 |         686828 |    1659964582 |             1659964581 |             1659964581 |
9. |      10004 | 020000000000008e4847fbd41a42297d7c7a57d3bcb46f8c |     10773 |           66639 |      2 |            1 |             2 |           2 |            2897 |         686828 |    1659964575 |             1659964574 |             1659964574 |
10. |      10004 | 02000000000000884847fbd41a42297d7c7a57d3bcb46f8c |     10773 |               0 |      0 |            0 |             0 |           1 |               0 |              0 |    1659964567 |             1659964567 |             1659964567 |
11. |      10004 | 02000000000000984847fbd41a42297d7c7a57d3bcb46f8c |     10757 |           66413 |      6 |            1 |             3 |           3 |            2893 |         685381 |    1659964582 |             1659964581 |             1659964581 |
12. |      10004 | 020000000000008c4847fbd41a42297d7c7a57d3bcb46f8c |     10757 |           66413 |      2 |            1 |             2 |           2 |            2893 |         685381 |    1659964575 |             1659964574 |             1659964574 |
13. |      10004 | 02000000000000874847fbd41a42297d7c7a57d3bcb46f8c |     10757 |               0 |      0 |            0 |             0 |           1 |               0 |              0 |    1659964567 |             1659964567 |             1659964567 |
14. |      10004 | 020000000000009c4847fbd41a42297d7c7a57d3bcb46f8c |     10739 |            1698 |      8 |            1 |             3 |           3 |             454 |          86126 |    1659964582 |             1659964582 |             1659964582 |
15. +------------+--------------------------------------------------+-----------+-----------------+--------+--------------+---------------+-------------+-----------------+----------------+---------------+------------------------+------------------------+

KeyWords

1. rowsets, information_schema

Best Practice