Retro Eye care Haitian Deep Dark Default

SHOW MIGRATION CHECK STATUS

Description

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

Syntax

ShowMigrationCheckStatus ::=
  'SHOW' 'MIGRATION' 'CHECK' 'STATUS' migrationJobId 

migrationJobId ::=
  integer | identifier | string

Supplement

Return Value Description

Column Description
tables migration check tables
result check result
check_failed_tables tables that failed the check
ignored_tables ignored tables
active whether the check job is active
inventory_finished_percentage inventory check finished percentage
inventory_remaining_seconds inventory check remaining time
incremental_idle_seconds incremental idle time
check_begin_time check begin time
check_end_time check end time
duration_seconds check duration in seconds
algorithm_type check algorithm type
algorithm_props check algorithm properties
error_message error message

Example

  • Query migration check status
SHOW MIGRATION CHECK STATUS 'j010180026753ef0e25d3932d94d1673ba551';

mysql> SHOW MIGRATION CHECK STATUS 'j010180026753ef0e25d3932d94d1673ba551';
+---------+--------+---------------------+----------------+--------+-------------------------------+-----------------------------+--------------------------+-------------------------+-------------------------+------------------+----------------+-----------------+---------------+
| tables  | result | check_failed_tables | ignored_tables | active | inventory_finished_percentage | inventory_remaining_seconds | incremental_idle_seconds | check_begin_time        | check_end_time          | duration_seconds | algorithm_type | algorithm_props | error_message |
+---------+--------+---------------------+----------------+--------+-------------------------------+-----------------------------+--------------------------+-------------------------+-------------------------+------------------+----------------+-----------------+---------------+
| t_order | true   |                     |                | false  | 100                           | 0                           | 0                        | 2022-11-01 17:57:39.940 | 2022-11-01 17:57:40.587 | 0                | DATA_MATCH     |                 |               |
+---------+--------+---------------------+----------------+--------+-------------------------------+-----------------------------+--------------------------+-------------------------+-------------------------+------------------+----------------+-----------------+---------------+
1 row in set (0.01 sec)

Reserved word

SHOW, MIGRATION, CHECK, STATUS