我的书签
添加书签
移除书签SHOW-SQL-BLOCK-RULE
Name
SHOW SQL BLOCK RULE
Description
查看已配置的SQL阻止规则，不指定规则名则为查看所有规则。
语法：
1. SHOW SQL_BLOCK_RULE [FOR RULE_NAME];
Example
- 查看所有规则。
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. 指定规则名查询
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
