我的书签
添加书签
移除书签SQL-BLOCK-RULE
Name
SHOW SQL BLOCK RULE
Description
View the configured SQL blocking rules. If you do not specify a rule name, you will view all rules.
grammar:
1. SHOW SQL_BLOCK_RULE [FOR RULE_NAME];
Example
- View all rules.
1. mysql> SHOW SQL_BLOCK_RULE;
2. +------------+----------------------------+---------+- -------------+------------+-------------+--------+- -------+
3. | Name | Sql | SqlHash | PartitionNum | TabletNum | Cardinality | Global | Enable |
4. +------------+----------------------------+---------+- -------------+------------+-------------+--------+- -------+
5. | test_rule | select * from order_analysis | NULL | 0 | 0 | 0 | true | true |
6. | test_rule2 | NULL | NULL | 30 | 0 | 10000000000 | false | true |
7. +------------+----------------------------+---------+- -------------+------------+-------------+--------+- -------+
8. 2 rows in set (0.01 sec)
2. Make a rule name query
1. mysql> SHOW SQL_BLOCK_RULE FOR test_rule2;
2. +------------+------+---------+---------------+---- -------+-------------+--------+--------+
3. | Name | Sql | SqlHash | PartitionNum | TabletNum | Cardinality | Global | Enable |
4. +------------+------+---------+---------------+---- -------+-------------+--------+--------+
5. | test_rule2 | NULL | NULL | 30 | 0 | 10000000000 | false | true |
6. +------------+------+---------+---------------+---- -------+-------------+--------+--------+
7. 1 row in set (0.00 sec)
Keywords
1. SHOW, SQL_BLOCK_RULE
