The SHOW MIGRATION LIST syntax is used to query migration job list.
ShowMigrationList ::=
'SHOW' 'MIGRATION' 'LIST'
| Columns | Description |
|---|---|
| id | migration job id |
| tables | migration tables |
| job_item_count | migration job sharding number |
| active | migration job states |
| create_time | migration job create time |
| stop_time | migration job stop time |
| job_sharding_nodes | migration job sharding nodes |
SHOW MIGRATION LIST;
mysql> SHOW MIGRATION LIST;
+--------------------------------------------+---------------------+--------+---------------------+-----------+----------------+--------------------+
| id | tables | active | create_time | stop_time | job_item_count | job_sharding_nodes |
+--------------------------------------------+---------------------+--------+---------------------+-----------+----------------+--------------------+
| j0102p00001d029afca1fd960d567fed6cddc9b4a2 | source_ds.t_order | true | 2022-10-31 18:18:24 | | 1 | 10.7.5.76@-@27808 |
+--------------------------------------------+---------------------+--------+---------------------+-----------+----------------+--------------------+
4 rows in set (0.06 sec)
SHOW, MIGRATION, LIST