SHOW-SQL-BLOCK-RULE

Name

SHOW SQL BLOCK RULE

Description

查看已配置的SQL阻止规则，不指定规则名则为查看所有规则。

语法：

1. SHOW SQL_BLOCK_RULE [FOR RULE_NAME];

Example

1. 查看所有规则。

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

Best Practice