GBase 8a
运维管理
文章

GBase8a mpp如何查看表的tableid_方式三

发表于2025-12-05 14:23:1049次浏览5个评论

通过metadump查看:

元数据合并前版本查看方式metadump table.desc.A/B, 元数据合并后的版本查看方式metadumptable.info.A/B,其中的t_num就是tableid

元数据合并前版本:

[gbase@localhost t1.GED]$ metadump table.des.B

This tool is designed for use at GBase internally,and is unsupported externally.

GBase makes no claims and holds no liability regarding the external use of this tool.

This tool is copyrighted and his redistribution is restricted.

table.des.B

+----------------------+-----------------+

| storage_version      | GEHV6           |

| encrypt              | 0               |

| shrinked_rowid       | 0               |

| no_attr              | 1               |

| attr_nums[0]         | 0               |

| no_attr_cnt          | 1               |

| no_attr[0]           | 1               |

| t_name               | t1              |

| t_desc::false        |                 |

| offset               | 46              |

| length               | 10              |

| block type           | 1               |

| next                 | 0               |

| t_num                | 2053            |

| limit_storage_size   | 0               |

| storage_size         | 0               |

| scn                  | 131083          |

| compress_flag_num    | 4294967295      |

| compress_flag_str    | 4294967295      |

| extend_size          | 0               |

| autoextend_flag      | 0               |

| tab_data_size        | 0               |

| durability           | 0               |

+----------------------+-----------------+

元数据合并后版本:

[gbase@node34 t1.GED]$ metadump table.info.B

This tool is designed for use at GBase internally,and is unsupported externally.

GBase makes no claims and holds no liability regarding the external use of this tool.

This tool is copyrighted and his redistribution is restricted.

table.info.B

----------------------------state------------------------

+-------------------------------------+-----------------+

| version                             | 8               |

| checksum                            | 3585941699      |

| table_last_operation                | DDL             |

| ctl_version                         | B               |

| map_version                         | A               |

| delete_version                      | B               |

+-------------------------------------+-----------------+

----------------------------des--------------------------

+----------------------+-----------------+

| storage_version      | GEHV8           |

| checksum             | 2647270172      |

| t_num                | 5               |

| tablespace_id        | 0               |

| no_attr              | 3               |

| no_attr_cnt          | 3               |

| encrypt              | 0               |

| compress_flag_num    | 4294967295      |

| compress_flag_str    | 4294967295      |

| limit_storage_size   | 0               |

| autoextend_flag      | 0               |

| extend_size          | 0               |

| shrinked_rowid       | 0               |

| tab_data_size        | 0               |

| storage_size         | 0               |

| scn                  | 9               |

 

+----------------------+-----------------+

评论

登录后才可以发表评论
枫溪发表于 7个月前
123
枫溪发表于 7个月前
666
枫溪发表于 7个月前
路过
GBase用户51848发表于 2个月前
学习了
xiaowuyun发表于 2个月前
厉害了