SHOW MIGRATION CHECK STATUS

Description

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

Syntax

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

Supplement

Return Value Description

ColumnsDescription
tablesmigration check table
resultcheck result
finished_percentagecheck finished percentag
remaining_secondscheck remaining time
check_begin_timecheck begin time
check_end_timecheck end time
error_messageerror message

Example

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

Reserved word

SHOW, MIGRATION, CHECK, STATUS