尧图网站建设 尧图网络
  • 首页
  • 关于我们
  • 服务项目
  • 案例展示
  • 建站流程
  • 资讯中心
  • 联系我们
首页/资讯中心/详情

StarRocks如何查看一张表是否是单副本?

StarRocks如何查看一张表是否是单副本?
📅 发布时间:2026/7/11 7:16:58

多副本:

MySQL [twdata]> show tablet 90695659; +--------+----------------------------+---------------+----------------------------+---------+----------+-------------+----------+--------+--------------------------------------------------------------------------+ | DbName | TableName | PartitionName | IndexName | DbId | TableId | PartitionId | IndexId | IsSync | DetailCmd | +--------+----------------------------+---------------+----------------------------+---------+----------+-------------+----------+--------+--------------------------------------------------------------------------+ | data | sr_event | p20260710 | sr_event | 3169361 | 27379459 | 90695658 | 27379460 | true | SHOW PROC '/dbs/3169361/27379459/partitions/90695658/27379460/90695659'; | +--------+----------------------------+---------------+----------------------------+---------+----------+-------------+----------+--------+--------------------------------------------------------------------------+ 1 row in set (0.00 sec) MySQL [twdata]> SHOW PROC '/dbs/3169361/27379459/partitions/90695658/27379460/90695659'; +-----------+-----------+---------+-------------+-------------------+-----------------------+------------------+----------------------+---------------+------------+----------+----------+--------+-------+---------------+--------------+----------------------+---------------------------------------------------+----------------------------------------------------------------------------------------+--------------+ | ReplicaId | BackendId | Version | VersionHash | LstSuccessVersion | LstSuccessVersionHash | LstFailedVersion | LstFailedVersionHash | LstFailedTime | SchemaHash | DataSize | RowCount | State | IsBad | IsSetBadForce | VersionCount | PathHash | MetaUrl | CompactionStatus | IsErrorState | +-----------+-----------+---------+-------------+-------------------+-----------------------+------------------+----------------------+---------------+------------+----------+----------+--------+-------+---------------+--------------+----------------------+---------------------------------------------------+----------------------------------------------------------------------------------------+--------------+ | 90695660 | 35468871 | 7 | 0 | 7 | 0 | -1 | 0 | NULL | 1696049109 | 75420319 | 7093908 | NORMAL | false | false | 1 | -6043518985966267869 | http://127.0.0.131:8040/api/meta/header/90695659 | http://127.0.0.131:8040/api/compaction/show?tablet_id=90695659&schema_hash=1696049109 | false | | 90695661 | 41350191 | 7 | 0 | 7 | 0 | -1 | 0 | NULL | 1696049109 | 75420319 | 7093908 | NORMAL | false | false | 1 | 5916097581675239323 | http://127.0.0.154:8040/api/meta/header/90695659 | http://127.0.0.154:8040/api/compaction/show?tablet_id=90695659&schema_hash=1696049109 | false | | 90695662 | 39894719 | 7 | 0 | 7 | 0 | -1 | 0 | NULL | 1696049109 | 75420319 | 7093908 | NORMAL | false | false | 1 | -5318340163987254342 | http://127.0.0.44:8040/api/meta/header/90695659 | http://127.0.0.44:8040/api/compaction/show?tablet_id=90695659&schema_hash=1696049109 | false | +-----------+-----------+---------+-------------+-------------------+-----------------------+------------------+----------------------+---------------+------------+----------+----------+--------+-------+---------------+--------------+----------------------+---------------------------------------------------+----------------------------------------------------------------------------------------+--------------+ 3 rows in set (0.00 sec)

单副本:

MySQL [twdata]> show tablet 85091038; +--------+----------------------+-----------------------------+----------------------+---------+----------+-------------+----------+--------+--------------------------------------------------------------------------+ | DbName | TableName | PartitionName | IndexName | DbId | TableId | PartitionId | IndexId | IsSync | DetailCmd | +--------+----------------------+-----------------------------+----------------------+---------+----------+-------------+----------+--------+--------------------------------------------------------------------------+ | twdata | test | $shadow_automatic_partition | test | 3169361 | 52051104 | 52051103 | 85091037 | true | SHOW PROC '/dbs/3169361/52051104/partitions/52051103/85091037/85091038'; | +--------+----------------------+-----------------------------+----------------------+---------+----------+-------------+----------+--------+--------------------------------------------------------------------------+ 1 row in set (0.00 sec) MySQL [twdata]> SHOW PROC '/dbs/3169361/52051104/partitions/52051103/85091037/85091038'; +-----------+-----------+---------+-------------+-------------------+-----------------------+------------------+----------------------+---------------+------------+----------+----------+--------+-------+---------------+--------------+----------------------+--------------------------------------------------+--------------------------------------------------------------------------------------+--------------+ | ReplicaId | BackendId | Version | VersionHash | LstSuccessVersion | LstSuccessVersionHash | LstFailedVersion | LstFailedVersionHash | LstFailedTime | SchemaHash | DataSize | RowCount | State | IsBad | IsSetBadForce | VersionCount | PathHash | MetaUrl | CompactionStatus | IsErrorState | +-----------+-----------+---------+-------------+-------------------+-----------------------+------------------+----------------------+---------------+------------+----------+----------+--------+-------+---------------+--------------+----------------------+--------------------------------------------------+--------------------------------------------------------------------------------------+--------------+ | 85091039 | 35468872 | 1 | 0 | 1 | 0 | -1 | 0 | NULL | 459811504 | 0 | 0 | NORMAL | false | false | 1 | -6897070086613041248 | http://127.0.0.81:8040/api/meta/header/85091038 | http://127.0.0.81:8040/api/compaction/show?tablet_id=85091038&schema_hash=459811504 | false | +-----------+-----------+---------+-------------+-------------------+-----------------------+------------------+----------------------+---------------+------------+----------+----------+--------+-------+---------------+--------------+----------------------+--------------------------------------------------+--------------------------------------------------------------------------------------+--------------+ 1 row in set (0.00 sec)

相关新闻

  • 豆包社交第一步,为何先找飞书?拆解AI时代最贵的一张聊天网
  • 2026年7月最新合肥宇舶官方售后客户服务电话及线下网点地址 - 亨得利官方服务中心
  • n8n定时采集公众号RSS:零代码自动化信息归档方案

最新新闻

  • C# WinForm CAN 上位机开发:3步连接Kvaser卡与电机握手通信
  • GitHub Copilot 新版计费翻车:2天消耗49美元,天价引爆开发者吐槽,国产开源 AI 迎来替代窗口期
  • ARM64 平台内核 Crash 分析:对比 3 种工具(crash vs T32 vs QCAP)的定位效率与适用场景
  • MaxText弹性训练:TPU多切片秒级恢复与Ray Train实战指南
  • LTC1864与PIC18F87J50构建高精度ADC信号采集系统
  • 企业智能体平台的典型应用场景

日新闻

  • OpenClaw本地部署:一键直连微信的私有化AI Agent实战指南
  • Kubernetes 系列【10】控制器:ReplicaSet(副本集)
  • 怎么寄快递才能便宜呢?2026年7月寄快递省钱攻略 - 生活情报姬

周新闻

  • 基于YOLOv12的番茄成熟度智能检测系统开发
  • 终极RimWorld模组管理指南:用RimSort告别模组冲突烦恼
  • AI Agent框架开发:从理论到实践的完整指南

月新闻

  • 2026年6月公司网站搭建最新热门渠道测评:四大低成本/零代码平台对比+避坑
  • 【Linux】Linux arm 编译QT程序,出现expected “}“报错
  • 【MATLAB例程】四基站二维AOA定位与距离辅助增强对比仿真。基于角度观测和测距修正的固定目标平面定位精度分析

关于尧图

  • 公司简介
  • 团队介绍
  • 企业文化
  • 荣誉资质

服务项目

  • 定制开发
  • 电商建站
  • UI 设计
  • 运维服务

快速链接

  • 案例展示
  • 建站流程
  • 常见问题
  • 资讯中心

联系方式

  • 📍北京市朝阳区互联网产业园 A 座 10 层
  • 📞400-888-8888
  • ✉️contact@rkmt.cn
  • 🕐周一至周日 9:00-21:00

© 2024 北京尧图网络科技有限公司 版权所有 | 京 ICP 备 XXXXXXXX 号