How to get table & database size in s3 ?

[wubx]

There is a problem: how to get table & database size in s3?

[Xuanwo]

Maybe we need to calculate them from meta service

[BohuTANG]

There are two ways:

1. show table status from <yourdatabase>

mysql> show table status from dd1;
+------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+-------------------------------+-------------+------------+-----------+----------+---------+
| Name | Engine | Version | Row_format | Rows | Avg_row_length | Data_length | Max_data_length | Index_length | Data_free | Auto_increment | Create_time                   | Update_time | Check_time | Collation | Checksum | Comment |
+------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+-------------------------------+-------------+------------+-----------+----------+---------+
| t2   | FUSE   |       0 |       NULL |    2 |           NULL |           8 |            NULL |         NULL |      NULL |           NULL | 2022-04-20 04:20:20.934 +0000 |        NULL |       NULL |      NULL |     NULL |         |
+------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+-------------------------------+-------------+------------+-----------+----------+---------+

2. call system$fuse_hisotry

mysql> call system$fuse_history('dd1', 't2');
+----------------------------------+---------------------------------------------------+----------------+----------------------------------+---------------+-------------+-----------+--------------------+------------------+
| snapshot_id                      | snapshot_location                                 | format_version | previous_snapshot_id             | segment_count | block_count | row_count | bytes_uncompressed | bytes_compressed |
+----------------------------------+---------------------------------------------------+----------------+----------------------------------+---------------+-------------+-----------+--------------------+------------------+
| d6d4f3907a3841e286ed77059816f36f | 9/13/_ss/d6d4f3907a3841e286ed77059816f36f_v1.json |              1 | dc784422a3144ba192284adba07b6ee3 |             2 |           2 |         2 |                  8 |              340 |
+----------------------------------+---------------------------------------------------+----------------+----------------------------------+---------------+-------------+-----------+--------------------+------------------+

Recommand the call system$fuse_history

[wubx]

MySQL [wubx]> select * from system.tables where database='wubx';
+----------+---------+--------+-------------------------------+-----------+-------------+----------------------+------------+
| database | name    | engine | created_on                    | num_rows  | data_size   | data_compressed_size | index_size |
+----------+---------+--------+-------------------------------+-----------+-------------+----------------------+------------+
| wubx     | sbtest1 | FUSE   | 2022-04-20 08:31:24.457 +0000 | 100000000 | 20200001600 |                 NULL |       NULL |
+----------+---------+--------+-------------------------------+-----------+-------------+----------------------+------------+
1 row in set (0.007 sec)

system.tables data_compress_size has data, everything is easy to resolve.

#4964