简介：
- 事务处理性能委员会（ Transaction Processing Performance Council
），简称TPC，它的功能是制定商务应用基准程序（Benchmark）的标准规范、性能和价格度量，并管理测试结果的发布。 - TPC－C是在线事务处理(OLTP)的基准程序，用于衡量数据库系统OLTP性能的指标。
1.准备测试工具BENCHMARKSQL
2.解压
unzip benchmarksql-4.1.1.zip /root/benchmarksql-4.1.1/lib/
3 复制dm8jdbc驱动文件到lib目录下
cp /dm8/drivers/jdbc/DmJdbcDriver18.jar
4编辑配置文件
[root@oracle run]# pwd
/root/benchmarksql-4.1.1/run
[root@oracle run]# cat props.dm
driver=dm.jdbc.driver.DmDriver
conn=jdbc:dm://localhost:8881
user=benchmarksql
password=Dameng123@
warehouses=2
terminals=1
//To run specified transactions per terminal- runMins must equal zero
runTxnsPerTerminal=0
//To run for specified minutes- runTxnsPerTerminal must equal zero
runMins=5
//Number of total transactions per minute
limitTxnsPerMin=0
//The following five values must add up to 100
newOrderWeight=45
paymentWeight=43
orderStatusWeight=4
deliveryWeight=4
stockLevelWeight=4
5创建测试用例表
create
table benchmarksql.warehouse
(
w_id int not null ,
w_ytd float ,
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)
)
storage
(
fillfactor 2,
without counter
);
create
table benchmarksql.district
(
d_w_id int not null ,
d_id int not null ,
d_ytd float ,
d_tax float ,
d_next_o_id int ,
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)
)
storage
(
fillfactor 3,
without counter
);
create
table benchmarksql.customer
(
c_w_id int not null ,
c_d_id int not null ,
c_id int 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 int ,
c_delivery_cnt int ,
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)
)
storage
(
without counter
);
create sequence benchmarksql.hist_id_seq;
create
table benchmarksql.history
(
hist_id int default benchmarksql.hist_id_seq.NEXTVAL,
h_c_id int ,
h_c_d_id int ,
h_c_w_id int ,
h_d_id int ,
h_w_id int ,
h_date timestamp ,
h_amount float ,
h_data varchar(24)
)
storage
(
branch(16, 16),
without counter
);
create
table benchmarksql.oorder
(
o_w_id int not null,
o_d_id int not null,
o_id int not null,
o_c_id int ,
o_carrier_id int ,
o_ol_cnt float ,
o_all_local float ,
o_entry_d timestamp ,
cluster primary key(o_w_id, o_d_id, o_id)
)
storage
(
without counter
);
create
table benchmarksql.new_order
(
no_w_id int not null,
no_d_id int not null,
no_o_id int not null,
cluster primary key(no_w_id, no_d_id, no_o_id)
)
storage
(
without counter
);
create
table benchmarksql.order_line
(
ol_w_id int not null ,
ol_d_id int not null ,
ol_o_id int not null ,
ol_number int not null ,
ol_i_id int not null ,
ol_delivery_d timestamp,
ol_amount float ,
ol_supply_w_id int ,
ol_quantity float ,
ol_dist_info char(24) ,
cluster primary key(ol_w_id, ol_d_id, ol_o_id, ol_number)
)
storage
(
without counter
);
create
table benchmarksql.stock
(
s_w_id int not null ,
s_i_id int not null ,
s_quantity float ,
s_ytd float ,
s_order_cnt int ,
s_remote_cnt int ,
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_i_id, s_w_id)
)
storage
(
without counter
);
create
table benchmarksql.item
(
i_id int not null,
i_name varchar(24) ,
i_price float ,
i_data varchar(50) ,
i_im_id int ,
cluster primary key(i_id)
)
storage
(
without counter
);
create
index ndx_customer_name on benchmarksql.customer
(
c_w_id,
c_d_id,
c_last,
c_first
);
6装载数据
./runLoader.sh props.dm numWAREHOUSES 1
7.开始测试：
./runBenchmark.sh props.dm
版权声明：本文为weixin_45127002原创文章，遵循CC 4.0 BY-SA版权协议，转载请附上原文出处链接和本声明。