OceanBase 并行查詢的參數(shù)調(diào)優(yōu)

obclient>SHOW VARIABLES LIKE '%paral%';

+-------------------------+-------+
| Variable_name           | Value |
+-------------------------+-------+
| ob_max_parallel_degree  | 32    |
| ob_stmt_parallel_degree | 1     |
| parallel_max_servers    | 5     |
| parallel_servers_target | 4     |
+-------------------------+-------+
4 rows in set (0.00 sec)

注意 
ob_stmt_parallel_degree 參數(shù)不需要設(shè)置，對(duì) PX 框架無(wú)效。

obclient>SHOW PARAMETERS LIKE '%dtl%';

+-------+----------+----------------+----------+-----------------+-----------+-------+---------------+----------+---------+---------+-------------------+
| zone  | svr_type | svr_ip         | svr_port | name            | data_type | value | info          | section  | scope   | source  | edit_level        |
+-------+----------+----------------+----------+-----------------+-----------+-------+---------------+----------+---------+---------+-------------------+
| zone1 | observer | 100.81.152.114 |    36500 | dtl_buffer_size | NULL      | 64K   | to be removed | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE |
+-------+----------+----------------+----------+-----------------+-----------+-------+---------------+----------+---------+---------+-------------------+
1 row in set (0.01 sec)