This is an automated email from the ASF dual-hosted git repository.
menghaoran pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/shardingsphere.git
The following commit(s) were added to refs/heads/master by this push:
new 9dff3abdb57 Update syntax docs for show storage units (#32708)
9dff3abdb57 is described below
commit 9dff3abdb57199e02ade8eaee9542d3f43e57c60
Author: Raigor <[email protected]>
AuthorDate: Wed Aug 28 14:54:30 2024 +0800
Update syntax docs for show storage units (#32708)
---
.../storage-unit-query/show-storage-units.cn.md | 110 ++++++++-------------
.../storage-unit-query/show-storage-units.en.md | 109 ++++++++------------
2 files changed, 84 insertions(+), 135 deletions(-)
diff --git
a/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rql/storage-unit-query/show-storage-units.cn.md
b/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rql/storage-unit-query/show-storage-units.cn.md
index bc0dc25391d..e297d7fabff 100644
---
a/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rql/storage-unit-query/show-storage-units.cn.md
+++
b/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rql/storage-unit-query/show-storage-units.cn.md
@@ -13,19 +13,16 @@ weight = 1
{{% tab name="语法" %}}
```sql
ShowStorageUnit ::=
- 'SHOW' 'STORAGE' 'UNITS' ('FROM' databaseName)? showLike? ('WHERE'
'USAGE_COUNT' '=' usageCount)?
+ 'SHOW' 'STORAGE' 'UNITS' ('FROM' databaseName)? showLike?
+
+databaseName ::=
+ identifier
showLike ::=
'LIKE' likePattern
likePattern ::=
string
-
-usageCount ::=
- int
-
-databaseName ::=
- identifier
```
{{% /tab %}}
{{% tab name="铁路图" %}}
@@ -39,87 +36,64 @@ databaseName ::=
### 返回值说明
-| 列 | 说明 |
-|-----------|--------|
-| name | 存储单元名称 |
-| type | 存储单元类型 |
-| host | 存储单元地址 |
-| port | 存储单元端口 |
-| db | 数据库名称 |
-| attribute | 存储单元参数 |
+| 列 | 说明 |
+|---------------------------------|---------------------|
+| name | 存储单元名称 |
+| type | 存储单元类型 |
+| host | 存储单元地址 |
+| port | 存储单元端口 |
+| db | 数据库名称 |
+| connection_timeout_milliseconds | 连接超时时间（毫秒） |
+| idle_timeout_milliseconds | 连接最大空闲时间（毫秒）|
+| max_lifetime_milliseconds | 连接最大生命周期（毫秒）|
+| max_pool_size | 连接池最大连接数 |
+| min_pool_size | 连接池最小连接数 |
+| read_only | 只读标识 |
+| other_attributes | 其他连接参数 |
### 示例
-- 查询指定逻辑库中未被使用的存储单元
-
-```sql
-SHOW STORAGE UNITS WHERE USAGE_COUNT = 0 FROM sharding_db;
-```
-
-```sql
-mysql> SHOW STORAGE UNITS WHERE USAGE_COUNT = 0 FROM sharding_db;
-+------+-------+-----------+------+------+---------------------------------+---------------------------+---------------------------+---------------+---------------+-----------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
[...]
-| name | type | host | port | db | connection_timeout_milliseconds |
idle_timeout_milliseconds | max_lifetime_milliseconds | max_pool_size |
min_pool_size | read_only | other_attributes
[...]
-+------+-------+-----------+------+------+---------------------------------+---------------------------+---------------------------+---------------+---------------+-----------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
[...]
-| ds_1 | MySQL | 127.0.0.1 | 3306 | db1 | 30000 |
60000 | 2100000 | 50 | 1
| false |
{"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":true,"isolateInternalQueries":false}
|
-| ds_0 | MySQL | 127.0.0.1 | 3306 | db0 | 30000 |
60000 | 2100000 | 50 | 1
| false |
{"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":true,"isolateInternalQueries":false}
|
-+------+-------+-----------+------+------+---------------------------------+---------------------------+---------------------------+---------------+---------------+-----------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
[...]
-2 rows in set (0.03 sec)
-```
-
-- 查询当前逻辑库中未被使用的存储单元
-
-```sql
-SHOW STORAGE UNITS WHERE USAGE_COUNT = 0;
-```
+- 查询当前逻辑库中的存储单元
```sql
-mysql> SHOW STORAGE UNITS WHERE USAGE_COUNT=0;
-+------+-------+-----------+------+------+---------------------------------+---------------------------+---------------------------+---------------+---------------+-----------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
[...]
-| name | type | host | port | db | connection_timeout_milliseconds |
idle_timeout_milliseconds | max_lifetime_milliseconds | max_pool_size |
min_pool_size | read_only | other_attributes
[...]
-+------+-------+-----------+------+------+---------------------------------+---------------------------+---------------------------+---------------+---------------+-----------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
[...]
-| ds_1 | MySQL | 127.0.0.1 | 3306 | db1 | 30000 |
60000 | 2100000 | 50 | 1
| false |
{"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":true,"isolateInternalQueries":false}
|
-| ds_0 | MySQL | 127.0.0.1 | 3306 | db0 | 30000 |
60000 | 2100000 | 50 | 1
| false |
{"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":true,"isolateInternalQueries":false}
|
-+------+-------+-----------+------+------+---------------------------------+---------------------------+---------------------------+---------------+---------------+-----------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
[...]
+mysql> SHOW STORAGE UNITS;
++------+-------+-----------+------+------+---------------------------------+---------------------------+---------------------------+---------------+---------------+-----------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
+| name | type | host | port | db | connection_timeout_milliseconds |
idle_timeout_milliseconds | max_lifetime_milliseconds | max_pool_size |
min_pool_size | read_only | other_attributes
|
++------+-------+-----------+------+------+---------------------------------+---------------------------+---------------------------+---------------+---------------+-----------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
+| ds_1 | MySQL | 127.0.0.1 | 3306 | db1 | 30000 |
60000 | 2100000 | 50 | 1
| false |
{"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"keepaliveTime":0,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":true,"isolateInternalQueries":false}
|
+| ds_0 | MySQL | 127.0.0.1 | 3306 | db0 | 30000 |
60000 | 2100000 | 50 | 1
| false |
{"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"keepaliveTime":0,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":true,"isolateInternalQueries":false}
|
++------+-------+-----------+------+------+---------------------------------+---------------------------+---------------------------+---------------+---------------+-----------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
2 rows in set (0.01 sec)
```
-- 查询指定逻辑库的存储单元
-
-```sql
-SHOW STORAGE UNITS FROM sharding_db;
-```
+- 查询指定逻辑库中的存储单元
```sql
mysql> SHOW STORAGE UNITS FROM sharding_db;
-+------+-------+-----------+------+------+---------------------------------+---------------------------+---------------------------+---------------+---------------+-----------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
[...]
-| name | type | host | port | db | connection_timeout_milliseconds |
idle_timeout_milliseconds | max_lifetime_milliseconds | max_pool_size |
min_pool_size | read_only | other_attributes
[...]
-+------+-------+-----------+------+------+---------------------------------+---------------------------+---------------------------+---------------+---------------+-----------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
[...]
-| ds_1 | MySQL | 127.0.0.1 | 3306 | db1 | 30000 |
60000 | 2100000 | 50 | 1
| false |
{"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":true,"isolateInternalQueries":false}
|
-| ds_0 | MySQL | 127.0.0.1 | 3306 | db0 | 30000 |
60000 | 2100000 | 50 | 1
| false |
{"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":true,"isolateInternalQueries":false}
|
-+------+-------+-----------+------+------+---------------------------------+---------------------------+---------------------------+---------------+---------------+-----------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
[...]
++------+-------+-----------+------+------+---------------------------------+---------------------------+---------------------------+---------------+---------------+-----------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
+| name | type | host | port | db | connection_timeout_milliseconds |
idle_timeout_milliseconds | max_lifetime_milliseconds | max_pool_size |
min_pool_size | read_only | other_attributes
|
++------+-------+-----------+------+------+---------------------------------+---------------------------+---------------------------+---------------+---------------+-----------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
+| ds_1 | MySQL | 127.0.0.1 | 3306 | db1 | 30000 |
60000 | 2100000 | 50 | 1
| false |
{"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"keepaliveTime":0,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":true,"isolateInternalQueries":false}
|
+| ds_0 | MySQL | 127.0.0.1 | 3306 | db0 | 30000 |
60000 | 2100000 | 50 | 1
| false |
{"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"keepaliveTime":0,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":true,"isolateInternalQueries":false}
|
++------+-------+-----------+------+------+---------------------------------+---------------------------+---------------------------+---------------+---------------+-----------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
2 rows in set (0.01 sec)
```
-- 查询当前逻辑库的存储单元
+- 使用 LIKE 子句查询存储单元
```sql
-SHOW STORAGE UNITS;
+mysql> SHOW STORAGE UNITS LIKE '%_0';
++------+-------+-----------+------+------+---------------------------------+---------------------------+---------------------------+---------------+---------------+-----------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
+| name | type | host | port | db | connection_timeout_milliseconds |
idle_timeout_milliseconds | max_lifetime_milliseconds | max_pool_size |
min_pool_size | read_only | other_attributes
|
++------+-------+-----------+------+------+---------------------------------+---------------------------+---------------------------+---------------+---------------+-----------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
+| ds_0 | MySQL | 127.0.0.1 | 3306 | db0 | 30000 |
60000 | 2100000 | 50 | 1
| false |
{"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"keepaliveTime":0,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":true,"isolateInternalQueries":false}
|
++------+-------+-----------+------+------+---------------------------------+---------------------------+---------------------------+---------------+---------------+-----------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
+1 rows in set (0.01 sec)
```
-```sql
-mysql> SHOW STORAGE UNITS;
-+------+-------+-----------+------+------+---------------------------------+---------------------------+---------------------------+---------------+---------------+-----------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
[...]
-| name | type | host | port | db | connection_timeout_milliseconds |
idle_timeout_milliseconds | max_lifetime_milliseconds | max_pool_size |
min_pool_size | read_only | other_attributes
[...]
-+------+-------+-----------+------+------+---------------------------------+---------------------------+---------------------------+---------------+---------------+-----------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
[...]
-| ds_1 | MySQL | 127.0.0.1 | 3306 | db1 | 30000 |
60000 | 2100000 | 50 | 1
| false |
{"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":true,"isolateInternalQueries":false}
|
-| ds_0 | MySQL | 127.0.0.1 | 3306 | db0 | 30000 |
60000 | 2100000 | 50 | 1
| false |
{"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":true,"isolateInternalQueries":false}
|
-+------+-------+-----------+------+------+---------------------------------+---------------------------+---------------------------+---------------+---------------+-----------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
[...]
-2 rows in set (0.00 sec)
-```
### 保留字
-`SHOW`、`STORAGE`、`UNITS`、`WHERE`、`USAGE_COUNT`、`FROM`
+`SHOW`、`STORAGE`、`UNITS`、`FROM`、`LIKE`
### 相关链接
diff --git
a/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rql/storage-unit-query/show-storage-units.en.md
b/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rql/storage-unit-query/show-storage-units.en.md
index 90c03e3a2f5..b8037653170 100644
---
a/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rql/storage-unit-query/show-storage-units.en.md
+++
b/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rql/storage-unit-query/show-storage-units.en.md
@@ -13,19 +13,16 @@ The `SHOW STORAGE UNITS` syntax is used to query the
storage units that have bee
{{% tab name="Grammar" %}}
```sql
ShowStorageUnit ::=
- 'SHOW' 'STORAGE' 'UNITS' ('FROM' databaseName)? showLike? ('WHERE'
'USAGE_COUNT' '=' usageCount)?
+ 'SHOW' 'STORAGE' 'UNITS' ('FROM' databaseName)? showLike?
+
+databaseName ::=
+ identifier
showLike ::=
'LIKE' likePattern
likePattern ::=
string
-
-usageCount ::=
- int
-
-databaseName ::=
- identifier
```
{{% /tab %}}
{{% tab name="Railroad diagram" %}}
@@ -39,86 +36,64 @@ databaseName ::=
### Return Value Description
-| Column | Description |
-|-----------|------------------------|
-| name | Storage unit name |
-| type | Storage unit type |
-| host | Storage unit host |
-| port | Storage unit port |
-| db | Database name |
-| attribute | Storage unit attribute |
+| Column | Description |
+|---------------------------------|-----------------------------------|
+| name | Storage unit name |
+| type | Storage unit type |
+| host | Storage unit host |
+| port | Storage unit port |
+| db | Database name |
+| connection_timeout_milliseconds | connection timeout (milliseconds) |
+| idle_timeout_milliseconds | idle timeout (milliseconds) |
+| max_lifetime_milliseconds | max lifetime (milliseconds) |
+| max_pool_size | max pool size |
+| min_pool_size | min pool size |
+| read_only | read-only flag |
+| other_attributes | other attributes |
### Example
-- Query unused storage units for the specified database
+- Query storage units from current database
```sql
-SHOW STORAGE UNITS WHERE USAGE_COUNT = 0 FROM sharding_db;
-```
-
-```
-mysql> SHOW STORAGE UNITS WHERE USAGE_COUNT = 0 FROM sharding_db;
-+------+-------+-----------+------+------+---------------------------------+---------------------------+---------------------------+---------------+---------------+-----------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
[...]
-| name | type | host | port | db | connection_timeout_milliseconds |
idle_timeout_milliseconds | max_lifetime_milliseconds | max_pool_size |
min_pool_size | read_only | other_attributes
[...]
-+------+-------+-----------+------+------+---------------------------------+---------------------------+---------------------------+---------------+---------------+-----------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
[...]
-| ds_1 | MySQL | 127.0.0.1 | 3306 | db1 | 30000 |
60000 | 2100000 | 50 | 1
| false |
{"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":true,"isolateInternalQueries":false}
|
-| ds_0 | MySQL | 127.0.0.1 | 3306 | db0 | 30000 |
60000 | 2100000 | 50 | 1
| false |
{"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":true,"isolateInternalQueries":false}
|
-+------+-------+-----------+------+------+---------------------------------+---------------------------+---------------------------+---------------+---------------+-----------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
[...]
-2 rows in set (0.03 sec)
-```
-
-- Query unused storage units for current database
-
-```sql
-SHOW STORAGE UNITS WHERE USAGE_COUNT = 0;
-```
-
-```sql
-mysql> SHOW STORAGE UNITS WHERE USAGE_COUNT=0;
-+------+-------+-----------+------+------+---------------------------------+---------------------------+---------------------------+---------------+---------------+-----------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
[...]
-| name | type | host | port | db | connection_timeout_milliseconds |
idle_timeout_milliseconds | max_lifetime_milliseconds | max_pool_size |
min_pool_size | read_only | other_attributes
[...]
-+------+-------+-----------+------+------+---------------------------------+---------------------------+---------------------------+---------------+---------------+-----------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
[...]
-| ds_1 | MySQL | 127.0.0.1 | 3306 | db1 | 30000 |
60000 | 2100000 | 50 | 1
| false |
{"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":true,"isolateInternalQueries":false}
|
-| ds_0 | MySQL | 127.0.0.1 | 3306 | db0 | 30000 |
60000 | 2100000 | 50 | 1
| false |
{"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":true,"isolateInternalQueries":false}
|
-+------+-------+-----------+------+------+---------------------------------+---------------------------+---------------------------+---------------+---------------+-----------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
[...]
+mysql> SHOW STORAGE UNITS;
++------+-------+-----------+------+------+---------------------------------+---------------------------+---------------------------+---------------+---------------+-----------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
+| name | type | host | port | db | connection_timeout_milliseconds |
idle_timeout_milliseconds | max_lifetime_milliseconds | max_pool_size |
min_pool_size | read_only | other_attributes
|
++------+-------+-----------+------+------+---------------------------------+---------------------------+---------------------------+---------------+---------------+-----------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
+| ds_1 | MySQL | 127.0.0.1 | 3306 | db1 | 30000 |
60000 | 2100000 | 50 | 1
| false |
{"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"keepaliveTime":0,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":true,"isolateInternalQueries":false}
|
+| ds_0 | MySQL | 127.0.0.1 | 3306 | db0 | 30000 |
60000 | 2100000 | 50 | 1
| false |
{"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"keepaliveTime":0,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":true,"isolateInternalQueries":false}
|
++------+-------+-----------+------+------+---------------------------------+---------------------------+---------------------------+---------------+---------------+-----------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
2 rows in set (0.01 sec)
```
-- Query storage units for the specified database
-```sql
-SHOW STORAGE UNITS FROM sharding_db;
-```
+- Query storage units from specified database
```sql
mysql> SHOW STORAGE UNITS FROM sharding_db;
-+------+-------+-----------+------+------+---------------------------------+---------------------------+---------------------------+---------------+---------------+-----------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
[...]
-| name | type | host | port | db | connection_timeout_milliseconds |
idle_timeout_milliseconds | max_lifetime_milliseconds | max_pool_size |
min_pool_size | read_only | other_attributes
[...]
-+------+-------+-----------+------+------+---------------------------------+---------------------------+---------------------------+---------------+---------------+-----------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
[...]
-| ds_1 | MySQL | 127.0.0.1 | 3306 | db1 | 30000 |
60000 | 2100000 | 50 | 1
| false |
{"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":true,"isolateInternalQueries":false}
|
-| ds_0 | MySQL | 127.0.0.1 | 3306 | db0 | 30000 |
60000 | 2100000 | 50 | 1
| false |
{"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":true,"isolateInternalQueries":false}
|
-+------+-------+-----------+------+------+---------------------------------+---------------------------+---------------------------+---------------+---------------+-----------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
[...]
++------+-------+-----------+------+------+---------------------------------+---------------------------+---------------------------+---------------+---------------+-----------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
+| name | type | host | port | db | connection_timeout_milliseconds |
idle_timeout_milliseconds | max_lifetime_milliseconds | max_pool_size |
min_pool_size | read_only | other_attributes
|
++------+-------+-----------+------+------+---------------------------------+---------------------------+---------------------------+---------------+---------------+-----------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
+| ds_1 | MySQL | 127.0.0.1 | 3306 | db1 | 30000 |
60000 | 2100000 | 50 | 1
| false |
{"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"keepaliveTime":0,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":true,"isolateInternalQueries":false}
|
+| ds_0 | MySQL | 127.0.0.1 | 3306 | db0 | 30000 |
60000 | 2100000 | 50 | 1
| false |
{"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"keepaliveTime":0,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":true,"isolateInternalQueries":false}
|
++------+-------+-----------+------+------+---------------------------------+---------------------------+---------------------------+---------------+---------------+-----------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
2 rows in set (0.01 sec)
```
-- Query storage units for the current database
+- Query storage units with like clause
```sql
-SHOW STORAGE UNITS;
+mysql> SHOW STORAGE UNITS LIKE '%_0';
++------+-------+-----------+------+------+---------------------------------+---------------------------+---------------------------+---------------+---------------+-----------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
+| name | type | host | port | db | connection_timeout_milliseconds |
idle_timeout_milliseconds | max_lifetime_milliseconds | max_pool_size |
min_pool_size | read_only | other_attributes
|
++------+-------+-----------+------+------+---------------------------------+---------------------------+---------------------------+---------------+---------------+-----------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
+| ds_0 | MySQL | 127.0.0.1 | 3306 | db0 | 30000 |
60000 | 2100000 | 50 | 1
| false |
{"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"keepaliveTime":0,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":true,"isolateInternalQueries":false}
|
++------+-------+-----------+------+------+---------------------------------+---------------------------+---------------------------+---------------+---------------+-----------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
+1 rows in set (0.01 sec)
```
-```sql
-mysql> SHOW STORAGE UNITS;
-+------+-------+-----------+------+------+---------------------------------+---------------------------+---------------------------+---------------+---------------+-----------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
[...]
-| name | type | host | port | db | connection_timeout_milliseconds |
idle_timeout_milliseconds | max_lifetime_milliseconds | max_pool_size |
min_pool_size | read_only | other_attributes
[...]
-+------+-------+-----------+------+------+---------------------------------+---------------------------+---------------------------+---------------+---------------+-----------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
[...]
-| ds_1 | MySQL | 127.0.0.1 | 3306 | db1 | 30000 |
60000 | 2100000 | 50 | 1
| false |
{"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":true,"isolateInternalQueries":false}
|
-| ds_0 | MySQL | 127.0.0.1 | 3306 | db0 | 30000 |
60000 | 2100000 | 50 | 1
| false |
{"healthCheckProperties":{},"initializationFailTimeout":1,"validationTimeout":5000,"leakDetectionThreshold":0,"registerMbeans":false,"allowPoolSuspension":false,"autoCommit":true,"isolateInternalQueries":false}
|
-+------+-------+-----------+------+------+---------------------------------+---------------------------+---------------------------+---------------+---------------+-----------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
[...]
-2 rows in set (0.00 sec)
-```
### Reserved word
-`SHOW`, `STORAGE`, `UNIT`, `WHERE`, `USAGE_COUNT`, `FROM`
+`SHOW`, `STORAGE`, `UNITS`, `FROM`, `LIKE`
### Related links
