SHOW-SQL-BLOCK-RULE

SHOW-SQL-BLOCK-RULE

Name

SHOW SQL BLOCK RULE

Description

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

语法：

SHOW SQL_BLOCK_RULE [FOR RULE_NAME];

Example

1. 查看所有规则。

   mysql> SHOW SQL_BLOCK_RULE;
   +------------+------------------------+---------+--------------+-----------+-------------+--------+--------+
   | Name       | Sql                    | SqlHash | PartitionNum | TabletNum | Cardinality | Global | Enable |
   +------------+------------------------+---------+--------------+-----------+-------------+--------+--------+
   | test_rule  | select * from order_analysis | NULL    | 0            | 0         | 0           | true   | true   |
   | test_rule2 | NULL                   | NULL    | 30           | 0         | 10000000000 | false  | true   |
   +------------+------------------------+---------+--------------+-----------+-------------+--------+--------+
   2 rows in set (0.01 sec)

2. 指定规则名查询

   mysql> SHOW SQL_BLOCK_RULE FOR test_rule2;
   +------------+------+---------+--------------+-----------+-------------+--------+--------+
   | Name       | Sql  | SqlHash | PartitionNum | TabletNum | Cardinality | Global | Enable |
   +------------+------+---------+--------------+-----------+-------------+--------+--------+
   | test_rule2 | NULL | NULL    | 30           | 0         | 10000000000 | false  | true   |
   +------------+------+---------+--------------+-----------+-------------+--------+--------+
   1 row in set (0.00 sec)
   

Keywords

SHOW, SQL_BLOCK_RULE

Best Practice