Resource Query

Syntax

  1. SHOW SCHEMA RESOURCES [FROM schemaName]

Return Value Description

ColumnDescription
nameData source name
typeData source type
hostData source host
portData source port
dbDatabase name
attributeData source parameter

Example

  1. mysql> show schema resources;
  2. +------+-------+-----------+------+------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
  3. | name | type  | host      | port | db   | attribute                                                                                                                                                                                           |
  4. +------+-------+-----------+------+------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
  5. | ds_0 | MySQL | 127.0.0.1 | 3306 | ds_0 | {"minPoolSize":1,"connectionTimeoutMilliseconds":30000,"maxLifetimeMilliseconds":1800000,"readOnly":false,"idleTimeoutMilliseconds":60000,"maxPoolSize":50} |
  6. | ds_1 | MySQL | 127.0.0.1 | 3306 | ds_1 | {"minPoolSize":1,"connectionTimeoutMilliseconds":30000,"maxLifetimeMilliseconds":1800000,"readOnly":false,"idleTimeoutMilliseconds":60000,"maxPoolSize":50} |
  7. +------+-------+-----------+------+------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
  8. 2 rows in set (0.84 sec)