达梦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 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

压测

在这里插入图片描述

./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,  (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             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

本文来自互联网用户投稿，该文观点仅代表作者本人，不代表本站立场。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如若转载，请注明出处：/a/969454.html

如若内容造成侵权/违法违规/事实不符，请联系我们进行投诉反馈qq邮箱809451989@qq.com，一经查实，立即删除！

相关文章

MySQL技术公开课：Mysql-Server-8.4.4 Innodb 集群搭建与维护

MySQL技术公开课：Mysql-Server-8.4.4 Innodb 集群搭建与维护

MySQL技术公开课 - Mysql-Server-8.4.4 Innodb 集群搭建与维护 讲课内容： 1、Innodb集群框架介绍 2、Innodb集群部署(mysql-Server、mysql-shell、mysql-router安装配置) 3、Innodb集群维护(主备切换、启动与关闭、故障排除) Mysql-server商业版目前最新的是8.…
阅读更多...
TCP/IP参考模型和网络协议

TCP/IP参考模型和网络协议

由于国防部担心他们一些重要的主机、路由器和互联网关可能会突然崩溃，所以网络必须实现的另一目标是网络不受子网硬件损失的影响，已经建立的会话不会被取消，而且整个体系结构必须相当灵活。 TCP/IP是一组用于实现网络互连的通信协议。Interne…
阅读更多...
机器学习-02-机器学习算法思想以及在各行各业的应用

机器学习-02-机器学习算法思想以及在各行各业的应用

总结 本系列是机器学习课程的第02篇，主要介绍机器学习算法思想以及在各行各业的应用 本门课程的目标 完成一个特定行业的算法应用全过程： 定义问题（Problem Definition） -> 数据收集(Data Collection) -> 数据分割(Data…
阅读更多...
无须高配电脑-ChatboxAI 利用SiliconCloud 接入在线deepseek

无须高配电脑-ChatboxAI 利用SiliconCloud 接入在线deepseek

Deepseek官方api调用 方式收费，官网提供的在线推理又经常出现”服务器繁忙，请稍后再试“的问题。本文借助本地聊会客户端 ChatboxAI， 通过SiliconCloud 平台来接入各种在线大模型，包括Deepseek. ChatboxAI(完全免费) Chatbox AI…
阅读更多...
RocketMQ及和Kafka的区别

RocketMQ及和Kafka的区别

目录 1 从场景入手2 RocketMQ是什么？3 RocketMQ及和Kafka的区别3.1 在架构上做了减法3.1.1 简化协调节点3.1.2 简化分区3.1.3 底层存储3.1.3.1 Kafka底层存储3.1.3.1 RocketMQ底层存储 3.1.4 简化备份模型3.1.4.1 Kafka备份模型3.1.4.2 RocketMQ备份模型 3.1.5 Rock…
阅读更多...
一文深入了解DeepSeek-R1：模型架构

一文深入了解DeepSeek-R1：模型架构

本文深入探讨了 DeepSeek-R1 模型架构。让我们从输入到输出追踪 DeepSeek-R1 模型，以找到架构中的新发展和关键部分。DeepSeek-R1 基于 DeepSeek-V3-Base 模型架构。本文旨在涵盖其设计的所有重要方面。 📝 1. 输入上下文长度 DeepSeek-R1的输入上下文长…
阅读更多...
在 PyCharm 中接入deepseek的API的各种方法

在 PyCharm 中接入deepseek的API的各种方法

在 PyCharm 中接入 DeepSeek 的 API，通常需要以下步骤： 1. 获取 DeepSeek API 密钥 首先，确保你已经在 DeepSeek 平台上注册并获取了 API 密钥（API Key）。如果没有，请访问 DeepSeek 的官方网站注册并申请 …
阅读更多...
java每日精进 2.13 Ganache（区块链本地私有化部署）

java每日精进 2.13 Ganache（区块链本地私有化部署）

需求：使用区块链实现数据村存储，记录一些不可篡改的交互信息，网络环境为内外网均需要部署； 1.准备工作（软件安装） 1.1 安装 Node.js 和 npm 1.2 安装 Ganache 地址如下：windows有可视化界面 &a…
阅读更多...
【深度学习】多目标融合算法（四）：多门混合专家网络MMOE（Multi-gate Mixture-of-Experts）

【深度学习】多目标融合算法（四）：多门混合专家网络MMOE（Multi-gate Mixture-of-Experts）

目录 一、引言 二、MMoE（Multi-gate Mixture-of-Experts，多门混合专家网络） 2.1 技术原理 2.2 技术优缺点 2.3 业务代码实践 2.3.1 业务场景与建模 2.3.2 模型代码实现 2.3.3 模型训练与推理测试 2.3.4 打印模型结构 三、总结 一、…
阅读更多...
sqli-labs靶场实录(四): Challenges

sqli-labs靶场实录(四): Challenges

sqli-labs靶场实录: Challenges Less54确定字段数获取数据库名获取表名获取列名提取密钥值 Less55Less56Less57Less58爆库构造爆表构造爆列构造密钥提取构造 Less59Less60Less61Less62爆库构造 Less63Less64Less65免责声明： Less54 本关开始上难度了 可以看到此关仅…
阅读更多...
使用Redis实现分布式锁，基于原本单体系统进行业务改造

使用Redis实现分布式锁，基于原本单体系统进行业务改造

一、单体系统下&#xff0c;使用锁机制实现秒杀功能&#xff0c;并限制一人一单功能 1.流程图&#xff1a; 2.代码实现&#xff1a; Service public class VoucherOrderServiceImpl extends ServiceImpl<VoucherOrderMapper, VoucherOrder> implements IVoucherOrderSe…
阅读更多...
Python + WhisperX：解锁语音识别的高效新姿势

Python + WhisperX：解锁语音识别的高效新姿势

大家好&#xff0c;我是烤鸭&#xff1a; 最近在尝试做视频的质量分析&#xff0c;打算利用asr针对声音判断是否有人声&#xff0c;以及识别出来的文本进行进一步操作。asr看了几个开源的&#xff0c;最终选择了openai的whisper&#xff0c;后来发现性能不行&#xff0c;又换了…
阅读更多...
【Linux】Ubuntu Linux 系统——Node.js 开发环境

【Linux】Ubuntu Linux 系统——Node.js 开发环境

ℹ️大家好&#xff0c;我是练小杰&#xff0c;今天星期五了&#xff0c;同时也是2025年的情人节&#xff0c;今晚又是一个人的举个爪子&#xff01;&#xff01; &#x1f642; 本文是有关Linux 操作系统中 Node.js 开发环境基础知识&#xff0c;后续我将添加更多相关知识噢&a…
阅读更多...
Oracle查看执行计划

Oracle查看执行计划

方式一&#xff08;查看的真实的使用到的索引&#xff09; 1.执行解释计划 2.查看结果 可以看到使用了RANGE SCAN范围扫描的索引 方式二&#xff08;查看的是预测的可能会用到的索引&#xff09; 1.执行解释计划sql explain plan for select * from COURSE where COURSE_…
阅读更多...
百度 AI开源！将在6月30日开源文心大模型4.5系列

百度 AI开源！将在6月30日开源文心大模型4.5系列

【大力财经】直击互联网最前线&#xff1a;百度近期动作频频&#xff0c;先是宣布将在未来数月陆续推出文心大模型4.5系列&#xff0c;并于6月30日正式开源。 据大力财经了解&#xff0c;自DeepSeek开源之风盛行全球后&#xff0c;开源闭源路径的选择就成为AI领域的热门话题&a…
阅读更多...
【DDD系列-2】风暴出的领域模型

【DDD系列-2】风暴出的领域模型

为什么使用DDD​ 三个问题​ 1.为什么我们的系统越做越多&#xff0c;越来越庞大&#xff0c;还需要不断的重构&#xff1f;​ 2.为什么我们的系统业务越来越复杂&#xff0c;服务层的代码越来越多难以维护&#xff0c;不敢维护&#xff1f;​ 3.为什么一旦业务变化或者数据…
阅读更多...
基于YALMIP和cplex工具箱的微电网最优调度算法matlab仿真

基于YALMIP和cplex工具箱的微电网最优调度算法matlab仿真

目录 1.课题概述 2.系统仿真结果 3.核心程序与模型 4.系统原理简介 4.1 系统建模 4.2 YALMIP工具箱 4.3 CPLEX工具箱 5.完整工程文件 1.课题概述 基于YALMIP和cplex工具箱的微电网最优调度算法matlab仿真。通过YALMIP和cplex这两个工具箱&#xff0c;完成微电网的最优调…
阅读更多...
visual studio导入cmake项目后打开无法删除和回车

visual studio导入cmake项目后打开无法删除和回车

通过Cmakelists.txt导入的项目做删除和回车无法响应&#xff0c;需要点击项目&#xff0c;然后选择配置项目就可以了
阅读更多...
npm安装时无法访问github域名的解决方法

npm安装时无法访问github域名的解决方法

个人博客地址&#xff1a;npm安装时无法访问github域名的解决方法 | 一张假钞的真实世界 今天在用npm install的时候出现了github项目访问不了的异常&#xff1a; npm ERR! Error while executing: npm ERR! /bin/git ls-remote -h -t https://github.com/nhn/raphael.git np…
阅读更多...
解锁豆瓣高清海报(三)从深度爬虫到URL构造，实现极速下载

解锁豆瓣高清海报(三)从深度爬虫到URL构造，实现极速下载

脚本地址: 项目地址: Gazer PosterBandit_v2.py 前瞻 之前的 PosterBandit.py 是按照深度爬虫的思路一步步进入海报界面来爬取, 是个值得学习的思路, 但缺点是它爬取慢, 仍然容易碰到豆瓣的 418 错误, 本文也会指出彻底解决旧版 418 错误的方法并提高爬取速度. 现在我将介绍…
阅读更多...
最新文章

Copyright @ 2022~2023