SHOW MIGRATION CHECK STATUS 语法用于查询指定数据迁移作业的数据校验情况。
ShowMigrationCheckStatus ::=
'SHOW' 'MIGRATION' 'CHECK' 'STATUS' migrationJobId
migrationJobId ::=
string
migrationJobId 需要通过 SHOW MIGRATION LIST 语法查询获得| 列 | 说明 |
|---|---|
| tables | 校验表 |
| result | 校验结果 |
| finished_percentage | 校验完成度 |
| remaining_seconds | 剩余时间 |
| check_begin_time | 校验开始时间 |
| check_end_time | 校验结束时间 |
| error_message | 错误信息提示 |
SHOW MIGRATION CHECK STATUS 'j010180026753ef0e25d3932d94d1673ba551';
mysql> SHOW MIGRATION CHECK STATUS 'j010180026753ef0e25d3932d94d1673ba551';
+---------+--------+---------------------+-------------------+-------------------------+-------------------------+------------------+---------------+
| tables | result | finished_percentage | remaining_seconds | check_begin_time | check_end_time | duration_seconds | error_message |
+---------+--------+---------------------+-------------------+-------------------------+-------------------------+------------------+---------------+
| t_order | true | 100 | 0 | 2022-11-01 17:57:39.940 | 2022-11-01 17:57:40.587 | 0 | |
+---------+--------+---------------------+-------------------+-------------------------+-------------------------+------------------+---------------+
1 row in set (0.01 sec)
SHOW、MIGRATION、CHECK、STATUS