SHOW MIGRATION STATUS

Description

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

Syntax

Grammar Railroad diagram

  1. ShowMigrationStatus ::=
  2.   'SHOW' 'MIGRATION' 'STATUS' migrationJobId 
  4. migrationJobId ::=
  5.   string

Supplement

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

Return Value Description

columnDescription
itemmigration job sharding serial number
data sourcemigration source
statusmigration job status
processed_records_countnumber of processed rows
inventory_finished_percentagefinished percentage of migration job
incremental_idle_secondsincremental idle time
error_messageerror message

Example

  • Query migration job status
  1. SHOW MIGRATION STATUS 'j010180026753ef0e25d3932d94d1673ba551';
  1. mysql> SHOW MIGRATION STATUS 'j010180026753ef0e25d3932d94d1673ba551';
  2. +------+-------------+--------------------------+--------+-------------------------+-------------------------------+--------------------------+---------------+
  3. | item | data_source | status                   | active | processed_records_count | inventory_finished_percentage | incremental_idle_seconds | error_message |
  4. +------+-------------+--------------------------+--------+-------------------------+-------------------------------+--------------------------+---------------+
  5. | 0    | ds_1        | EXECUTE_INCREMENTAL_TASK | true   | 6                       | 100                           | 25                       |               |
  6. +------+-------------+--------------------------+--------+-------------------------+-------------------------------+--------------------------+---------------+
  7. 1 row in set (0.01 sec)

Reserved word

SHOW, MIGRATION, STATUS