SHOW MIGRATION SOURCE STORAGE UNITS

描述

SHOW MIGRATION SOURCE STORAGE UNITS 语法用于查询已经注册的数据迁移源存储单元。

语法

语法 铁路图

  1. ShowStorageUnit ::=
  2.   'SHOW' 'MIGRATION' 'SOURCE' 'STORAGE' 'UNITS'

返回值说明

列说明
name存储单元名称
type存储单元类型
host存储单元地址
port存储单元端口
db数据库名称
attribute存储单元参数

示例

  • 查询指定逻辑库中未被使用的存储单元
  1. SHOW MIGRATION SOURCE STORAGE UNITS;
  1. mysql> SHOW MIGRATION SOURCE STORAGE UNITS;
  2. +------+-------+-----------+------+----------------+---------------------------------+---------------------------+---------------------------+---------------+---------------+-----------+------------------+
  3. | name | type  | host      | port | db             | connection_timeout_milliseconds | idle_timeout_milliseconds | max_lifetime_milliseconds | max_pool_size | min_pool_size | read_only | other_attributes |
  4. +------+-------+-----------+------+----------------+---------------------------------+---------------------------+---------------------------+---------------+---------------+-----------+------------------+
  5. | ds_1 | MySQL | 127.0.0.1 | 3306 | migration_ds_0 |                                 |                           |                           |               |               |           |                  |
  6. +------+-------+-----------+------+----------------+---------------------------------+---------------------------+---------------------------+---------------+---------------+-----------+------------------+
  7. 1 row in set (0.01 sec)

保留字

SHOW、MIGRATION、SOURCE、STORAGE、UNITS

相关链接