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:

SHOW SQL_BLOCK_RULE [FOR RULE_NAME];

Example

1. View all rules.

   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. Make a rule name query

   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