SHOW STORAGE POLICY
Description
View tables and partitions associated with all/specified storage policies.
Syntax
SHOW STORAGE POLICY USING [FOR <storage_policy_name>]
Required Parameters
<storage_policy_name>
The name of the storage policy to view.
The prerequisite for successfully executing this SQL command is to have ADMIN_PRIV privileges. Please refer to the privilege document.
| Privilege (Privilege) | Object (Object) | Notes (Notes) |
|---|---|---|
| ADMIN_PRIV | Entire cluster management privileges | All privileges except NODE_PRIV |
Example
- View all objects with enabled storage policies.
mysql> show storage policy using;
+-----------------------+-----------------------------------------+----------------------------------------+------------+
| PolicyName | Database | Table | Partitions |
+-----------------------+-----------------------------------------+----------------------------------------+------------+
| test_storage_policy | regression_test_cold_heat_separation_p2 | table_with_storage_policy_1 | ALL |
| test_storage_policy | regression_test_cold_heat_separation_p2 | partition_with_multiple_storage_policy | p201701 |
| test_storage_policy_2 | regression_test_cold_heat_separation_p2 | partition_with_multiple_storage_policy | p201702 |
| test_storage_policy_2 | regression_test_cold_heat_separation_p2 | table_with_storage_policy_2 | ALL |
| test_policy | db2 | db2_test_1 | ALL |
+-----------------------+-----------------------------------------+----------------------------------------+------------+
- View objects using the storage policy test_storage_policy.
mysql> show storage policy using for test_storage_policy;
+---------------------+-----------+---------------------------------+------------+
| PolicyName | Database | Table | Partitions |
+---------------------+-----------+---------------------------------+------------+
| test_storage_policy | db_1 | partition_with_storage_policy_1 | p201701 |
| test_storage_policy | db_1 | table_with_storage_policy_1 | ALL |
+---------------------+-----------+---------------------------------+------------+
