SHOW MIGRATION STATUS 语法用于查询指定数据迁移作业的详细情况。
ShowMigrationStatus ::=
'SHOW' 'MIGRATION' 'STATUS' migrationJobId
migrationJobId ::=
integer | identifier | string
migrationJobId 需要通过 SHOW MIGRATION LIST 语法查询获得| 列 | 说明 |
|---|---|
| item | 数据迁移作业分片编号 |
| data_source | 数据迁移源 |
| tables | 数据迁移表 |
| status | 数据迁移作业状态 |
| active | 数据迁移作业是否活跃 |
| processed_records_count | 处理数据行数 |
| inventory_finished_percentage | 数据迁移作业完成度 |
| incremental_idle_seconds | 增量闲置时间 |
| error_message | 错误信息提示 |
SHOW MIGRATION STATUS 'j010180026753ef0e25d3932d94d1673ba551';
mysql> SHOW MIGRATION STATUS 'j010180026753ef0e25d3932d94d1673ba551';
+------+-------------+---------+--------------------------+--------+-------------------------+-------------------------------+--------------------------+---------------+
| item | data_source | tables | status | active | processed_records_count | inventory_finished_percentage | incremental_idle_seconds | error_message |
+------+-------------+---------+--------------------------+--------+-------------------------+-------------------------------+--------------------------+---------------+
| 0 | ds_1 | t_order | EXECUTE_INCREMENTAL_TASK | true | 6 | 100 | 25 | |
+------+-------------+---------+--------------------------+--------+-------------------------+-------------------------------+--------------------------+---------------+
1 row in set (0.01 sec)
SHOW、MIGRATION、STATUS