欢迎来到尧图网

客户服务 关于我们

您的位置：首页 > 教育 > 高考 > 达梦tpcc压测

达梦tpcc压测

2025/2/24 9:03:33 来源：https://blog.csdn.net/hezuijiudexiaobai/article/details/145639844  浏览:  次   关键词：达梦tpcc压测

造数

在这个日志输出中，主要执行了一系列数据库操作，涵盖了数据库信息检查、表的创建与数据加载、索引的添加、数据验证等步骤。具体分析如下：

  1. 数据库信息检查：

    • 查询了数据库的版本、实例名称、日志文件大小、字符集等信息。

  2. 删除旧用户和表空间：

    • 删除了名为 BENCHMARKSQL 的用户和多个与该用户相关的表空间（如 BENCHMARKSQL1 到 BENCHMARKSQL10），为重新创建数据表和导入数据做好准备。

  3. 创建新的表空间：

    • 创建了新的表空间（BENCHMARKSQL1 到 BENCHMARKSQL10），并且为每个表空间设置了数据文件，启用了自动扩展。

  4. 创建用户和表：

    • 创建了 BENCHMARKSQL 用户，并为其赋予了 DBA 权限。
    • 为该用户创建了多个表，如 bmsql_config、bmsql_warehouse、bmsql_district 等。这些表是 TPC-C 基准测试的核心数据表。

  5. 数据加载：

    • 使用多线程（10个工作线程）进行数据加载，分批次地将数据加载到不同的表中（例如 ITEM、WAREHOUSE、ORDER 等）。
    • 这一步骤显示了加载的进度，并标记了每个表的数据加载完成情况。

  6. 创建索引：

    • 为 BENCHMARKSQL.bmsql_customer 表创建了索引（ndx_customer_name），以优化查询性能。

  7. 创建存储过程和序列：

    • 创建了一个存储过程 createsequence，用于生成 BMSQL_HISTORY 表的序列。
    • 修改了 BMSQL_HISTORY 表的 hist_id 字段，使其默认值使用刚创建的序列。

  8. 检查数据空间使用情况：

    • 使用 table_used_space 函数查看了不同表的空间使用情况。
    • 汇总了所有表的空间使用情况，并显示总和为 3476 MB。

  9. 启用表的快速访问池：

    • 为 BMSQL_ITEM、BMSQL_WAREHOUSE、BMSQL_DISTRICT 等表启用了快速访问池标志，这有助于加速查询操作。

最终，数据加载总共花费了 121秒，表示数据导入过程完成。

这些操作主要是为了准备好进行基准测试（TPC-C），并且对数据库进行了优化配置，包括索引创建、序列管理、快速访问池设置等，以确保测试的性能和稳定性。
在这里插入图片描述

./tpcc_load.sh dameng-753de107
---BEGIN---
!!!tpcc start: 2025-02-14 18:36:05
!!!check db infoServer[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 Pack2used 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 V83          RLOG_SIZE        DAMENG01.log:256MB,DAMENG02.log:256MB
4          CHARECTOR        GBK18030
5          PAGE_SIZE        4
6          EXTENT_SIZE      16
7          CASE             1
8          DATABASE         PRIMARY8 rows gotused 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:05Starting BenchmarkSQL LoadDatadriver=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     10Worker 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          0used 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          09 rows gotused 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          3476used 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

压测

在这里插入图片描述

./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          09 rows gotused 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          3476used 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,  (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://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             1884248537234                7           1143922250           0           00           190308352            0           61403136             407957504536862720            NULL         51548                014113840             257683               0                      372340           0                    0                0                     V8.1.1.14           2            2used 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            10002025-02-14 18:46:41.000000 2025-02-14 18:46:41.000000 181680670                    61403136             NONE  3520                    2271499              289773used 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          09 rows gotused 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          3740used time: 0.388(ms). Execute id is 5232903.
SQL>
!!!test tpcc used:304s

版权声明:

本网仅为发布的内容提供存储空间，不对发表、转载的内容提供任何形式的保证。凡本网注明“来源：XXX网络”的作品，均转载自其它媒体，著作权归作者所有，商业转载请联系作者获得授权，非商业转载请注明出处。

我们尊重并感谢每一位作者，均已注明文章来源和作者。如因作品内容、版权或其它问题，请及时与我们联系，联系邮箱：809451989@qq.com，投稿邮箱：809451989@qq.com

相关资讯

热文排行

最新新闻

推荐新闻

热搜词