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