Retro Eye care Haitian Deep Dark Default

SHOW MIGRATION STATUS

Description

The SHOW MIGRATION STATUS syntax is used to query migration job status for specified migration job.

Syntax

ShowMigrationStatus ::=
  'SHOW' 'MIGRATION' 'STATUS' migrationJobId 

migrationJobId ::=
  integer | identifier | string

Supplement

  • migrationJobId needs to be obtained through SHOW MIGRATION LIST syntax query

Return Value Description

column Description
item migration job sharding serial number
data_source migration source
tables migration tables
status migration job status
active whether the migration job is active
processed_records_count number of processed rows
inventory_finished_percentage finished percentage of migration job
incremental_idle_seconds incremental idle time
error_message error message

Example

  • Query migration job status
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)

Reserved word

SHOW, MIGRATION, STATUS