gbase数据、南大通用产品文档：GBase8s管理性能

本节描述了可能影响查询性能的问题：
•
FET_BUF_SIZE 和 BIG_FET_BUF_SIZE 环境变量
•
大对象的内存管理
•
减少网络流量
•
使用批量插入

GBase 8s JDBC Driver 程序员指南
南大通用数据技术股份有限公司
- 232 -

•
调整连接池

BackUp table vcname000001.test.t2 end
===================ParallelProcessTable
End============================
========================SaveBackUpInfo=======================

GBase 8a MPP Cluster 产品手册
4 管理员指南
文档版本953（2022-09-15）
南大通用数据技术股份有限公司
397
==========
注：如果不加参数-R，则默认并行度为4。

语法
SHOW RESOURCE POOL EVENTS WHERE resource_pool_name = 'pool_name'
AND vc_name=’xxxx’;
示例
gbase> SHOW RESOURCE POOL EVENTS WHERE resource_pool_name = 'pool1' AND
vc_name='vcname000001';
+--------------+---------+--------------+------------------+--------------------+---------------------+---------+----
----------------------------+------------+--------------------+
| NODE_NAME
| VC_ID
| VC_NAME
| RESOURCE_POOL_ID |
RESOURCE_POOL_NAME | EVENT_TIME
| TASK_ID | STATEMENT
| EVENT_TYPE | EVENT_DESCRIPTION
|
+--------------+---------+--------------+------------------+--------------------+---------------------+---------+----
----------------------------+------------+--------------------+
| coordinator1 | vc00001 | vcname000001 |
655548 | pool1
| 2018-07-05
09:48:26 |
655594 | insert into t1 select * from t | Terminate
| Exceed max runtime |
| coordinator1 | vc00001 | vcname000001 |
655548 | pool1
| 2018-07-05
09:48:47 |
655596 | insert into t select * from t
| Terminate
| Exceed max runtime |
| coordinator1 | vc00001 | vcname000001 |
655548 | pool1
| 2018-07-05
09:58:03 |
720897 | insert into t1 select * from t | Terminate
| Exceed max runtime |
| coordinator1 | vc00001 | vcname000001 |
655548 | pool1
| 2018-07-05
09:58:17 |
720899 | insert into t1 select * from t | Terminate
| Exceed max runtime |
| coordinator1 | vc00001 | vcname000001 |
655548 | pool1
| 2018-07-05
10:20:11 | 1048577 | insert into t1 select * from t | Terminate
| Exceed max runtime |
| coordinator1 | vc00001 | vcname000001 |
655548 | pool1
| 2018-07-05
10:44:49 | 1179649 | insert into t1 select * from t | Terminate
| Exceed max runtime |
| coordinator1 | vc00001 | vcname000001 |
655548 | pool1
| 2018-07-05

GBase 8a MPP Cluster 产品手册
4 管理员指南
文档版本953（2022-04-10）
南大通用数据技术股份有限公司
502
10:45:48 | 1179655 | insert into t1 select * from t | Terminate
| Exceed max runtime |
+--------------+---------+--------------+------------------+--------------------+---------------------+---------+----
----------------------------+------------+--------------------+
7 rows in set (Elapsed: 00:00:00.02)