[Bug]: New account used about 16GB storage

[DanielZhangQD]

Is there an existing issue for the same bug?

• I have checked the existing issues.

Branch Name

1.2-dev

Commit ID

v1.2.0-18f806e26-2024-05-26

Other Environment Information

- Hardware parameters:
- OS type:
- Others:

Actual Behavior

• Create a new account in cloud qa env
• Check the storage size of this account with show accounts and it shows about 16GB used

Expected Behavior

It shows about 13 KB in previous commits.

Steps to Reproduce

See detail in Actual Behavior

Additional information

https://github.com/matrixorigin/MO-Cloud/issues/3340

[DanielZhangQD]

The behavior is introduced in #16286

[DanielZhangQD]

结论：
普通租户只能看到他自己表的行数和大小，如果很难统计，就显示为 0。

1. 普通租户 show accounts，不考虑 mo_database，mo_columns，mo_tables，和 cluster 表的大小（因为目前无法区分这些表里面的数据）
2. mo_table_size 同理
3. 确认一下 mo_table_rows 是否已经区分不同 account
4. 普通租户不为集群表付费，统计存储的时候不需要考虑，统计表行数的时候，看到自己租户的行数

[gouhongshen]

现在 show accounts, tn 那边无法区分这些特殊表中哪些数据来自哪些account，为了和保持一致，mo_table_size, mo_table_rows, 和 show accounts 对这些特殊 的表都暂不统计，直接返回0，以后有需求在修改。

[heni02]

confirm,closed
main:52b7c7b2a6806b3d24761e03fa23d83753c5f370

1.2-dev main:c031f9191f492a00e587159f5167672cd218c157