达梦：TPCC 压测

- 造数
- - 1. 脚本启动
  - 2. 检查数据库信息
  - 3. 删除旧用户和表空间
  - 4. 创建新的表空间
  - 5. 创建用户和表
  - 6. 数据加载
  - 7. 创建索引
  - 8. 创建存储过程和序列
  - 9. 检查数据空间使用情况
  - 10. 启用表的快速访问池
  - 11. 数据加载完成
  - 总结
- 压测
- - 1. 脚本启动
  - 2. 检查数据表空间
  - 3. 设置表的快速池标志
  - 4. 检查 INI 配置信息
  - 5. 运行 TPC-C 基准测试
  - 6. 测试后检查日志和表空间
  - 7. 测试完成
  - 总结

造数

1. 脚本启动

./tpcc_load.sh dameng-753de107

说明：
- tpcc_load.sh 是一个用于加载 TPC-C 测试数据的脚本。
- 参数 dameng-753de107 是测试的标识符，用于区分不同的测试实例。
目的：
- 初始化数据库环境，创建表结构，加载测试数据，为后续的 TPC-C 性能测试做好准备。

2. 检查数据库信息

SELECT 'TEST_VERSION',ID_CODE;

说明：
- 查询数据库的版本信息和测试代码。
结果：
- 数据库版本：DM Database Server x64 V8
- 实例名称：DAMENG_0
- 日志文件大小：256MB（每个日志文件）
- 字符集：GBK18030
- 页面大小：4KB
- 扩展块大小：16KB
- 数据库模式：PRIMARY（主库）

3. 删除旧用户和表空间

DROP USER "BENCHMARKSQL" CASCADE;
DROP TABLESPACE BENCHMARKSQL1;
...
DROP TABLESPACE BENCHMARKSQL10;

说明：
- 删除名为 BENCHMARKSQL 的用户及其所有对象。
- 删除与该用户相关的表空间（BENCHMARKSQL1 到 BENCHMARKSQL10）。
目的：
- 清理旧的测试环境，为重新创建数据表和导入数据做好准备。

4. 创建新的表空间

CREATE TABLESPACE BENCHMARKSQL1 DATAFILE 'BENCHMARKSQL1.dbf' SIZE 512 AUTOEXTEND ON NEXT 2048;
...
CREATE TABLESPACE BENCHMARKSQL10 DATAFILE 'BENCHMARKSQL10.dbf' SIZE 512 AUTOEXTEND ON NEXT 2048;

说明：
- 创建 10 个新的表空间（BENCHMARKSQL1 到 BENCHMARKSQL10）。
- 每个表空间的数据文件初始大小为 512MB，自动扩展，每次扩展 2048MB。
目的：
- 为后续创建的数据表提供存储空间。

5. 创建用户和表

CREATE USER "BENCHMARKSQL" IDENTIFIED BY "123456789" DEFAULT TABLESPACE "BENCHMARKSQL1";
GRANT DBA TO BENCHMARKSQL;

说明：
- 创建用户 BENCHMARKSQL，并设置默认表空间为 BENCHMARKSQL1。
- 赋予该用户 DBA 权限。
表创建：
- 创建了多个表（如 bmsql_config、bmsql_warehouse、bmsql_district 等），这些表是 TPC-C 测试的核心数据表。
- 表结构包含主键、索引和存储过程，用于支持 TPC-C 测试的事务操作。

6. 数据加载

Starting BenchmarkSQL LoadData

说明：
- 使用多线程（10 个工作线程）进行数据加载。
- 数据加载到不同的表中（如 ITEM、WAREHOUSE、ORDER 等）。
进度：
- 每个工作线程负责加载特定的数据表或分区。
- 日志显示了每个表的加载进度和完成情况。
结果：
- 数据加载总共耗时 121 秒，表示数据导入过程完成。

7. 创建索引

create index ndx_customer_name on BENCHMARKSQL.BMSQL_customer (c_w_id, c_d_id, c_last, c_first);

说明：
- 为 BMSQL_customer 表创建索引 ndx_customer_name，以优化查询性能。
目的：
- 提高查询速度，减少查询时间。

8. 创建存储过程和序列

create or replace procedure BENCHMARKSQL.createsequence

说明：
- 创建存储过程 createsequence，用于生成 BMSQL_HISTORY 表的序列。
序列创建：
- 使用 hist_id_seq 序列生成 hist_id 字段的值。
修改表结构：
- 修改 BMSQL_HISTORY 表的 hist_id 字段，使其默认值使用刚创建的序列。

9. 检查数据空间使用情况

select table_used_space('BENCHMARKSQL','BMSQL_CUSTOMER')*(page()/1024)/1024  a union all
...
select table_used_space('BENCHMARKSQL','BMSQL_WAREHOUSE')*(page()/1024)/1024 a;

说明：
- 使用 table_used_space 函数查看不同表的空间使用情况。

结果：

每个表的已使用空间（MB）：

BMSQL_CUSTOMER: 769 MB
BMSQL_DISTRICT: 0 MB
BMSQL_HISTORY: 47 MB
BMSQL_ITEM: 10 MB
BMSQL_NEW_ORDER: 12 MB
BMSQL_OORDER: 78 MB
BMSQL_ORDER_LINE: 1107 MB
BMSQL_STOCK: 1453 MB
BMSQL_WAREHOUSE: 0 MB

总空间使用：3476 MB

10. 启用表的快速访问池

SP_SET_TAB_FAST_POOL_FLAG('BENCHMARKSQL', 'BMSQL_ITEM', 1);

说明：
- 为 BMSQL_ITEM、BMSQL_WAREHOUSE、BMSQL_DISTRICT 等表启用快速访问池标志。
目的：
- 将这些表的数据缓存到内存中，以提高查询性能。
参考：
- 快速访问池标志的作用和配置详见 DM 内存结构-CSDN博客。

11. 数据加载完成

!!!load data used:121s

说明：
- 数据加载总共耗时 121 秒，表示数据导入过程完成。
目的：
- 确保数据加载成功，为后续的 TPC-C 性能测试做好准备。

总结

主要步骤：
- 检查数据库信息。
- 删除旧用户和表空间。
- 创建新的表空间。
- 创建用户和表。
- 加载测试数据。
- 创建索引。
- 创建存储过程和序列。
- 检查数据空间使用情况。
- 启用表的快速访问池。
目的：
- 初始化数据库环境，为 TPC-C 性能测试做好准备。
- 优化数据库性能，包括索引创建、序列管理、快速访问池设置等。
结果：
- 数据加载成功，总耗时 121 秒。
- 数据库表空间和内存配置优化完成，确保测试的性能和稳定性。

如果有其他问题或需要进一步分析，请随时告知！

在这里插入图片描述

./tpcc_load.sh dameng-753de107
---BEGIN---
!!!tpcc start: 2025-02-14 18:36:05
!!!check db info


Server[10.10.180.236:8265]:mode is primary, state is open
login used time : 3.015(ms)
disql V8
SQL> SQL> SQL> SELECT 'TEST_VERSION',ID_CODE;

LINEID     'TEST_VERSION' ID_CODE
---------- -------------- -----------------------------------------
1          TEST_VERSION   --03134284132-20240115-215128-20081 Pack2

used time: 0.624(ms). Execute id is 264900.
SQL> SELECT 'INSTANCE_NAME' DATABASE_VALUE,INSTANCE_NAME  DATABASE_CLUSTER FROM V$INSTANCE UNION ALL
SELECT 'DATABASE_VERSION',SUBSTR(SVR_VERSION,INSTR(SVR_VERSION,'('))  FROM V$INSTANCE UNION ALL
SELECT 'RLOG_SIZE',WM_CONCAT(CLIENT_PATH||':'||RLOG_SIZE/1024/1024||'MB') FROM V$RLOGFILE UNION ALL
SELECT 'CHARECTOR',CASE SF_GET_UNICODE_FLAG() WHEN '0' THEN 'GBK18030' WHEN '1' THEN 'UTF-8' WHEN '2' THEN 'EUC-KR' END UNION ALL
SELECT 'PAGE_SIZE',CAST(PAGE()/1024 AS VARCHAR) UNION ALL
SELECT 'EXTENT_SIZE',CAST(SF_GET_EXTENT_SIZE() AS VARCHAR) UNION ALL
SELECT 'CASE',CAST(SF_GET_CASE_SENSITIVE_FLAG() AS VARCHAR) UNION ALL
SELECT 'DATABASE ',MODE$ FROM V$INSTANCE;

LINEID     DATABASE_VALUE   DATABASE_CLUSTER
---------- ---------------- -------------------------------------
1          INSTANCE_NAME    DAMENG_0
2          DATABASE_VERSION DM Database Server x64 V8

3          RLOG_SIZE        DAMENG01.log:256MB,DAMENG02.log:256MB
4          CHARECTOR        GBK18030
5          PAGE_SIZE        4
6          EXTENT_SIZE      16
7          CASE             1
8          DATABASE         PRIMARY

8 rows got

used time: 0.439(ms). Execute id is 264901.
SQL>
!!!create table!!!


Server[10.10.180.236:8265]:mode is primary, state is open
login used time : 2.556(ms)
disql V8
SQL> SQL> SQL> DROP USER "BENCHMARKSQL" CASCADE;
executed successfully
used time: 35.163(ms). Execute id is 265000.
SQL> DROP TABLESPACE BENCHMARKSQL1;
executed successfully
used time: 11.067(ms). Execute id is 265001.
SQL> DROP TABLESPACE BENCHMARKSQL2;
executed successfully
used time: 11.621(ms). Execute id is 265002.
SQL> DROP TABLESPACE BENCHMARKSQL3;
executed successfully
used time: 14.844(ms). Execute id is 265003.
SQL> DROP TABLESPACE BENCHMARKSQL4;
executed successfully
used time: 9.390(ms). Execute id is 265004.
SQL> DROP TABLESPACE BENCHMARKSQL5;
executed successfully
used time: 12.764(ms). Execute id is 265005.
SQL> DROP TABLESPACE BENCHMARKSQL6;
executed successfully
used time: 9.259(ms). Execute id is 265006.
SQL> DROP TABLESPACE BENCHMARKSQL7;
executed successfully
used time: 11.154(ms). Execute id is 265007.
SQL> DROP TABLESPACE BENCHMARKSQL8;
executed successfully
used time: 9.363(ms). Execute id is 265008.
SQL> DROP TABLESPACE BENCHMARKSQL9;
executed successfully
used time: 8.760(ms). Execute id is 265009.
SQL> DROP TABLESPACE BENCHMARKSQL10;
executed successfully
used time: 10.216(ms). Execute id is 265010.
SQL> CREATE TABLESPACE BENCHMARKSQL1 DATAFILE 'BENCHMARKSQL1.dbf' SIZE 512 AUTOEXTEND ON NEXT 2048;
executed successfully
used time: 34.184(ms). Execute id is 265011.
SQL> CREATE TABLESPACE BENCHMARKSQL2 DATAFILE 'BENCHMARKSQL2.dbf' SIZE 512 AUTOEXTEND ON NEXT 2048;
executed successfully
used time: 30.019(ms). Execute id is 265012.
SQL> CREATE TABLESPACE BENCHMARKSQL3 DATAFILE 'BENCHMARKSQL3.dbf' SIZE 512 AUTOEXTEND ON NEXT 2048;
executed successfully
used time: 30.444(ms). Execute id is 265013.
SQL> CREATE TABLESPACE BENCHMARKSQL4 DATAFILE 'BENCHMARKSQL4.dbf' SIZE 512 AUTOEXTEND ON NEXT 2048;
executed successfully
used time: 33.012(ms). Execute id is 265014.
SQL> CREATE TABLESPACE BENCHMARKSQL5 DATAFILE 'BENCHMARKSQL5.dbf' SIZE 512 AUTOEXTEND ON NEXT 2048;
executed successfully
used time: 33.426(ms). Execute id is 265015.
SQL> CREATE TABLESPACE BENCHMARKSQL6 DATAFILE 'BENCHMARKSQL6.dbf' SIZE 512 AUTOEXTEND ON NEXT 2048;
executed successfully
used time: 32.138(ms). Execute id is 265016.
SQL> CREATE TABLESPACE BENCHMARKSQL7 DATAFILE 'BENCHMARKSQL7.dbf' SIZE 512 AUTOEXTEND ON NEXT 2048;
executed successfully
used time: 33.161(ms). Execute id is 265017.
SQL> CREATE TABLESPACE BENCHMARKSQL8 DATAFILE 'BENCHMARKSQL8.dbf' SIZE 512 AUTOEXTEND ON NEXT 2048;
executed successfully
used time: 29.932(ms). Execute id is 265018.
SQL> CREATE TABLESPACE BENCHMARKSQL9 DATAFILE 'BENCHMARKSQL9.dbf' SIZE 512 AUTOEXTEND ON NEXT 2048;
executed successfully
used time: 29.864(ms). Execute id is 265019.
SQL> CREATE TABLESPACE BENCHMARKSQL10 DATAFILE 'BENCHMARKSQL10.dbf' SIZE 512 AUTOEXTEND ON NEXT 2048;
executed successfully
used time: 32.817(ms). Execute id is 265020.
SQL> CREATE USER "BENCHMARKSQL" IDENTIFIED BY "123456789" DEFAULT TABLESPACE "BENCHMARKSQL1";
executed successfully
used time: 6.882(ms). Execute id is 265021.
SQL> GRANT DBA TO BENCHMARKSQL;
executed successfully
used time: 4.024(ms). Execute id is 265022.
SQL> SQL> create table BENCHMARKSQL.bmsql_config (
cfg_name    varchar(30) cluster primary key,
cfg_value   varchar(50)
);
executed successfully
used time: 7.894(ms). Execute id is 265023.
SQL> create table BENCHMARKSQL.bmsql_warehouse (
w_id        integer   not null,
w_ytd       decimal(22,2),
w_tax       float,
w_name      varchar(10),
w_street_1  varchar(20),
w_street_2  varchar(20),
w_city      varchar(20),
w_state     char(2),
w_zip       char(9),
cluster primary key(w_id)
);
executed successfully
used time: 6.670(ms). Execute id is 265024.
SQL> create table BENCHMARKSQL.bmsql_district (
d_w_id       integer       not null,
d_id         integer       not null,
d_ytd        decimal(22,2),
d_tax        float,
d_next_o_id  integer,
d_name       varchar(10),
d_street_1   varchar(20),
d_street_2   varchar(20),
d_city       varchar(20),
d_state      char(2),
d_zip        char(9),
cluster primary key(d_w_id, d_id)
);
executed successfully
used time: 5.697(ms). Execute id is 265025.
SQL> create table BENCHMARKSQL.bmsql_customer (
c_w_id         integer        not null,
c_d_id         integer        not null,
c_id           integer        not null,
c_discount     float,
c_credit       char(2),
c_last         varchar(16),
c_first        varchar(16),
c_credit_lim   float,
c_balance      float,
c_ytd_payment  float,
c_payment_cnt  integer,
c_delivery_cnt integer,
c_street_1     varchar(20),
c_street_2     varchar(20),
c_city         varchar(20),
c_state        char(2),
c_zip          char(9),
c_phone        char(16),
c_since        timestamp,
c_middle       char(2),
c_data         varchar(500),
cluster primary key(c_w_id, c_d_id, c_id)
);
executed successfully
used time: 6.234(ms). Execute id is 265026.
SQL> create table BENCHMARKSQL.bmsql_history (
hist_id  integer,
h_c_id   integer,
h_c_d_id integer,
h_c_w_id integer,
h_d_id   integer,
h_w_id   integer,
h_date   timestamp,
h_amount float,
h_data   varchar(24)
)storage(branch(32,32));
executed successfully
used time: 6.339(ms). Execute id is 265027.
SQL> create table BENCHMARKSQL.bmsql_oorder (
o_w_id       integer      not null,
o_d_id       integer      not null,
o_id         integer      not null,
o_c_id       integer,
o_carrier_id integer,
o_ol_cnt     float,
o_all_local  float,
o_entry_d    timestamp,
cluster primary key(o_w_id, o_d_id, o_id)
);
executed successfully
used time: 5.253(ms). Execute id is 265028.
SQL> create table BENCHMARKSQL.bmsql_new_order (
no_w_id  integer   not null,
no_d_id  integer   not null,
no_o_id  integer   not null,
cluster primary key(no_w_id, no_d_id, no_o_id)
);
executed successfully
used time: 4.928(ms). Execute id is 265029.
SQL> create table BENCHMARKSQL.bmsql_order_line (
ol_w_id         integer   not null,
ol_d_id         integer   not null,
ol_o_id         integer   not null,
ol_number       integer   not null,
ol_i_id         integer   not null,
ol_delivery_d   timestamp,
ol_amount       float,
ol_supply_w_id  integer,
ol_quantity     float,
ol_dist_info    char(24),
cluster primary key(ol_w_id, ol_d_id, ol_o_id, ol_number)
);
executed successfully
used time: 7.177(ms). Execute id is 265030.
SQL> create table BENCHMARKSQL.bmsql_stock (
s_w_id       integer       not null,
s_i_id       integer       not null,
s_quantity   float,
s_ytd        float,
s_order_cnt  integer,
s_remote_cnt integer,
s_data       varchar(50),
s_dist_01    char(24),
s_dist_02    char(24),
s_dist_03    char(24),
s_dist_04    char(24),
s_dist_05    char(24),
s_dist_06    char(24),
s_dist_07    char(24),
s_dist_08    char(24),
s_dist_09    char(24),
s_dist_10    char(24),
cluster primary key(s_w_id, s_i_id)
);
executed successfully
used time: 5.813(ms). Execute id is 265031.
SQL> create table BENCHMARKSQL.bmsql_item (
i_id     integer      not null,
i_name   varchar(24),
i_price  float,
i_data   varchar(50),
i_im_id  integer,
cluster primary key(i_id)
);
executed successfully
used time: 4.990(ms). Execute id is 265032.
SQL>
!!!import data!!!
!!!time: 2025-02-14 18:36:05

Starting BenchmarkSQL LoadData

driver=dm.jdbc.driver.DmDriver
conn=jdbc:dm://10.10.180.236:8265
user=BENCHMARKSQL
password=*
warehouses=20
loadWorkers=10
fileLocation (not defined)
csvNullValue (not defined - using default 'NULL')

Worker 000: Loading ITEM
Worker 001: Loading Warehouse      1
Worker 002: Loading Warehouse      2
Worker 003: Loading Warehouse      3
Worker 004: Loading Warehouse      4
Worker 005: Loading Warehouse      5
Worker 006: Loading Warehouse      6
Worker 007: Loading Warehouse      7
Worker 008: Loading Warehouse      8
Worker 009: Loading Warehouse      9
Worker 000: Loading ITEM done
Worker 000: Loading Warehouse     10

Worker 001: Loading Warehouse      1 done
Worker 001: Loading Warehouse     11
Worker 009: Loading Warehouse      9 done
Worker 009: Loading Warehouse     12
Worker 000: Loading Warehouse     10 done
Worker 000: Loading Warehouse     13
Worker 006: Loading Warehouse      6 done
Worker 006: Loading Warehouse     14
Worker 008: Loading Warehouse      8 done
Worker 008: Loading Warehouse     15
Worker 003: Loading Warehouse      3 done
Worker 003: Loading Warehouse     16
Worker 007: Loading Warehouse      7 done
Worker 007: Loading Warehouse     17
Worker 002: Loading Warehouse      2 done
Worker 002: Loading Warehouse     18
Worker 004: Loading Warehouse      4 done
Worker 004: Loading Warehouse     19
Worker 005: Loading Warehouse      5 done
Worker 005: Loading Warehouse     20
Worker 001: Loading Warehouse     11 done
Worker 005: Loading Warehouse     20 done
Worker 009: Loading Warehouse     12 done
Worker 000: Loading Warehouse     13 done
Worker 006: Loading Warehouse     14 done
Worker 007: Loading Warehouse     17 done
Worker 003: Loading Warehouse     16 done
Worker 008: Loading Warehouse     15 done
Worker 002: Loading Warehouse     18 done
Worker 004: Loading Warehouse     19 done

!!!add indexes!!!


Server[10.10.180.236:8265]:mode is primary, state is open
login used time : 2.628(ms)
disql V8
SQL> SQL> SQL> create index ndx_customer_name on BENCHMARKSQL.BMSQL_customer (c_w_id, c_d_id, c_last, c_first);
executed successfully
used time: 00:00:01.514. Execute id is 269300.
SQL> create or replace procedure BENCHMARKSQL.createsequence
as
n int;
stmt1 varchar(200);
begin
select count(*)+1 into n from BMSQL_history;
if(n != 1) then
select max(hist_id) + 1 into n from BMSQL_history;
end if;
PRINT n;
stmt1:='create sequence hist_id_seq start with '||n||' MAXVALUE 9223372036854775807 CACHE 50000;';
EXECUTE IMMEDIATE stmt1;
end;
executed successfully
used time: 37.939(ms). Execute id is 269301.
SQL> call BENCHMARKSQL.createsequence;
DMSQL executed successfully
used time: 202.638(ms). Execute id is 269302.
SQL> alter table BENCHMARKSQL.BMSQL_history modify hist_id integer default (BENCHMARKSQL.hist_id_seq.nextval);
executed successfully
used time: 286.370(ms). Execute id is 269303.
SQL> SQL> SELECT CHECKPOINT(100);

LINEID     CHECKPOINT(100)
---------- ---------------
1          0

used time: 00:00:13.441. Execute id is 269304.
SQL>
!!!check data!!!


Server[10.10.180.236:8265]:mode is primary, state is open
login used time : 2.444(ms)
disql V8
SQL> SQL> SQL> select table_used_space('BENCHMARKSQL','BMSQL_CUSTOMER')*(page()/1024)/1024  a union all
select table_used_space('BENCHMARKSQL','BMSQL_DISTRICT')*(page()/1024)/1024 a union all
select table_used_space('BENCHMARKSQL','BMSQL_HISTORY')*(page()/1024)/1024 a union all
select table_used_space('BENCHMARKSQL','BMSQL_ITEM')*(page()/1024)/1024 a union all
select table_used_space('BENCHMARKSQL','BMSQL_NEW_ORDER')*(page()/1024)/1024 a union all
select table_used_space('BENCHMARKSQL','BMSQL_OORDER')*(page()/1024)/1024 a union all
select table_used_space('BENCHMARKSQL','BMSQL_ORDER_LINE')*(page()/1024)/1024 a union all
select table_used_space('BENCHMARKSQL','BMSQL_STOCK')*(page()/1024)/1024 a union all
select table_used_space('BENCHMARKSQL','BMSQL_WAREHOUSE')*(page()/1024)/1024 a;

LINEID     A
---------- --------------------
1          769
2          0
3          47
4          10
5          12
6          78
7          1107
8          1453
9          0

9 rows got

used time: 1.228(ms). Execute id is 269400.
SQL> select sum(a) from (
select table_used_space('BENCHMARKSQL','BMSQL_CUSTOMER')*(page()/1024)/1024  a union all
select table_used_space('BENCHMARKSQL','BMSQL_DISTRICT')*(page()/1024)/1024 a union all
select table_used_space('BENCHMARKSQL','BMSQL_HISTORY')*(page()/1024)/1024 a union all
select table_used_space('BENCHMARKSQL','BMSQL_ITEM')*(page()/1024)/1024 a union all
select table_used_space('BENCHMARKSQL','BMSQL_NEW_ORDER')*(page()/1024)/1024 a union all
select table_used_space('BENCHMARKSQL','BMSQL_OORDER')*(page()/1024)/1024 a union all
select table_used_space('BENCHMARKSQL','BMSQL_ORDER_LINE')*(page()/1024)/1024 a union all
select table_used_space('BENCHMARKSQL','BMSQL_STOCK')*(page()/1024)/1024 a union all
select table_used_space('BENCHMARKSQL','BMSQL_WAREHOUSE')*(page()/1024)/1024 a
) b;

LINEID     SUM(A)
---------- --------------------
1          3476

used time: 0.340(ms). Execute id is 269401.
SQL> SQL> SP_SET_TAB_FAST_POOL_FLAG('BENCHMARKSQL', 'BMSQL_ITEM', 1);
DMSQL executed successfully
used time: 1.891(ms). Execute id is 269402.
SQL> SP_SET_TAB_FAST_POOL_FLAG('BENCHMARKSQL', 'BMSQL_WAREHOUSE', 1);
DMSQL executed successfully
used time: 2.162(ms). Execute id is 269403.
SQL> SP_SET_TAB_FAST_POOL_FLAG('BENCHMARKSQL', 'BMSQL_DISTRICT', 1);
DMSQL executed successfully
used time: 1.295(ms). Execute id is 269404.
SQL>
!!!load data used:121s

压测

User: ./tpcc_test.sh dameng-753de107
—BEGIN—
!!!tpcc start: 2025-02-14 18:41:39

!!!check data!!!

Server[10.10.180.236:8265]:mode is primary, state is open
login used time : 3.037(ms)
disql V8
SQL> SQL> SQL> select table_used_space(‘BENCHMARKSQL’,‘BMSQL_CUSTOMER’)(page()/1024)/1024 a union all
select table_used_space(‘BENCHMARKSQL’,‘BMSQL_DISTRICT’)(page()/1024)/1024 a union all
select table_used_space(‘BENCHMARKSQL’,‘BMSQL_HISTORY’)(page()/1024)/1024 a union all
select table_used_space(‘BENCHMARKSQL’,‘BMSQL_ITEM’)(page()/1024)/1024 a union all
select table_used_space(‘BENCHMARKSQL’,‘BMSQL_NEW_ORDER’)(page()/1024)/1024 a union all
select table_used_space(‘BENCHMARKSQL’,‘BMSQL_OORDER’)(page()/1024)/1024 a union all
select table_used_space(‘BENCHMARKSQL’,‘BMSQL_ORDER_LINE’)(page()/1024)/1024 a union all
select table_used_space(‘BENCHMARKSQL’,‘BMSQL_STOCK’)(page()/1024)/1024 a union all
select table_used_space(‘BENCHMARKSQL’,‘BMSQL_WAREHOUSE’)*(page()/1024)/1024 a;

LINEID A

1 769
2 0
3 47
4 10
5 12
6 78
7 1107
8 1453
9 0

9 rows got

used time: 0.864(ms). Execute id is 273100.
SQL> select sum(a) from (
select table_used_space(‘BENCHMARKSQL’,‘BMSQL_CUSTOMER’)(page()/1024)/1024 a union all
select table_used_space(‘BENCHMARKSQL’,‘BMSQL_DISTRICT’)(page()/1024)/1024 a union all
select table_used_space(‘BENCHMARKSQL’,‘BMSQL_HISTORY’)(page()/1024)/1024 a union all
select table_used_space(‘BENCHMARKSQL’,‘BMSQL_ITEM’)(page()/1024)/1024 a union all
select table_used_space(‘BENCHMARKSQL’,‘BMSQL_NEW_ORDER’)(page()/1024)/1024 a union all
select table_used_space(‘BENCHMARKSQL’,‘BMSQL_OORDER’)(page()/1024)/1024 a union all
select table_used_space(‘BENCHMARKSQL’,‘BMSQL_ORDER_LINE’)(page()/1024)/1024 a union all
select table_used_space(‘BENCHMARKSQL’,‘BMSQL_STOCK’)(page()/1024)/1024 a union all
select table_used_space(‘BENCHMARKSQL’,‘BMSQL_WAREHOUSE’)*(page()/1024)/1024 a
) b;

LINEID SUM(A)

1 3476

used time: 0.353(ms). Execute id is 273101.
SQL> SQL> SP_SET_TAB_FAST_POOL_FLAG(‘BENCHMARKSQL’, ‘BMSQL_ITEM’, 1);
DMSQL executed successfully
used time: 1.851(ms). Execute id is 273102.
SQL> SP_SET_TAB_FAST_POOL_FLAG(‘BENCHMARKSQL’, ‘BMSQL_WAREHOUSE’, 1);
DMSQL executed successfully
used time: 1.556(ms). Execute id is 273103.
SQL> SP_SET_TAB_FAST_POOL_FLAG(‘BENCHMARKSQL’, ‘BMSQL_DISTRICT’, 1);
DMSQL executed successfully
used time: 1.494(ms). Execute id is 273104.
SQL>
!!!check INI info!!!

Server[10.10.180.236:8265]:mode is primary, state is open
login used time : 2.702(ms)
disql V8
SQL> SQL> no context in file
SQL>
!!!run the benchmark!!!

18:41:40,274 [main] INFO jTPCC : Term-00,
18:41:40,278 [main] INFO jTPCC : Term-00, ±------------------------------------------------------------+
18:41:40,279 [main] INFO jTPCC : Term-00, BenchmarkSQL v5.0
18:41:40,279 [main] INFO jTPCC : Term-00, ±------------------------------------------------------------+
18:41:40,279 [main] INFO jTPCC : Term-00, © 2003, Raul Barbosa
18:41:40,280 [main] INFO jTPCC : Term-00, © 2004-2016, Denis Lussier
18:41:40,283 [main] INFO jTPCC : Term-00, © 2016, Jan Wieck
18:41:40,283 [main] INFO jTPCC : Term-00, ±------------------------------------------------------------+
18:41:40,283 [main] INFO jTPCC : Term-00,
18:41:40,284 [main] INFO jTPCC : Term-00, db=dameng
18:41:40,284 [main] INFO jTPCC : Term-00, driver=dm.jdbc.driver.DmDriver
18:41:40,284 [main] INFO jTPCC : Term-00, conn=jdbc:dm://10.10.180.236:8265
18:41:40,284 [main] INFO jTPCC : Term-00, user=BENCHMARKSQL
18:41:40,284 [main] INFO jTPCC : Term-00,
18:41:40,285 [main] INFO jTPCC : Term-00, warehouses=20
18:41:40,285 [main] INFO jTPCC : Term-00, terminals=100
18:41:40,288 [main] INFO jTPCC : Term-00, runMins=5
18:41:40,288 [main] INFO jTPCC : Term-00, limitTxnsPerMin=0
18:41:40,288 [main] INFO jTPCC : Term-00, terminalWarehouseFixed=true
18:41:40,288 [main] INFO jTPCC : Term-00,
18:41:40,289 [main] INFO jTPCC : Term-00, newOrderWeight=45
18:41:40,289 [main] INFO jTPCC : Term-00, paymentWeight=43
18:41:40,289 [main] INFO jTPCC : Term-00, orderStatusWeight=4
18:41:40,289 [main] INFO jTPCC : Term-00, deliveryWeight=4
18:41:40,289 [main] INFO jTPCC : Term-00, stockLevelWeight=4
18:41:40,290 [main] INFO jTPCC : Term-00,
18:41:40,290 [main] INFO jTPCC : Term-00, resultDirectory=dameng_result_%tY-%tm-%td_%tH%tM%tS
18:41:40,290 [main] INFO jTPCC : Term-00, osCollectorScript=./misc/os_collector_linux.py
18:41:40,290 [main] INFO jTPCC : Term-00,
18:41:40,318 [main] INFO jTPCC : Term-00, copied props.dm to dameng_result_2025-02-14_184140/run.properties
18:41:40,319 [main] INFO jTPCC : Term-00, created dameng_result_2025-02-14_184140/data/runInfo.csv for runID 86
18:41:40,319 [main] INFO jTPCC : Term-00, writing per transaction results to dameng_result_2025-02-14_184140/data/result.csv
18:41:40,320 [main] INFO jTPCC : Term-00, osCollectorScript=./misc/os_collector_linux.py
18:41:40,321 [main] INFO jTPCC : Term-00, osCollectorInterval=1
18:41:40,321 [main] INFO jTPCC : Term-00, osCollectorSSHAddr=null
18:41:40,321 [main] INFO jTPCC : Term-00, osCollectorDevices=null
18:41:40,461 [main] INFO jTPCC : Term-00,
18:41:40,737 [main] INFO jTPCC : Term-00, C value for C_LAST during load: 245
18:41:40,737 [main] INFO jTPCC : Term-00, C value for C_LAST this run: 159 Term-00, Running Average tpmTOTAL: 53673.85 Current tpmTOTAL: 1780800 Memory Usage: 125MB / 1996MB 18:46:42,518 [Thread-51] INFO jTPCC : Term-00, 18:46:42,520 [Thread-51] INFO jTPCC : Term-00,
18:46:42,520 [Thread-51] INFO jTPCC : Term-00, Measured tpmC (NewOrders) = 24065.75
18:46:42,520 [Thread-51] INFO jTPCC : Term-00, Measured tpmTOTAL = 53656.05
18:46:42,520 [Thread-51] INFO jTPCC : Term-00, Session Start = 2025-02-14 18:41:42
18:46:42,520 [Thread-51] INFO jTPCC : Term-00, Session End = 2025-02-14 18:46:42
18:46:42,520 [Thread-51] INFO jTPCC : Term-00, Transaction Count = 268476

!!!After test,check rlog info!!!

Server[10.10.180.236:8265]:mode is primary, state is open
login used time : 2.657(ms)
disql V8
SQL> SQL> SQL> SELECT * FROM V$RLOG;

LINEID CKPT_LSN FILE_LSN FLUSH_LSN CUR_LSN

       NEXT_SEQ             N_MAGIC     DB_MAGIC             FLUSH_PAGES FLUSHING_PAGES
       -------------------- ----------- -------------------- ----------- --------------
       CUR_FILE    CUR_OFFSET           CKPT_FILE   CKPT_OFFSET          FREE_SPACE
       ----------- -------------------- ----------- -------------------- --------------------
       TOTAL_SPACE          SUSPEND_TIME UPD_CTL_LSN          N_RESERVE_WAIT
       -------------------- ------------ -------------------- --------------
       TOTAL_FLUSH_PAGES    TOTAL_FLUSH_TIMES    TOTAL_ECPR_FLUSH_PAGES GLOBAL_NEXT_SEQ
       -------------------- -------------------- ---------------------- --------------------
       N_PRIMAY_EP PRIMARY_DB_MAGIC     CKPT_N_PRIMAY_EP CKPT_PRIMARY_DB_MAGIC MIN_EXEC_VER
       ----------- -------------------- ---------------- --------------------- ------------
       MIN_DCT_VER CLSN_OPEN_ID DB_OPEN_ID
       ----------- ------------ -----------

1 18168067 18841457 18841457 18842485
37234 7 1143922250 0 0
0 190308352 0 61403136 407957504
536862720 NULL 51548 0
14113840 257683 0 37234
0 0 0 0 V8.1.1.1
4 2 2

used time: 1.421(ms). Execute id is 5232900.
SQL> SELECT * FROM V$CKPT;

LINEID CKPT_RLOG_SIZE CKPT_DIRTY_PAGES CKPT_INTERVAL CKPT_FLUSH_RATE CKPT_FLUSH_PAGES

       LAST_BEGIN_TIME            LAST_END_TIME              CKPT_LSN
       -------------------------- -------------------------- --------------------
       CKPT_FILE            CKPT_OFFSET          STATE CKPT_TOTAL_COUNT
       -------------------- -------------------- ----- --------------------
       CKPT_RESERVE_COUNT   CKPT_FLUSHED_PAGES   CKPT_TIME_USED
       -------------------- -------------------- --------------------

1 128 0 180 5.00 1000
2025-02-14 18:46:41.000000 2025-02-14 18:46:41.000000 18168067
0 61403136 NONE 352
0 2271499 289773

used time: 0.456(ms). Execute id is 5232901.
SQL> SQL> select table_used_space(‘BENCHMARKSQL’,‘BMSQL_CUSTOMER’)(page()/1024)/1024 a union all
select table_used_space(‘BENCHMARKSQL’,‘BMSQL_DISTRICT’)(page()/1024)/1024 a union all
select table_used_space(‘BENCHMARKSQL’,‘BMSQL_HISTORY’)(page()/1024)/1024 a union all
select table_used_space(‘BENCHMARKSQL’,‘BMSQL_ITEM’)(page()/1024)/1024 a union all
select table_used_space(‘BENCHMARKSQL’,‘BMSQL_NEW_ORDER’)(page()/1024)/1024 a union all
select table_used_space(‘BENCHMARKSQL’,‘BMSQL_OORDER’)(page()/1024)/1024 a union all
select table_used_space(‘BENCHMARKSQL’,‘BMSQL_ORDER_LINE’)(page()/1024)/1024 a union all
select table_used_space(‘BENCHMARKSQL’,‘BMSQL_STOCK’)(page()/1024)/1024 a union all
select table_used_space(‘BENCHMARKSQL’,‘BMSQL_WAREHOUSE’)*(page()/1024)/1024 a;

LINEID A

1 769
2 0
3 56
4 10
5 15
6 94
7 1343
8 1453
9 0

9 rows got

used time: 0.434(ms). Execute id is 5232902.
SQL> select sum(a) from (
select table_used_space(‘BENCHMARKSQL’,‘BMSQL_CUSTOMER’)(page()/1024)/1024 a union all
select table_used_space(‘BENCHMARKSQL’,‘BMSQL_DISTRICT’)(page()/1024)/1024 a union all
select table_used_space(‘BENCHMARKSQL’,‘BMSQL_HISTORY’)(page()/1024)/1024 a union all
select table_used_space(‘BENCHMARKSQL’,‘BMSQL_ITEM’)(page()/1024)/1024 a union all
select table_used_space(‘BENCHMARKSQL’,‘BMSQL_NEW_ORDER’)(page()/1024)/1024 a union all
select table_used_space(‘BENCHMARKSQL’,‘BMSQL_OORDER’)(page()/1024)/1024 a union all
select table_used_space(‘BENCHMARKSQL’,‘BMSQL_ORDER_LINE’)(page()/1024)/1024 a union all
select table_used_space(‘BENCHMARKSQL’,‘BMSQL_STOCK’)(page()/1024)/1024 a union all
select table_used_space(‘BENCHMARKSQL’,‘BMSQL_WAREHOUSE’)*(page()/1024)/1024 a
) b;

LINEID SUM(A)

1 3740

used time: 0.388(ms). Execute id is 5232903.
SQL>
!!!test tpcc used:304s

分析其中的步骤
Kimi: 以下是对 tpcc_test.sh 脚本执行过程的详细分析，包含每个步骤的含义和目的：

1. 脚本启动

./tpcc_test.sh dameng-753de107

说明：
- tpcc_test.sh 是一个用于运行 TPC-C 测试的脚本。
- 参数 dameng-753de107 是测试的标识符，可能用于区分不同的测试实例。
目的：
- 启动 TPC-C 测试流程，包括数据库检查、性能测试和结果记录。

2. 检查数据表空间

select table_used_space('BENCHMARKSQL','BMSQL_CUSTOMER')*(page()/1024)/1024  a union all
select table_used_space('BENCHMARKSQL','BMSQL_DISTRICT')*(page()/1024)/1024 a union all
...
select table_used_space('BENCHMARKSQL','BMSQL_WAREHOUSE')*(page()/1024)/1024 a;

说明：
- table_used_space 是一个函数，用于计算指定表的已使用空间。
- page() 是一个函数，返回数据库的页大小。
- 查询计算了 BENCHMARKSQL 模式下多个表的已使用空间（以 MB 为单位）。
目的：
- 检查数据库中各表的存储空间使用情况，为后续性能测试提供基础数据。

结果：

每个表的已使用空间（MB）：

BMSQL_CUSTOMER: 769 MB
BMSQL_DISTRICT: 0 MB
BMSQL_HISTORY: 47 MB
BMSQL_ITEM: 10 MB
BMSQL_NEW_ORDER: 12 MB
BMSQL_OORDER: 78 MB
BMSQL_ORDER_LINE: 1107 MB
BMSQL_STOCK: 1453 MB
BMSQL_WAREHOUSE: 0 MB

总空间使用：3476 MB

3. 设置表的快速池标志

SP_SET_TAB_FAST_POOL_FLAG('BENCHMARKSQL', 'BMSQL_ITEM', 1);

说明：
- SP_SET_TAB_FAST_POOL_FLAG 是一个存储过程，用于设置表的快速池标志。
- 参数：
  - 'BENCHMARKSQL'：数据库模式名称。
  - 'BMSQL_ITEM'：表名称。
  - 1：启用快速池。
目的：
- 将指定表设置为快速池表，以提高数据访问性能。
执行结果：
- 操作成功，无错误返回。

4. 检查 INI 配置信息

SELECT * FROM V$RLOG;
SELECT * FROM V$CKPT;

说明：
- V$RLOG：动态视图，显示数据库日志信息。
- V$CKPT：动态视图，显示数据库检查点信息。
目的：
- 检查数据库日志和检查点的状态，确保数据库运行正常。
结果：
- 日志信息（V$RLOG）：
  - 当前日志文件大小、日志序列号、刷新状态等。
- 检查点信息（V$CKPT）：
  - 检查点间隔、脏页数、检查点状态等。

5. 运行 TPC-C 基准测试

18:41:40,274 [main] INFO   jTPCC : Term-00,      BenchmarkSQL v5.0
...
18:41:40,288 [main] INFO   jTPCC : Term-00, warehouses=20
18:41:40,288 [main] INFO   jTPCC : Term-00, terminals=100
18:41:40,288 [main] INFO   jTPCC : Term-00, runMins=5
...

说明：
- jTPCC 是一个 Java 实现的 TPC-C 测试工具。
- 日志显示了测试的配置和运行状态。
关键配置：
- 数据库：dameng
- 驱动：dm.jdbc.driver.DmDriver
- 连接地址：jdbc:dm://x.x.180.236:8265
- 测试参数：
  - 仓库数量：20
  - 终端数量：100
  - 运行时间：5 分钟
测试结果：
- 测试运行了 5 分钟，处理了 268476 笔事务。
- 性能指标：
  - tpmC（每分钟处理的新订单数）：24065.75
  - tpmTOTAL（总事务处理能力）：53656.05

6. 测试后检查日志和表空间

SELECT * FROM V$RLOG;
SELECT * FROM V$CKPT;

说明：
- 再次检查日志和检查点信息，确保测试过程中没有异常。
表空间检查：
- 再次计算各表的已使用空间，确认测试过程中数据的变化。
- 总空间使用：3740 MB（比测试前增加了 264 MB）。

7. 测试完成

!!!test tpcc used:304s

说明：
- 测试总耗时：304 秒（约 5 分钟）。
目的：
- 总结测试的执行时间，便于后续分析和优化。

总结

测试流程：
- 检查数据库表空间。
- 设置表的快速池标志。
- 检查数据库日志和检查点信息。
- 运行 TPC-C 基准测试。
- 测试后再次检查日志和表空间。
- 输出测试总耗时。
测试结果：
- 数据库表空间使用情况：
  - 测试前：3476 MB
  - 测试后：3740 MB
- 性能指标：
  - tpmC：24065.75
  - tpmTOTAL：53656.05
- 测试耗时：304 秒。
优化建议：
- 如果性能指标未达到预期，可以尝试以下优化：
  - 增加数据库内存分配。
  - 调整表的存储参数（如填充因子）。
  - 优化 SQL 执行计划。
  - 增加数据库的并行度。

如果有其他问题或需要进一步分析，请随时告知！

在这里插入图片描述

./tpcc_test.sh dameng-753de107
---BEGIN---
!!!tpcc start: 2025-02-14 18:41:39

!!!check data!!!


Server[x.x.180.236:8265]:mode is primary, state is open
login used time : 3.037(ms)
disql V8
SQL> SQL> SQL> select table_used_space('BENCHMARKSQL','BMSQL_CUSTOMER')*(page()/1024)/1024  a union all
select table_used_space('BENCHMARKSQL','BMSQL_DISTRICT')*(page()/1024)/1024 a union all
select table_used_space('BENCHMARKSQL','BMSQL_HISTORY')*(page()/1024)/1024 a union all
select table_used_space('BENCHMARKSQL','BMSQL_ITEM')*(page()/1024)/1024 a union all
select table_used_space('BENCHMARKSQL','BMSQL_NEW_ORDER')*(page()/1024)/1024 a union all
select table_used_space('BENCHMARKSQL','BMSQL_OORDER')*(page()/1024)/1024 a union all
select table_used_space('BENCHMARKSQL','BMSQL_ORDER_LINE')*(page()/1024)/1024 a union all
select table_used_space('BENCHMARKSQL','BMSQL_STOCK')*(page()/1024)/1024 a union all
select table_used_space('BENCHMARKSQL','BMSQL_WAREHOUSE')*(page()/1024)/1024 a;

LINEID     A
---------- --------------------
1          769
2          0
3          47
4          10
5          12
6          78
7          1107
8          1453
9          0

9 rows got

used time: 0.864(ms). Execute id is 273100.
SQL> select sum(a) from (
select table_used_space('BENCHMARKSQL','BMSQL_CUSTOMER')*(page()/1024)/1024  a union all
select table_used_space('BENCHMARKSQL','BMSQL_DISTRICT')*(page()/1024)/1024 a union all
select table_used_space('BENCHMARKSQL','BMSQL_HISTORY')*(page()/1024)/1024 a union all
select table_used_space('BENCHMARKSQL','BMSQL_ITEM')*(page()/1024)/1024 a union all
select table_used_space('BENCHMARKSQL','BMSQL_NEW_ORDER')*(page()/1024)/1024 a union all
select table_used_space('BENCHMARKSQL','BMSQL_OORDER')*(page()/1024)/1024 a union all
select table_used_space('BENCHMARKSQL','BMSQL_ORDER_LINE')*(page()/1024)/1024 a union all
select table_used_space('BENCHMARKSQL','BMSQL_STOCK')*(page()/1024)/1024 a union all
select table_used_space('BENCHMARKSQL','BMSQL_WAREHOUSE')*(page()/1024)/1024 a
) b;

LINEID     SUM(A)
---------- --------------------
1          3476

used time: 0.353(ms). Execute id is 273101.
SQL> SQL> SP_SET_TAB_FAST_POOL_FLAG('BENCHMARKSQL', 'BMSQL_ITEM', 1);
DMSQL executed successfully
used time: 1.851(ms). Execute id is 273102.
SQL> SP_SET_TAB_FAST_POOL_FLAG('BENCHMARKSQL', 'BMSQL_WAREHOUSE', 1);
DMSQL executed successfully
used time: 1.556(ms). Execute id is 273103.
SQL> SP_SET_TAB_FAST_POOL_FLAG('BENCHMARKSQL', 'BMSQL_DISTRICT', 1);
DMSQL executed successfully
used time: 1.494(ms). Execute id is 273104.
SQL>
!!!check INI info!!!


Server[x.x.180.236:8265]:mode is primary, state is open
login used time : 2.702(ms)
disql V8
SQL> SQL> no context in file
SQL>
!!!run the benchmark!!!

18:41:40,274 [main] INFO   jTPCC : Term-00,
18:41:40,278 [main] INFO   jTPCC : Term-00, +-------------------------------------------------------------+
18:41:40,279 [main] INFO   jTPCC : Term-00,      BenchmarkSQL v5.0
18:41:40,279 [main] INFO   jTPCC : Term-00, +-------------------------------------------------------------+
18:41:40,279 [main] INFO   jTPCC : Term-00,  (c) 2003, Raul Barbosa
18:41:40,280 [main] INFO   jTPCC : Term-00,  (c) 2004-2016, Denis Lussier
18:41:40,283 [main] INFO   jTPCC : Term-00,  (c) 2016, Jan Wieck
18:41:40,283 [main] INFO   jTPCC : Term-00, +-------------------------------------------------------------+
18:41:40,283 [main] INFO   jTPCC : Term-00,
18:41:40,284 [main] INFO   jTPCC : Term-00, db=dameng
18:41:40,284 [main] INFO   jTPCC : Term-00, driver=dm.jdbc.driver.DmDriver
18:41:40,284 [main] INFO   jTPCC : Term-00, conn=jdbc:dm://x.x.180.236:8265
18:41:40,284 [main] INFO   jTPCC : Term-00, user=BENCHMARKSQL
18:41:40,284 [main] INFO   jTPCC : Term-00,
18:41:40,285 [main] INFO   jTPCC : Term-00, warehouses=20
18:41:40,285 [main] INFO   jTPCC : Term-00, terminals=100
18:41:40,288 [main] INFO   jTPCC : Term-00, runMins=5
18:41:40,288 [main] INFO   jTPCC : Term-00, limitTxnsPerMin=0
18:41:40,288 [main] INFO   jTPCC : Term-00, terminalWarehouseFixed=true
18:41:40,288 [main] INFO   jTPCC : Term-00,
18:41:40,289 [main] INFO   jTPCC : Term-00, newOrderWeight=45
18:41:40,289 [main] INFO   jTPCC : Term-00, paymentWeight=43
18:41:40,289 [main] INFO   jTPCC : Term-00, orderStatusWeight=4
18:41:40,289 [main] INFO   jTPCC : Term-00, deliveryWeight=4
18:41:40,289 [main] INFO   jTPCC : Term-00, stockLevelWeight=4
18:41:40,290 [main] INFO   jTPCC : Term-00,
18:41:40,290 [main] INFO   jTPCC : Term-00, resultDirectory=dameng_result_%tY-%tm-%td_%tH%tM%tS
18:41:40,290 [main] INFO   jTPCC : Term-00, osCollectorScript=./misc/os_collector_linux.py
18:41:40,290 [main] INFO   jTPCC : Term-00,
18:41:40,318 [main] INFO   jTPCC : Term-00, copied props.dm to dameng_result_2025-02-14_184140/run.properties
18:41:40,319 [main] INFO   jTPCC : Term-00, created dameng_result_2025-02-14_184140/data/runInfo.csv for runID 86
18:41:40,319 [main] INFO   jTPCC : Term-00, writing per transaction results to dameng_result_2025-02-14_184140/data/result.csv
18:41:40,320 [main] INFO   jTPCC : Term-00, osCollectorScript=./misc/os_collector_linux.py
18:41:40,321 [main] INFO   jTPCC : Term-00, osCollectorInterval=1
18:41:40,321 [main] INFO   jTPCC : Term-00, osCollectorSSHAddr=null
18:41:40,321 [main] INFO   jTPCC : Term-00, osCollectorDevices=null
18:41:40,461 [main] INFO   jTPCC : Term-00,
18:41:40,737 [main] INFO   jTPCC : Term-00, C value for C_LAST during load: 245
18:41:40,737 [main] INFO   jTPCC : Term-00, C value for C_LAST this run:    159          Term-00, Running Average tpmTOTAL: 53673.85    Current tpmTOTAL: 1780800    Memory Usage: 125MB / 1996MB  18:46:42,518 [Thread-51] INFO   jTPCC : Term-00,                                                                                                                                                   18:46:42,520 [Thread-51] INFO   jTPCC : Term-00,
18:46:42,520 [Thread-51] INFO   jTPCC : Term-00, Measured tpmC (NewOrders) = 24065.75
18:46:42,520 [Thread-51] INFO   jTPCC : Term-00, Measured tpmTOTAL = 53656.05
18:46:42,520 [Thread-51] INFO   jTPCC : Term-00, Session Start     = 2025-02-14 18:41:42
18:46:42,520 [Thread-51] INFO   jTPCC : Term-00, Session End       = 2025-02-14 18:46:42
18:46:42,520 [Thread-51] INFO   jTPCC : Term-00, Transaction Count = 268476

!!!After test,check rlog info!!!


Server[10.10.180.236:8265]:mode is primary, state is open
login used time : 2.657(ms)
disql V8
SQL> SQL> SQL> SELECT * FROM V$RLOG;

LINEID     CKPT_LSN             FILE_LSN             FLUSH_LSN            CUR_LSN
---------- -------------------- -------------------- -------------------- --------------------
           NEXT_SEQ             N_MAGIC     DB_MAGIC             FLUSH_PAGES FLUSHING_PAGES
           -------------------- ----------- -------------------- ----------- --------------
           CUR_FILE    CUR_OFFSET           CKPT_FILE   CKPT_OFFSET          FREE_SPACE
           ----------- -------------------- ----------- -------------------- --------------------
           TOTAL_SPACE          SUSPEND_TIME UPD_CTL_LSN          N_RESERVE_WAIT
           -------------------- ------------ -------------------- --------------
           TOTAL_FLUSH_PAGES    TOTAL_FLUSH_TIMES    TOTAL_ECPR_FLUSH_PAGES GLOBAL_NEXT_SEQ
           -------------------- -------------------- ---------------------- --------------------
           N_PRIMAY_EP PRIMARY_DB_MAGIC     CKPT_N_PRIMAY_EP CKPT_PRIMARY_DB_MAGIC MIN_EXEC_VER
           ----------- -------------------- ---------------- --------------------- ------------
           MIN_DCT_VER CLSN_OPEN_ID DB_OPEN_ID
           ----------- ------------ -----------
1          18168067             18841457             18841457             18842485
           37234                7           1143922250           0           0
           0           190308352            0           61403136             407957504
           536862720            NULL         51548                0
           14113840             257683               0                      37234
           0           0                    0                0                     V8.1.1.1
           4           2            2


used time: 1.421(ms). Execute id is 5232900.
SQL> SELECT * FROM V$CKPT;

LINEID     CKPT_RLOG_SIZE CKPT_DIRTY_PAGES CKPT_INTERVAL CKPT_FLUSH_RATE CKPT_FLUSH_PAGES
---------- -------------- ---------------- ------------- --------------- ----------------
           LAST_BEGIN_TIME            LAST_END_TIME              CKPT_LSN
           -------------------------- -------------------------- --------------------
           CKPT_FILE            CKPT_OFFSET          STATE CKPT_TOTAL_COUNT
           -------------------- -------------------- ----- --------------------
           CKPT_RESERVE_COUNT   CKPT_FLUSHED_PAGES   CKPT_TIME_USED
           -------------------- -------------------- --------------------
1          128            0                180           5.00            1000
           2025-02-14 18:46:41.000000 2025-02-14 18:46:41.000000 18168067
           0                    61403136             NONE  352
           0                    2271499              289773


used time: 0.456(ms). Execute id is 5232901.
SQL> SQL> select table_used_space('BENCHMARKSQL','BMSQL_CUSTOMER')*(page()/1024)/1024  a union all
select table_used_space('BENCHMARKSQL','BMSQL_DISTRICT')*(page()/1024)/1024 a union all
select table_used_space('BENCHMARKSQL','BMSQL_HISTORY')*(page()/1024)/1024 a union all
select table_used_space('BENCHMARKSQL','BMSQL_ITEM')*(page()/1024)/1024 a union all
select table_used_space('BENCHMARKSQL','BMSQL_NEW_ORDER')*(page()/1024)/1024 a union all
select table_used_space('BENCHMARKSQL','BMSQL_OORDER')*(page()/1024)/1024 a union all
select table_used_space('BENCHMARKSQL','BMSQL_ORDER_LINE')*(page()/1024)/1024 a union all
select table_used_space('BENCHMARKSQL','BMSQL_STOCK')*(page()/1024)/1024 a union all
select table_used_space('BENCHMARKSQL','BMSQL_WAREHOUSE')*(page()/1024)/1024 a;

LINEID     A
---------- --------------------
1          769
2          0
3          56
4          10
5          15
6          94
7          1343
8          1453
9          0

9 rows got

used time: 0.434(ms). Execute id is 5232902.
SQL> select sum(a) from (
select table_used_space('BENCHMARKSQL','BMSQL_CUSTOMER')*(page()/1024)/1024  a union all
select table_used_space('BENCHMARKSQL','BMSQL_DISTRICT')*(page()/1024)/1024 a union all
select table_used_space('BENCHMARKSQL','BMSQL_HISTORY')*(page()/1024)/1024 a union all
select table_used_space('BENCHMARKSQL','BMSQL_ITEM')*(page()/1024)/1024 a union all
select table_used_space('BENCHMARKSQL','BMSQL_NEW_ORDER')*(page()/1024)/1024 a union all
select table_used_space('BENCHMARKSQL','BMSQL_OORDER')*(page()/1024)/1024 a union all
select table_used_space('BENCHMARKSQL','BMSQL_ORDER_LINE')*(page()/1024)/1024 a union all
select table_used_space('BENCHMARKSQL','BMSQL_STOCK')*(page()/1024)/1024 a union all
select table_used_space('BENCHMARKSQL','BMSQL_WAREHOUSE')*(page()/1024)/1024 a
) b;

LINEID     SUM(A)
---------- --------------------
1          3740

used time: 0.388(ms). Execute id is 5232903.
SQL>
!!!test tpcc used:304s