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 
  4. migrationJobId ::=
  5.   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