【openGauss-benchmarksql5.1性能测试】

已于 2023-12-26 19:57:38 修改
阅读量598 收藏 9
点赞数 8
分类专栏： 数据库 文章标签： gaussdb 数据库
于 2023-12-26 09:24:12 首次发布
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/lyhadong/article/details/135213681
版权

openGauss-benchmarksql5.1性能测试

【benchmarksql5.1版本已支持MySQL、openGauss数据库】

1.下载benchmarksql5.1

BenchmarkSQL5.1

[root@localhost ~]# git clone https://gitee.com/MapLover/benchmarksql5.1.git
Cloning into 'benchmarksql5.1'...
remote: Enumerating objects: 283, done.
remote: Counting objects: 100% (35/35), done.
remote: Compressing objects: 100% (33/33), done.
remote: Total 283 (delta 7), reused 0 (delta 0), pack-reused 248
Receiving objects: 100% (283/283), 9.41 MiB | 4.44 MiB/s, done.
Resolving deltas: 100% (127/127), done.
[root@localhost ~]#

2.benchmarksql5.1目录说明

其中opengauss数据库有两种驱动

  1. driver=org.postgresql.Driver 对应 jar包为 postgresql.jar
  2. driver=org.opengauss.Driver对应 jar包为 opengauss-jdbc-5.0.0.jar
[root@localhost ~]# tree -d -L 3 benchmarksql5.1/
benchmarksql5.1/
├── dist ##BenchmarkSQL-5.1.jar 所在目录
├── doc
│   └── src
├── lib ## 不同数据库的jdbc驱动jar包
│   ├── firebird
│   ├── mysql
│   ├── openGauss
│   ├── oracle
│   └── postgres
├── run # 运行shell脚本和 不同数据库的建表sql
│   ├── misc
│   ├── sql.common
│   ├── sql.firebird
│   ├── sql.mysql
│   ├── sql.oracle
│   └── sql.postgres
└── src  ##JAVA 源码
    ├── client
    ├── jdbc
    ├── LoadData
    └── OSCollector

3.造数

[root@localhost run]# ./runDatabaseBuild.sh props.gs 
# ------------------------------------------------------------
# Loading SQL file ./sql.common/tableCreates.sql
# ------------------------------------------------------------
Dec 26, 2023 8:57:27 AM org.opengauss.core.v3.ConnectionFactoryImpl openConnectionImpl
INFO: [8c80e172-db2e-4e1e-a0b2-1e084368dc60] Try to connect. IP: 127.0.0.1:7654
Dec 26, 2023 8:57:27 AM org.opengauss.core.v3.ConnectionFactoryImpl openConnectionImpl
INFO: [127.0.0.1:40706/127.0.0.1:7654] Connection is established. ID: 8c80e172-db2e-4e1e-a0b2-1e084368dc60
Dec 26, 2023 8:57:27 AM org.opengauss.core.v3.ConnectionFactoryImpl openConnectionImpl
INFO: Connect complete. ID: 8c80e172-db2e-4e1e-a0b2-1e084368dc60
create table bmsql_config (
cfg_name    varchar(30) primary key,
cfg_value   varchar(50)
);
create table bmsql_warehouse (
w_id        integer   not null,
w_ytd       decimal(12,2),
w_tax       decimal(4,4),
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)
);
create table bmsql_district (
d_w_id       integer       not null,
d_id         integer       not null,
d_ytd        decimal(12,2),
d_tax        decimal(4,4),
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)
);
create table bmsql_customer (
c_w_id         integer        not null,
c_d_id         integer        not null,
c_id           integer        not null,
c_discount     decimal(4,4),
c_credit       char(2),
c_last         varchar(16),
c_first        varchar(16),
c_credit_lim   decimal(12,2),
c_balance      decimal(12,2),
c_ytd_payment  decimal(12,2),
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)
);
create sequence bmsql_hist_id_seq;
create table 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 decimal(6,2),
h_data   varchar(24)
);
create table bmsql_new_order (
no_w_id  integer   not null,
no_d_id  integer   not null,
no_o_id  integer   not null
);
create table 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     integer,
o_all_local  integer,
o_entry_d    timestamp
);
create table 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       decimal(6,2),
ol_supply_w_id  integer,
ol_quantity     integer,
ol_dist_info    char(24)
);
create table bmsql_item (
i_id     integer      not null,
i_name   varchar(24),
i_price  decimal(5,2),
i_data   varchar(50),
i_im_id  integer
);
create table bmsql_stock (
s_w_id       integer       not null,
s_i_id       integer       not null,
s_quantity   integer,
s_ytd        integer,
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)
);
Tue Dec 26 08:57:27 AM CST 2023 -- start Load Data...
Starting BenchmarkSQL LoadData

driver=org.opengauss.Driver
conn=jdbc:opengauss://127.0.0.1:7654/tpcc
user=tpcc
password=***********
warehouses=10
loadWorkers=4
fileLocation (not defined)
csvNullValue (not defined - using default 'NULL')

Dec 26, 2023 8:57:28 AM org.opengauss.core.v3.ConnectionFactoryImpl openConnectionImpl
INFO: [0550455e-46b0-4935-8a50-8c122c1dbc1b] Try to connect. IP: 127.0.0.1:7654
Dec 26, 2023 8:57:28 AM org.opengauss.core.v3.ConnectionFactoryImpl openConnectionImpl
INFO: [127.0.0.1:40716/127.0.0.1:7654] Connection is established. ID: 0550455e-46b0-4935-8a50-8c122c1dbc1b
Dec 26, 2023 8:57:28 AM org.opengauss.core.v3.ConnectionFactoryImpl openConnectionImpl
INFO: Connect complete. ID: 0550455e-46b0-4935-8a50-8c122c1dbc1b
Dec 26, 2023 8:57:28 AM org.opengauss.core.v3.ConnectionFactoryImpl openConnectionImpl
INFO: [42bc8d1d-72a6-4ec3-bc05-021afeca62ab] Try to connect. IP: 127.0.0.1:7654
Worker 000: Loading ITEM
Dec 26, 2023 8:57:28 AM org.opengauss.core.v3.ConnectionFactoryImpl openConnectionImpl
INFO: [127.0.0.1:40732/127.0.0.1:7654] Connection is established. ID: 42bc8d1d-72a6-4ec3-bc05-021afeca62ab
Dec 26, 2023 8:57:28 AM org.opengauss.core.v3.ConnectionFactoryImpl openConnectionImpl
INFO: Connect complete. ID: 42bc8d1d-72a6-4ec3-bc05-021afeca62ab
Dec 26, 2023 8:57:28 AM org.opengauss.core.v3.ConnectionFactoryImpl openConnectionImpl
INFO: [95e1d878-bca3-45f7-aa65-97dec57d07a1] Try to connect. IP: 127.0.0.1:7654
Worker 001: Loading Warehouse      1
Dec 26, 2023 8:57:28 AM org.opengauss.core.v3.ConnectionFactoryImpl openConnectionImpl
INFO: [127.0.0.1:40742/127.0.0.1:7654] Connection is established. ID: 95e1d878-bca3-45f7-aa65-97dec57d07a1
Dec 26, 2023 8:57:28 AM org.opengauss.core.v3.ConnectionFactoryImpl openConnectionImpl
INFO: Connect complete. ID: 95e1d878-bca3-45f7-aa65-97dec57d07a1
Dec 26, 2023 8:57:28 AM org.opengauss.core.v3.ConnectionFactoryImpl openConnectionImpl
INFO: [729518a5-2d40-4fb3-9ece-e37781805d92] Try to connect. IP: 127.0.0.1:7654
Worker 002: Loading Warehouse      2
Dec 26, 2023 8:57:28 AM org.opengauss.core.v3.ConnectionFactoryImpl openConnectionImpl
INFO: [127.0.0.1:40752/127.0.0.1:7654] Connection is established. ID: 729518a5-2d40-4fb3-9ece-e37781805d92
Dec 26, 2023 8:57:28 AM org.opengauss.core.v3.ConnectionFactoryImpl openConnectionImpl
INFO: Connect complete. ID: 729518a5-2d40-4fb3-9ece-e37781805d92
Worker 003: Loading Warehouse      3
Worker 000: Loading ITEM done
Worker 000: Loading Warehouse      4
Worker 003: Loading Warehouse      3 done
Worker 003: Loading Warehouse      5
Worker 001: Loading Warehouse      1 done
Worker 001: Loading Warehouse      6
Worker 002: Loading Warehouse      2 done
Worker 002: Loading Warehouse      7
Worker 000: Loading Warehouse      4 done
Worker 000: Loading Warehouse      8
Worker 003: Loading Warehouse      5 done
Worker 003: Loading Warehouse      9
Worker 001: Loading Warehouse      6 done
Worker 001: Loading Warehouse     10
Worker 002: Loading Warehouse      7 done
Worker 000: Loading Warehouse      8 done
Worker 003: Loading Warehouse      9 done
Worker 001: Loading Warehouse     10 done
# ------------------------------------------------------------
# Loading SQL file ./sql.common/indexCreates.sql
# ------------------------------------------------------------
Dec 26, 2023 8:58:14 AM org.opengauss.core.v3.ConnectionFactoryImpl openConnectionImpl
INFO: [fda4422b-bd9d-44a2-95c8-584f9fa683f3] Try to connect. IP: 127.0.0.1:7654
Dec 26, 2023 8:58:14 AM org.opengauss.core.v3.ConnectionFactoryImpl openConnectionImpl
INFO: [127.0.0.1:49670/127.0.0.1:7654] Connection is established. ID: fda4422b-bd9d-44a2-95c8-584f9fa683f3
Dec 26, 2023 8:58:14 AM org.opengauss.core.v3.ConnectionFactoryImpl openConnectionImpl
INFO: Connect complete. ID: fda4422b-bd9d-44a2-95c8-584f9fa683f3
alter table bmsql_warehouse add constraint bmsql_warehouse_pkey
primary key (w_id);
alter table bmsql_district add constraint bmsql_district_pkey
primary key (d_w_id, d_id);
alter table bmsql_customer add constraint bmsql_customer_pkey
primary key (c_w_id, c_d_id, c_id);
create index bmsql_customer_idx1
on  bmsql_customer (c_w_id, c_d_id, c_last, c_first);
alter table bmsql_oorder add constraint bmsql_oorder_pkey
primary key (o_w_id, o_d_id, o_id);
create unique index bmsql_oorder_idx1
on  bmsql_oorder (o_w_id, o_d_id, o_carrier_id, o_id);
alter table bmsql_new_order add constraint bmsql_new_order_pkey
primary key (no_w_id, no_d_id, no_o_id);
alter table bmsql_order_line add constraint bmsql_order_line_pkey
primary key (ol_w_id, ol_d_id, ol_o_id, ol_number);
alter table bmsql_stock add constraint bmsql_stock_pkey
primary key (s_w_id, s_i_id);
alter table bmsql_item add constraint bmsql_item_pkey
primary key (i_id);
# ------------------------------------------------------------
# Loading SQL file ./sql.common/foreignKeys.sql
# ------------------------------------------------------------
Dec 26, 2023 8:58:30 AM org.opengauss.core.v3.ConnectionFactoryImpl openConnectionImpl
INFO: [d10a3bbf-78a4-49c5-81ec-2706c612a55c] Try to connect. IP: 127.0.0.1:7654
Dec 26, 2023 8:58:30 AM org.opengauss.core.v3.ConnectionFactoryImpl openConnectionImpl
INFO: [127.0.0.1:46696/127.0.0.1:7654] Connection is established. ID: d10a3bbf-78a4-49c5-81ec-2706c612a55c
Dec 26, 2023 8:58:30 AM org.opengauss.core.v3.ConnectionFactoryImpl openConnectionImpl
INFO: Connect complete. ID: d10a3bbf-78a4-49c5-81ec-2706c612a55c
alter table bmsql_district add constraint d_warehouse_fkey
foreign key (d_w_id)
references bmsql_warehouse (w_id);
alter table bmsql_customer add constraint c_district_fkey
foreign key (c_w_id, c_d_id)
references bmsql_district (d_w_id, d_id);
alter table bmsql_history add constraint h_customer_fkey
foreign key (h_c_w_id, h_c_d_id, h_c_id)
references bmsql_customer (c_w_id, c_d_id, c_id);
alter table bmsql_history add constraint h_district_fkey
foreign key (h_w_id, h_d_id)
references bmsql_district (d_w_id, d_id);
alter table bmsql_new_order add constraint no_order_fkey
foreign key (no_w_id, no_d_id, no_o_id)
references bmsql_oorder (o_w_id, o_d_id, o_id);
alter table bmsql_oorder add constraint o_customer_fkey
foreign key (o_w_id, o_d_id, o_c_id)
references bmsql_customer (c_w_id, c_d_id, c_id);
alter table bmsql_order_line add constraint ol_order_fkey
foreign key (ol_w_id, ol_d_id, ol_o_id)
references bmsql_oorder (o_w_id, o_d_id, o_id);
alter table bmsql_order_line add constraint ol_stock_fkey
foreign key (ol_supply_w_id, ol_i_id)
references bmsql_stock (s_w_id, s_i_id);
alter table bmsql_stock add constraint s_warehouse_fkey
foreign key (s_w_id)
references bmsql_warehouse (w_id);
alter table bmsql_stock add constraint s_item_fkey
foreign key (s_i_id)
references bmsql_item (i_id);
# ------------------------------------------------------------
# Loading SQL file ./sql.common/buildFinish.sql
# ------------------------------------------------------------
Dec 26, 2023 8:58:37 AM org.opengauss.core.v3.ConnectionFactoryImpl openConnectionImpl
INFO: [a48c0db9-715d-4217-98d8-e475d9d70c2b] Try to connect. IP: 127.0.0.1:7654
Dec 26, 2023 8:58:37 AM org.opengauss.core.v3.ConnectionFactoryImpl openConnectionImpl
INFO: [127.0.0.1:38128/127.0.0.1:7654] Connection is established. ID: a48c0db9-715d-4217-98d8-e475d9d70c2b
Dec 26, 2023 8:58:37 AM org.opengauss.core.v3.ConnectionFactoryImpl openConnectionImpl
INFO: Connect complete. ID: a48c0db9-715d-4217-98d8-e475d9d70c2b
-- ----
-- Extra commands to run after the tables are created, loaded,
-- indexes built and extra's created.
-- ----
Tue Dec 26 08:58:37 AM CST 2023 -- End Load Data...
20231226-08:57:27 ---> 20231226-08:58:37 Total:70 seconds
[root@localhost run]#

4.执行benchmark测试 driver=org.opengauss.Driver

[root@localhost run]# ./runBenchmark.sh props.gs 
2023-12-26 08:58:59: 
2023-12-26 08:58:59: +-------------------------------------------------------------+
2023-12-26 08:58:59:      BenchmarkSQL v5.1
2023-12-26 08:58:59: +-------------------------------------------------------------+
2023-12-26 08:58:59:  (c) 2003, Raul Barbosa
2023-12-26 08:58:59:  (c) 2004-2016, Denis Lussier
2023-12-26 08:58:59:  (c) 2016, Jan Wieck
2023-12-26 08:58:59:  (c) 2023, MapLover
2023-12-26 08:58:59: +-------------------------------------------------------------+
2023-12-26 08:58:59: 
2023-12-26 08:58:59: db=openGauss
2023-12-26 08:58:59: driver=org.opengauss.Driver
2023-12-26 08:58:59: conn=jdbc:opengauss://127.0.0.1:7654/tpcc
2023-12-26 08:58:59: user=tpcc
2023-12-26 08:58:59: 
2023-12-26 08:58:59: warehouses=10
2023-12-26 08:58:59: terminals=10
2023-12-26 08:58:59: runMins=3
2023-12-26 08:58:59: limitTxnsPerMin=100000000
2023-12-26 08:58:59: terminalWarehouseFixed=true
2023-12-26 08:58:59: 
2023-12-26 08:58:59: newOrderWeight=45
2023-12-26 08:58:59: paymentWeight=43
2023-12-26 08:58:59: orderStatusWeight=4
2023-12-26 08:58:59: deliveryWeight=4
2023-12-26 08:58:59: stockLevelWeight=4
2023-12-26 08:58:59: 
2023-12-26 08:58:59: resultDirectory=null
2023-12-26 08:58:59: osCollectorScript=null
2023-12-26 08:58:59: 
Dec 26, 2023 8:58:59 AM org.opengauss.core.v3.ConnectionFactoryImpl openConnectionImpl
INFO: [7b9077d9-3cce-43fa-bf6d-2826e00c1c1c] Try to connect. IP: 127.0.0.1:7654
Dec 26, 2023 8:58:59 AM org.opengauss.core.v3.ConnectionFactoryImpl openConnectionImpl
INFO: [127.0.0.1:53698/127.0.0.1:7654] Connection is established. ID: 7b9077d9-3cce-43fa-bf6d-2826e00c1c1c
Dec 26, 2023 8:58:59 AM org.opengauss.core.v3.ConnectionFactoryImpl openConnectionImpl
INFO: Connect complete. ID: 7b9077d9-3cce-43fa-bf6d-2826e00c1c1c
2023-12-26 08:58:59: C value for C_LAST during load: 93
2023-12-26 08:58:59: C value for C_LAST this run:    211
2023-12-26 08:58:59: 
Dec 26, 2023 8:58:59 AM org.opengauss.core.v3.ConnectionFactoryImpl openConnectionImpl
INFO: [7388908a-f717-420f-897c-bd97cc26df55] Try to connect. IP: 127.0.0.1:7654
Dec 26, 2023 8:58:59 AM org.opengauss.core.v3.ConnectionFactoryImpl openConnectionImpl
INFO: [127.0.0.1:53702/127.0.0.1:7654] Connection is established. ID: 7388908a-f717-420f-897c-bd97cc26df55
Dec 26, 2023 8:58:59 AM org.opengauss.core.v3.ConnectionFactoryImpl openConnectionImpl
INFO: Connect complete. ID: 7388908a-f717-420f-897c-bd97cc26df55
Dec 26, 2023 8:58:59 AM org.opengauss.core.v3.ConnectionFactoryImpl openConnectionImpl
INFO: [9babf24d-798b-4507-ae77-54389403c9b0] Try to connect. IP: 127.0.0.1:7654
Dec 26, 2023 8:58:59 AM org.opengauss.core.v3.ConnectionFactoryImpl openConnectionImpl
INFO: [127.0.0.1:53706/127.0.0.1:7654] Connection is established. ID: 9babf24d-798b-4507-ae77-54389403c9b0
Dec 26, 2023 8:58:59 AM org.opengauss.core.v3.ConnectionFactoryImpl openConnectionImpl
INFO: Connect complete. ID: 9babf24d-798b-4507-ae77-54389403c9b0
Dec 26, 2023 8:58:59 AM org.opengauss.core.v3.ConnectionFactoryImpl openConnectionImpl
INFO: [97ac134d-8fc8-4196-85d1-34d37d67bb22] Try to connect. IP: 127.0.0.1:7654
Dec 26, 2023 8:58:59 AM org.opengauss.core.v3.ConnectionFactoryImpl openConnectionImpl
INFO: [127.0.0.1:53716/127.0.0.1:7654] Connection is established. ID: 97ac134d-8fc8-4196-85d1-34d37d67bb22
Dec 26, 2023 8:58:59 AM org.opengauss.core.v3.ConnectionFactoryImpl openConnectionImpl
INFO: Connect complete. ID: 97ac134d-8fc8-4196-85d1-34d37d67bb22
Dec 26, 2023 8:58:59 AM org.opengauss.core.v3.ConnectionFactoryImpl openConnectionImpl
INFO: [a8bf4fb2-0882-413d-aa11-8e808e7f1da6] Try to connect. IP: 127.0.0.1:7654
Dec 26, 2023 8:58:59 AM org.opengauss.core.v3.ConnectionFactoryImpl openConnectionImpl
INFO: [127.0.0.1:53732/127.0.0.1:7654] Connection is established. ID: a8bf4fb2-0882-413d-aa11-8e808e7f1da6
Dec 26, 2023 8:58:59 AM org.opengauss.core.v3.ConnectionFactoryImpl openConnectionImpl
INFO: Connect complete. ID: a8bf4fb2-0882-413d-aa11-8e808e7f1da6
Dec 26, 2023 8:58:59 AM org.opengauss.core.v3.ConnectionFactoryImpl openConnectionImpl
INFO: [8b5c6e62-a570-40ed-8978-59180131306f] Try to connect. IP: 127.0.0.1:7654
Dec 26, 2023 8:58:59 AM org.opengauss.core.v3.ConnectionFactoryImpl openConnectionImpl
INFO: [127.0.0.1:53748/127.0.0.1:7654] Connection is established. ID: 8b5c6e62-a570-40ed-8978-59180131306f
Dec 26, 2023 8:58:59 AM org.opengauss.core.v3.ConnectionFactoryImpl openConnectionImpl
INFO: Connect complete. ID: 8b5c6e62-a570-40ed-8978-59180131306f
Dec 26, 2023 8:58:59 AM org.opengauss.core.v3.ConnectionFactoryImpl openConnectionImpl
INFO: [c2e1daa5-4aac-45c1-858a-5b94e2986b0b] Try to connect. IP: 127.0.0.1:7654
Dec 26, 2023 8:58:59 AM org.opengauss.core.v3.ConnectionFactoryImpl openConnectionImpl
INFO: [127.0.0.1:53764/127.0.0.1:7654] Connection is established. ID: c2e1daa5-4aac-45c1-858a-5b94e2986b0b
Dec 26, 2023 8:58:59 AM org.opengauss.core.v3.ConnectionFactoryImpl openConnectionImpl
INFO: Connect complete. ID: c2e1daa5-4aac-45c1-858a-5b94e2986b0b
Dec 26, 2023 8:58:59 AM org.opengauss.core.v3.ConnectionFactoryImpl openConnectionImpl
INFO: [0ae025e2-c0c4-4e34-a9bd-c4c030765cef] Try to connect. IP: 127.0.0.1:7654
Dec 26, 2023 8:58:59 AM org.opengauss.core.v3.ConnectionFactoryImpl openConnectionImpl
INFO: [127.0.0.1:53774/127.0.0.1:7654] Connection is established. ID: 0ae025e2-c0c4-4e34-a9bd-c4c030765cef
Dec 26, 2023 8:58:59 AM org.opengauss.core.v3.ConnectionFactoryImpl openConnectionImpl
INFO: Connect complete. ID: 0ae025e2-c0c4-4e34-a9bd-c4c030765cef
Dec 26, 2023 8:58:59 AM org.opengauss.core.v3.ConnectionFactoryImpl openConnectionImpl
INFO: [671d83f4-7dd2-4122-96bc-bcd4c19f016c] Try to connect. IP: 127.0.0.1:7654
Dec 26, 2023 8:58:59 AM org.opengauss.core.v3.ConnectionFactoryImpl openConnectionImpl
INFO: [127.0.0.1:53780/127.0.0.1:7654] Connection is established. ID: 671d83f4-7dd2-4122-96bc-bcd4c19f016c
Dec 26, 2023 8:58:59 AM org.opengauss.core.v3.ConnectionFactoryImpl openConnectionImpl
INFO: Connect complete. ID: 671d83f4-7dd2-4122-96bc-bcd4c19f016c
Dec 26, 2023 8:58:59 AM org.opengauss.core.v3.ConnectionFactoryImpl openConnectionImpl
INFO: [d7239d8f-fcd7-4652-9a41-eebdac6d54b1] Try to connect. IP: 127.0.0.1:7654
Dec 26, 2023 8:58:59 AM org.opengauss.core.v3.ConnectionFactoryImpl openConnectionImpl
INFO: [127.0.0.1:53788/127.0.0.1:7654] Connection is established. ID: d7239d8f-fcd7-4652-9a41-eebdac6d54b1
Dec 26, 2023 8:58:59 AM org.opengauss.core.v3.ConnectionFactoryImpl openConnectionImpl
INFO: Connect complete. ID: d7239d8f-fcd7-4652-9a41-eebdac6d54b1
Dec 26, 2023 8:58:59 AM org.opengauss.core.v3.ConnectionFactoryImpl openConnectionImpl
INFO: [aeb256f5-788a-424a-b19b-aa46dd6a11c0] Try to connect. IP: 127.0.0.1:7654
Dec 26, 2023 8:58:59 AM org.opengauss.core.v3.ConnectionFactoryImpl openConnectionImpl
INFO: [127.0.0.1:53802/127.0.0.1:7654] Connection is established. ID: aeb256f5-788a-424a-b19b-aa46dd6a11c0
Dec 26, 2023 8:58:59 AM org.opengauss.core.v3.ConnectionFactoryImpl openConnectionImpl
INFO: Connect complete. ID: aeb256f5-788a-424a-b19b-aa46dd6a11c0
2023-12-26 09:02:00: Measured tpmC (NewOrders) = 11028.22
2023-12-26 09:02:00: Measured tpmTOTAL = 24399.37
2023-12-26 09:02:00: Session Start     = 2023-12-26 08:58:59
2023-12-26 09:02:00: Session End       = 2023-12-26 09:02:00
2023-12-26 09:02:00: Transaction Count = 73470
2023-12-26 09:02:00: TPCC_RPT=[jdbc:opengauss://127.0.0.1:7654/tpcc]>10W>10T>3M: 	11028.22
[root@localhost run]#

5.执行benchmark测试 driver=org.postgresql.Driver

[root@ecs-x86-14 run]# ./runBenchmark.sh props.gs 
2023-12-26 19:47:37: 
2023-12-26 19:47:37: +-------------------------------------------------------------+
2023-12-26 19:47:37:      BenchmarkSQL v5.1
2023-12-26 19:47:37: +-------------------------------------------------------------+
2023-12-26 19:47:37:  (c) 2003, Raul Barbosa
2023-12-26 19:47:37:  (c) 2004-2016, Denis Lussier
2023-12-26 19:47:37:  (c) 2016, Jan Wieck
2023-12-26 19:47:37:  (c) 2023, MapLover
2023-12-26 19:47:37: +-------------------------------------------------------------+
2023-12-26 19:47:37: 
2023-12-26 19:47:37: db=openGauss
2023-12-26 19:47:37: driver=org.postgresql.Driver
2023-12-26 19:47:37: conn=jdbc:postgresql://192.168.1.12:5432/tpcc
2023-12-26 19:47:37: user=tpcc
2023-12-26 19:47:37: 
2023-12-26 19:47:37: warehouses=10
2023-12-26 19:47:37: terminals=10
2023-12-26 19:47:37: runMins=3
2023-12-26 19:47:37: limitTxnsPerMin=100000000
2023-12-26 19:47:37: terminalWarehouseFixed=true
2023-12-26 19:47:37: 
2023-12-26 19:47:37: newOrderWeight=45
2023-12-26 19:47:37: paymentWeight=43
2023-12-26 19:47:37: orderStatusWeight=4
2023-12-26 19:47:37: deliveryWeight=4
2023-12-26 19:47:37: stockLevelWeight=4
2023-12-26 19:47:37: 
2023-12-26 19:47:37: resultDirectory=null
2023-12-26 19:47:37: osCollectorScript=null
2023-12-26 19:47:37: 
Dec 26, 2023 7:47:37 PM org.postgresql.core.v3.ConnectionFactoryImpl openConnectionImpl
INFO: [83dd94fb-8fef-45bd-a06e-f904d0483d15] Try to connect. IP: 192.168.1.12:5432
Dec 26, 2023 7:47:37 PM org.postgresql.core.v3.ConnectionFactoryImpl openConnectionImpl
INFO: [192.168.1.14:47318/192.168.1.12:5432] Connection is established. ID: 83dd94fb-8fef-45bd-a06e-f904d0483d15
Dec 26, 2023 7:47:37 PM org.postgresql.core.v3.ConnectionFactoryImpl openConnectionImpl
INFO: Connect complete. ID: 83dd94fb-8fef-45bd-a06e-f904d0483d15
2023-12-26 19:47:37: C value for C_LAST during load: 192
2023-12-26 19:47:37: C value for C_LAST this run:    105
2023-12-26 19:47:37: 
Running Average tpmTOTAL: 0.00    Current tpmTOTAL: 0    Memory Usage: 23MB / 481MB          
Dec 26, 2023 7:47:37 PM org.postgresql.core.v3.ConnectionFactoryImpl openConnectionImpl
INFO: [91edee69-bb65-4d15-9f7b-868f2e3cd38b] Try to connect. IP: 192.168.1.12:5432
Dec 26, 2023 7:47:37 PM org.postgresql.core.v3.ConnectionFactoryImpl openConnectionImpl
INFO: [192.168.1.14:47320/192.168.1.12:5432] Connection is established. ID: 91edee69-bb65-4d15-9f7b-868f2e3cd38b
Dec 26, 2023 7:47:37 PM org.postgresql.core.v3.ConnectionFactoryImpl openConnectionImpl
INFO: Connect complete. ID: 91edee69-bb65-4d15-9f7b-868f2e3cd38b
Dec 26, 2023 7:47:37 PM org.postgresql.core.v3.ConnectionFactoryImpl openConnectionImpl
INFO: [68ac74e1-7d77-41dd-88dd-dd01efe17c11] Try to connect. IP: 192.168.1.12:5432
Dec 26, 2023 7:47:37 PM org.postgresql.core.v3.ConnectionFactoryImpl openConnectionImpl
INFO: [192.168.1.14:47322/192.168.1.12:5432] Connection is established. ID: 68ac74e1-7d77-41dd-88dd-dd01efe17c11
Dec 26, 2023 7:47:37 PM org.postgresql.core.v3.ConnectionFactoryImpl openConnectionImpl
INFO: Connect complete. ID: 68ac74e1-7d77-41dd-88dd-dd01efe17c11
Dec 26, 2023 7:47:37 PM org.postgresql.core.v3.ConnectionFactoryImpl openConnectionImpl
INFO: [c3e6432c-7281-4a79-aa4b-995ee0dc84ab] Try to connect. IP: 192.168.1.12:5432
Dec 26, 2023 7:47:37 PM org.postgresql.core.v3.ConnectionFactoryImpl openConnectionImpl
INFO: [192.168.1.14:47324/192.168.1.12:5432] Connection is established. ID: c3e6432c-7281-4a79-aa4b-995ee0dc84ab
Dec 26, 2023 7:47:37 PM org.postgresql.core.v3.ConnectionFactoryImpl openConnectionImpl
INFO: Connect complete. ID: c3e6432c-7281-4a79-aa4b-995ee0dc84ab
Dec 26, 2023 7:47:37 PM org.postgresql.core.v3.ConnectionFactoryImpl openConnectionImpl
INFO: [13bd6810-3166-481d-9661-317f1b5ac28b] Try to connect. IP: 192.168.1.12:5432
Dec 26, 2023 7:47:37 PM org.postgresql.core.v3.ConnectionFactoryImpl openConnectionImpl
INFO: [192.168.1.14:47326/192.168.1.12:5432] Connection is established. ID: 13bd6810-3166-481d-9661-317f1b5ac28b
Dec 26, 2023 7:47:37 PM org.postgresql.core.v3.ConnectionFactoryImpl openConnectionImpl
INFO: Connect complete. ID: 13bd6810-3166-481d-9661-317f1b5ac28b
Dec 26, 2023 7:47:37 PM org.postgresql.core.v3.ConnectionFactoryImpl openConnectionImpl
INFO: [5b9bc2e2-9921-4a0d-b5fa-fa5bfbcedc4e] Try to connect. IP: 192.168.1.12:5432
Dec 26, 2023 7:47:37 PM org.postgresql.core.v3.ConnectionFactoryImpl openConnectionImpl
INFO: [192.168.1.14:47328/192.168.1.12:5432] Connection is established. ID: 5b9bc2e2-9921-4a0d-b5fa-fa5bfbcedc4e
Dec 26, 2023 7:47:37 PM org.postgresql.core.v3.ConnectionFactoryImpl openConnectionImpl
INFO: Connect complete. ID: 5b9bc2e2-9921-4a0d-b5fa-fa5bfbcedc4e
Dec 26, 2023 7:47:37 PM org.postgresql.core.v3.ConnectionFactoryImpl openConnectionImpl
INFO: [d7546615-1cce-480f-9a93-2324518c2c2f] Try to connect. IP: 192.168.1.12:5432
Dec 26, 2023 7:47:37 PM org.postgresql.core.v3.ConnectionFactoryImpl openConnectionImpl
INFO: [192.168.1.14:47330/192.168.1.12:5432] Connection is established. ID: d7546615-1cce-480f-9a93-2324518c2c2f
Dec 26, 2023 7:47:37 PM org.postgresql.core.v3.ConnectionFactoryImpl openConnectionImpl
INFO: Connect complete. ID: d7546615-1cce-480f-9a93-2324518c2c2f
Dec 26, 2023 7:47:37 PM org.postgresql.core.v3.ConnectionFactoryImpl openConnectionImpl
INFO: [1467c179-01e3-415f-8585-3b520d34e5c8] Try to connect. IP: 192.168.1.12:5432
Dec 26, 2023 7:47:37 PM org.postgresql.core.v3.ConnectionFactoryImpl openConnectionImpl
INFO: [192.168.1.14:47332/192.168.1.12:5432] Connection is established. ID: 1467c179-01e3-415f-8585-3b520d34e5c8
Dec 26, 2023 7:47:37 PM org.postgresql.core.v3.ConnectionFactoryImpl openConnectionImpl
INFO: Connect complete. ID: 1467c179-01e3-415f-8585-3b520d34e5c8
Dec 26, 2023 7:47:37 PM org.postgresql.core.v3.ConnectionFactoryImpl openConnectionImpl
INFO: [190b33e4-b90f-4961-8340-737bcea8f8ec] Try to connect. IP: 192.168.1.12:5432
Dec 26, 2023 7:47:37 PM org.postgresql.core.v3.ConnectionFactoryImpl openConnectionImpl
INFO: [192.168.1.14:47334/192.168.1.12:5432] Connection is established. ID: 190b33e4-b90f-4961-8340-737bcea8f8ec
Dec 26, 2023 7:47:37 PM org.postgresql.core.v3.ConnectionFactoryImpl openConnectionImpl
INFO: Connect complete. ID: 190b33e4-b90f-4961-8340-737bcea8f8ec
Dec 26, 2023 7:47:37 PM org.postgresql.core.v3.ConnectionFactoryImpl openConnectionImpl
INFO: [4eb0cbb1-856d-4227-b82e-4c9efedf4773] Try to connect. IP: 192.168.1.12:5432
Dec 26, 2023 7:47:37 PM org.postgresql.core.v3.ConnectionFactoryImpl openConnectionImpl
INFO: [192.168.1.14:47336/192.168.1.12:5432] Connection is established. ID: 4eb0cbb1-856d-4227-b82e-4c9efedf4773
Dec 26, 2023 7:47:37 PM org.postgresql.core.v3.ConnectionFactoryImpl openConnectionImpl
INFO: Connect complete. ID: 4eb0cbb1-856d-4227-b82e-4c9efedf4773
Dec 26, 2023 7:47:37 PM org.postgresql.core.v3.ConnectionFactoryImpl openConnectionImpl
INFO: [76a58110-7cdb-48f6-b8b5-4ea07dd336d0] Try to connect. IP: 192.168.1.12:5432
Dec 26, 2023 7:47:37 PM org.postgresql.core.v3.ConnectionFactoryImpl openConnectionImpl
INFO: [192.168.1.14:47338/192.168.1.12:5432] Connection is established. ID: 76a58110-7cdb-48f6-b8b5-4ea07dd336d0
Dec 26, 2023 7:47:37 PM org.postgresql.core.v3.ConnectionFactoryImpl openConnectionImpl
INFO: Connect complete. ID: 76a58110-7cdb-48f6-b8b5-4ea07dd336d0
Running Average tpmTOTAL: 30000.00    Current tpmTOTAL: 12    Memory Usage: 50MB / 481MB          
Running Average tpmTOTAL: 72367.58    Current tpmTOTAL: 434220    Memory Usage: 32MB / 396MB          
Running Average tpmTOTAL: 72847.57    Current tpmTOTAL: 677184    Memory Usage: 38MB / 376MB          
Running Average tpmTOTAL: 73093.85    Current tpmTOTAL: 920532    Memory Usage: 33MB / 376MB          
Running Average tpmTOTAL: 73091.78    Current tpmTOTAL: 1160460    Memory Usage: 24MB / 376MB          
Running Average tpmTOTAL: 73191.51    Current tpmTOTAL: 1404252    Memory Usage: 59MB / 376MB          
Running Average tpmTOTAL: 73135.85    Current tpmTOTAL: 1644648    Memory Usage: 58MB / 376MB          
2023-12-26 19:50:37: Measured tpmC (NewOrders) = 32904.78
2023-12-26 19:50:37: Measured tpmTOTAL = 73125.85
2023-12-26 19:50:37: Session Start     = 2023-12-26 19:47:37
2023-12-26 19:50:37: Session End       = 2023-12-26 19:50:37
2023-12-26 19:50:37: Transaction Count = 219418
2023-12-26 19:50:37: TPCC_RPT=[jdbc:postgresql://192.168.1.12:5432/tpcc]>10W>10T>3M: 	32904.78
MapLover2020
关注
  • 8
    点赞
  • 踩
  • 9
    收藏
    觉得还不错? 一键收藏
  • 1
    评论
专栏目录
使用BenchmarkSQL5.0测试SinoDB性能
Sinoregal的博客
02-22 2030
1. bmsql安装前准备 1.1 Java openjdk1.7安装 ■bmsql使用java语言开发，其运行依赖java环境。 ①安装 # yum install java-1.7.0-openjdk java-1.7.0-openjdk-devel -y ②确认 # java -version 1.2 Apache ant安装 ■用于编译java项目。 ①安装 # yum install ant -y ②确认 # ant -v...
mysql-connection-java-5.1-bin-jar
03-13
"mysql-connection-java-5.1-bin-jar" 标题指的是这个特定版本的MySQL Connector/J，即5.1版本的二进制（bin）jar文件。 MySQL Connector/J 5.1是针对MySQL Server 5.1.x系列版本设计的，提供了与Java应用程序交互...
benchmarksql-4.1.1.zip
08-28
benchmarksql-4.1.1.zip，数据库测试，TPCC，数据库标准化测试
Benchmarksql压测
最新发布
m0_61738548的博客
05-07 683
Benchmarksql压测
openGauss/MogDB WDR报告详解
夏洛的克
05-02 1231
摘要 WDR(Workload Diagnosis Report)负载诊断报告，是openGauss的工作负载诊断报告，常用于判断openGauss长期性能问题。WDR报告基于两次不同时间点系统的性能快照数据，生成这两个时间点之间的性能表现报表。 开启WDR快照 参数简介 enable_wdr_snapshot 参数说明: 是否开启数据库监控快照功能。 该参数属于SIGHUP类型参数，请参考表GUC参数分类中对应设置方法进行设置。 取值范围: 布尔型 on: 打开数据库监控快照功能。 off: 关闭数
Benchmarksql压测数据库
万万的博客
05-27 1657
Benchmarksql5.0取消了对MySQL的支持，但是通过修改部分代码仍然可以实现Benchmarksql对MySQL的支持。 本教程是作者根据网上资料和自身实现的时候遇到的问题综合得到的。 1.环境: CentOS 7.6 benchmarksql 5.0 MySQL5.7 2.下载编译benchmarksql源码 2.1 首先安装java开发环境，具体步骤略过，本文涉及到的操作在 java 1.8.0 环境下测试通过。 2.2 安装ant工具。 yum install ant 2.3 下载be
下载BenchmarkSQL并使用BenchmarkSQL查看OceanBase 的执行计划
qq_46645079的博客
03-12 1424
BenchmarkSQL是一个开源的数据库基准测试工具，可以用来评估数据库系统的性能，支持多种常见的数据库系统，包括EnterpriseDB、PostgreSQL、Oracle、Sybase、SQL Server、MySQL、HsqlDB、Derby/JavaDB和FireBird等。。在国内的生产实践中，外键约束已经较少使用，但BenchmarkSQL的实现仍然广泛采用了外键约束，以符合TPC-C的要求。
兄弟标签打印软件P-touch Editor 5.1.012官方中文版
07-16
《全面解析：兄弟标签打印软件P-touch Editor 5.1.012官方中文版》 在现代办公环境中，高效且精准的标签管理是至关重要的。兄弟标签打印软件P-touch Editor 5.1.012官方中文版，作为一款专为兄弟标签打印机设计的...
secoclient win-64-7.0.5.1
04-18
这个版本号7.0.5.1表明这是一个特定的稳定版本，可能包含了错误修复和性能优化。 1. SVN基本概念：SVN是Subversion的简称，源自Apache软件基金会，是一款开源的版本控制系统。它允许团队成员在项目开发过程中同步...
c3p0-0.9.5.1
10-12
标题中的"c3p0-0.9.5.1"指的是C3P0的一个特定版本，即0.9.5.1版。这个版本可能包含了对早期版本的修复、性能优化或新功能的添加。 在描述中提到的"C3P0-0.9.5.1 jar包"，指的是这个版本的C3P0库被打包成了一个Java ...
ps-pulse-win-5.1r5.1-b61437-32bitinstaller
08-17
"ps-pulse-win-5.1r5.1-b61437-32bitinstaller" 是一个针对Windows操作系统的软件安装包，特别适用于32位架构的计算机。从标题我们可以推测，这是一个名为 "ps-pulse" 的软件的Windows版本，其版本号为5.1r5.1，构建...
benchmarksql5.0(兼容达梦版本).tar
05-17
benchmarksql压力测试工具，支持Oracle、DM7(达梦7)等数据库压力测试，一般版本的benchmarksql是不支持DM7压力测试的，分享给需要用到的兄弟们。
benchmarksql-5.0
04-17
An easy to use JDBC benchmark that closely resembles the TPC-C standard for OLTP. RDBMS's presently supported include PostgreSQL, EnterpriseDB and Oracle. 5.0版本对Oracle的支持有所改善
BenchmarkSQL-4.1，tpcc测试工具
04-26
BenchmarkSQL-4.1.jar,
benchmarksql-5.0-pg-oracle-mysql.tar.gz
12-02
BenchmarkSQL5.0，支持postgresql，oracle，mysql测试，内含jdbc，配置文件
压测工具BenchmarkSQL对OceanBase开源版3.1.2性能测试调优
shunwahma的博客
04-15 2284
作者：马顺华 从事运维管理工作多年，目前就职于六棱镜（杭州）科技有限公司，熟悉运维自动化、OceanBase部署运维、MySQL 运维以及各种云平台技术和产品。并已获得OceanBase认证OBCA、OBCP证书。 前言 网络上测试OceanBase性能的方法有很多，不过如果想对比OceanBase数据库跟统数据库、其它分布式数据库产品的性能差异，还需要找到一个能适用彼此的测试方案。benchmarksql内嵌了TPC-C测试脚本，也支持很多数据库，如PostgreSQL、Oracle和Mysql
mysql benchmark sql_BenchmarkSQL安装使用介绍
weixin_39966053的博客
01-27 339
1、安装配置下载地址：http://sourceforge.net/projects/benchmarksql/?source=navbarRequired：JDK7PostgreSQL Version：9.3.4解压：[postgres@localhost~]$unzipbenchmarksql-4.1.0.zip保留配置备份：[postgres@localhost~]$cdbenc...
【性能测试】benchmarksql工具7*24稳定性测试
test_dog的博客
01-29 3497
本文主要介绍使用benchmark工具对数据库进行7*24小时稳定性测试。
Benchmarksql 使用
justforid的博客
04-21 3044
目的及原理 TPC－C是在线事务处理(OLTP)的基准程序，用于衡量数据库系统OLTP性能的指标。 TPC-C测试用到的模型是一个大型的商品批发销售公司，它拥有若干个分布在不同区域的商品仓库。每个仓库负责为10个销售点供货，其中每个销售点为3000个客户提供服务，每个客户提交的订单中，平均每个订单有10项产品（5-15件），所有订单中约1%的产品在其直接所属的仓库中没有存货，必须由其他区域的仓库来供货。同时，每个仓库都要维护公司销售的100000种商品的库存记录。 TPC-C最大的有效.
ffmpeg-n5.1-latest-win64-gpl-5.1.zip
11-11
ffmpeg-n5.1-latest-win64-gpl-5.1.zip 是一个压缩文件，其中包含了一个名为 ffmpeg-n5.1 的软件版本的文件夹。这个软件是一个开源的音视频处理工具，特别适用于 Windows 64 位操作系统。 在这个压缩文件中，GPL 代表了该软件使用GNU通用公共许可证进行授权。这意味着任何人都可以免费使用、修改和分发该软件，只需遵守许可证的条款。 这个软件版本是 n5.1，表示它是经过改进和更新的第五个主要版本，其中包含了一些新的功能和修复了之前版本的错误和漏洞。这个版本是最新的，意味着它是在其他过去的版本之后发布的。 要使用这个软件，需要解压下载下来的压缩文件，并找到其中的 ffmpeg-n5.1 文件夹。然后可以执行其中的可执行文件，通过命令行或其他交互界面来运行该软件。ffmpeg-n5.1 能够处理音频和视频文件，具有广泛的功能，如转码、剪切、合并、混音等。 此外，这个版本是为 Windows 64 位操作系统设计的。如果安装了该操作系统，可以从这个版本中获得更好的性能和兼容性。 总之，ffmpeg-n5.1-latest-win64-gpl-5.1.zip 是一个包含最新版本的 ffmpeg 软件的压缩文件，适用于 Windows 64 位操作系统，通过解压和运行其中的可执行文件，可以使用该软件进行音视频处理。
评论 1
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值