SHOW MIGRATION CHECK STATUS

描述

SHOW MIGRATION CHECK STATUS 语法用于查询指定数据迁移作业的数据校验情况。

语法

语法 铁路图

  1. ShowMigrationCheckStatus ::=
  2. 'SHOW' 'MIGRATION' 'CHECK' 'STATUS' migrationJobId
  3. migrationJobId ::=
  4. string

补充说明

返回值说明

说明
tables校验表
result校验结果
finished_percentage校验完成度
remaining_seconds剩余时间
check_begin_time校验开始时间
check_end_time校验结束时间
error_message错误信息提示

示例

  • 查询指定数据迁移作业的数据校验情况
  1. SHOW MIGRATION CHECK STATUS 'j010180026753ef0e25d3932d94d1673ba551';
  1. mysql> SHOW MIGRATION CHECK STATUS 'j010180026753ef0e25d3932d94d1673ba551';
  2. +---------+--------+---------------------+-------------------+-------------------------+-------------------------+------------------+---------------+
  3. | tables | result | finished_percentage | remaining_seconds | check_begin_time | check_end_time | duration_seconds | error_message |
  4. +---------+--------+---------------------+-------------------+-------------------------+-------------------------+------------------+---------------+
  5. | t_order | true | 100 | 0 | 2022-11-01 17:57:39.940 | 2022-11-01 17:57:40.587 | 0 | |
  6. +---------+--------+---------------------+-------------------+-------------------------+-------------------------+------------------+---------------+
  7. 1 row in set (0.01 sec)

保留字

SHOWMIGRATIONCHECKSTATUS

相关链接