但行好事 莫问前程

用imp命令向Oracle 19c数据库导入数据时出现IMP-00058 ORA-03113错误

经过排查最后发现是因为执行imp命令的客户端机器内存不足引起的，在关闭无关的程序后再次执行可以正常导入。

benchmarksql 5.0 支持对MySQL的TPC-C测试
根据官方文档介绍的测试环境，本文中涉及的TPC-C测试将使用 BenchmarkSQL5.0 软件实现。BenchmarkSQL是一款基于JDBC实现的类似于OLTP的TPC-C标准测试工具，目前支持的数据库如：PostgreSQL、Oracle等。

一.下载&编译安装

1.先要确定服务器是否安装了 JDK1.8

[root@sjjh /]# java -version
java version "1.7.0_75"
OpenJDK Runtime Environment (rhel-2.5.4.2.0.1.el7_0-x86_64 u75-b13)
OpenJDK 64-Bit Server VM (build 24.75-b04, mixed mode)

因为自带jdk存储在/usr/lib/jvm下，需要将其删除。

[root@sjjh lib]# mv jvm jvmold
[root@sjjh lib]# java -version
-bash: /usr/bin/java: ???

2.安装JDK1.8

[root@sjjh /]# tar -zxvf jdk-linux-x64.tar.gz

[root@sjjh /]# mkdir /usr/java
[root@sjjh /]# mv jdk1.8.0_131 /usr/java/
[root@sjjh /]# vi /etc/profile
....
export JAVA_HOME=/usr/java/jdk1.8.0_131
export JRE_HOME=${JAVA_HOME}/jre
export CLASSPATH=.:${JAVA_HOME}/lib:${JRE_HOME}/lib:$CLASSPATH
export JAVA_PATH=${JAVA_HOME}/bin:${JRE_HOME}/bin
export PATH=$PATH:${JAVA_PATH}

[root@sjjh /]# source /etc/profile
[root@sjjh /]# java -version
java version "1.8.0_131"
Java(TM) SE Runtime Environment (build 1.8.0_131-b11)
Java HotSpot(TM) 64-Bit Server VM (build 25.131-b11, mixed mode)

[root@shard1 /]# unzip benchmarksql-5.0.zip
[root@shard1 /]# cd benchmarksql-5.0/

加载oracle 驱动

[oracle@sjjh lib]$ ls -lrt
total 26084
-rw-r--r--. 1 oracle oinstall 2091135 Jul 11  2013 ojdbc5.jar
-rw-r--r--. 1 oracle oinstall 2739616 Jul 11  2013 ojdbc6.jar
-rw-r--r--. 1 oracle oinstall 2609739 Jul 11  2013 ojdbc5dms.jar
-rw-r--r--. 1 oracle oinstall 3350717 Jul 11  2013 ojdbc6dms.jar
-rw-r--r--. 1 oracle oinstall 3424145 Jul 11  2013 ojdbc5_g.jar
-rw-r--r--. 1 oracle oinstall 3445412 Jul 11  2013 ojdbc5dms_g.jar
-rw-r--r--. 1 oracle oinstall 4494540 Jul 11  2013 ojdbc6_g.jar
-rw-r--r--. 1 oracle oinstall 4517780 Jul 11  2013 ojdbc6dms_g.jar
-rw-r--r--. 1 oracle oinstall   20365 Jul 11  2013 simplefan.jar
[oracle@sjjh lib]$ pwd
/u01/app/oracle/product/11.2.0.4/db/jdbc/lib

[oracle@sjjh lib]$ cp ojdbc6.jar /benchmarksql-5.0/lib/oracle/

[oracle@sjjh lib]$ cd /benchmarksql-5.0/lib/oracle/
[oracle@sjjh oracle]$ pwd
/benchmarksql-5.0/lib/oracle
[oracle@sjjh oracle]$ ls -lrt
total 2680
-rwxrwxr-x. 1 oracle oinstall     174 May 26  2016 README.txt
-rw-r--r--. 1 oracle oinstall 2739616 Nov 14 10:21 ojdbc6.jar

修改props.ora

[oracle@sjjh run]$ vi props.ora
db=oracle
driver=oracle.jdbc.driver.OracleDriver
conn=jdbc:oracle:thin:@localhost:1521:sjjh
user=tpcs
password=tpcs

warehouses=40
loadWorkers=10

terminals=10
//To run specified transactions per terminal- runMins must equal zero
runTxnsPerTerminal=
//To run for specified minutes- runTxnsPerTerminal must equal zero
runMins=10
//Number of total transactions per minute
limitTxnsPerMin=0

//Set to true to run in 4.x compatible mode. Set to false to use the
//entire configured database evenly.
terminalWarehouseFixed=true

//The following five values must add up to 100
newOrderWeight=45
paymentWeight=43
orderStatusWeight=4
deliveryWeight=4
stockLevelWeight=4

// Directory name to create for collecting detailed result data.
// Comment this out to suppress.
resultDirectory=my_result_%tY-%tm-%td_%tH%tM%tS
osCollectorScript=./misc/os_collector_linux.py
osCollectorInterval=1
//osCollectorSSHAddr=user@dbhost
//osCollectorDevices=net_eth0 blk_sda

使用ant进行编译

[oracle@sjjh benchmarksql-5.0]$ ant
Buildfile: /benchmarksql-5.0/build.xml

init:

compile:
    [javac] Compiling 11 source files to /benchmarksql-5.0/build

dist:
    [mkdir] Created dir: /benchmarksql-5.0/dist
      [jar] Building jar: /benchmarksql-5.0/dist/BenchmarkSQL-5.0.jar

BUILD SUCCESSFUL
Total time: 2 seconds

初始化数据

[oracle@sjjh run]$  ./runDatabaseBuild.sh props.ora
# ------------------------------------------------------------
# Loading SQL file ./sql.common/tableCreates.sql
# ------------------------------------------------------------
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)
);
Starting BenchmarkSQL LoadData

driver=oracle.jdbc.driver.OracleDriver
conn=jdbc:oracle:thin:@10.138.130.101:1521:sjjh
user=tpcs
password=***********
warehouses=40
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 004: Loading Warehouse      4 done
Worker 004: Loading Warehouse     11
Worker 007: Loading Warehouse      7 done
Worker 007: Loading Warehouse     12
Worker 005: Loading Warehouse      5 done
Worker 005: Loading Warehouse     13
Worker 008: Loading Warehouse      8 done
Worker 008: Loading Warehouse     14
Worker 006: Loading Warehouse      6 done
Worker 001: Loading Warehouse      1 done
Worker 006: Loading Warehouse     15
Worker 001: Loading Warehouse     16
Worker 009: Loading Warehouse      9 done
Worker 009: Loading Warehouse     17
Worker 002: Loading Warehouse      2 done
Worker 002: Loading Warehouse     18
Worker 003: Loading Warehouse      3 done
Worker 003: Loading Warehouse     19
Worker 000: Loading Warehouse     10 done
Worker 000: Loading Warehouse     20
Worker 004: Loading Warehouse     11 done
Worker 004: Loading Warehouse     21
Worker 008: Loading Warehouse     14 done
Worker 008: Loading Warehouse     22
Worker 005: Loading Warehouse     13 done
Worker 005: Loading Warehouse     23
Worker 007: Loading Warehouse     12 done
Worker 006: Loading Warehouse     15 done
Worker 007: Loading Warehouse     24
Worker 006: Loading Warehouse     25
Worker 003: Loading Warehouse     19 done
Worker 003: Loading Warehouse     26
Worker 002: Loading Warehouse     18 done
Worker 002: Loading Warehouse     27
Worker 000: Loading Warehouse     20 done
Worker 000: Loading Warehouse     28
Worker 001: Loading Warehouse     16 done
Worker 001: Loading Warehouse     29
Worker 009: Loading Warehouse     17 done
Worker 009: Loading Warehouse     30
Worker 004: Loading Warehouse     21 done
Worker 004: Loading Warehouse     31
Worker 008: Loading Warehouse     22 done
Worker 008: Loading Warehouse     32
Worker 006: Loading Warehouse     25 done
Worker 006: Loading Warehouse     33
Worker 007: Loading Warehouse     24 done
Worker 007: Loading Warehouse     34
Worker 003: Loading Warehouse     26 done
Worker 001: Loading Warehouse     29 done
Worker 003: Loading Warehouse     35
Worker 001: Loading Warehouse     36
Worker 005: Loading Warehouse     23 done
Worker 005: Loading Warehouse     37
Worker 002: Loading Warehouse     27 done
Worker 002: Loading Warehouse     38
Worker 000: Loading Warehouse     28 done
Worker 000: Loading Warehouse     39
Worker 009: Loading Warehouse     30 done
Worker 009: Loading Warehouse     40
Worker 007: Loading Warehouse     34 done
Worker 004: Loading Warehouse     31 done
Worker 008: Loading Warehouse     32 done
Worker 006: Loading Warehouse     33 done
Worker 003: Loading Warehouse     35 done
Worker 001: Loading Warehouse     36 done
Worker 005: Loading Warehouse     37 done
Worker 000: Loading Warehouse     39 done
Worker 009: Loading Warehouse     40 done
Worker 002: Loading Warehouse     38 done
# ------------------------------------------------------------
# Loading SQL file ./sql.common/indexCreates.sql
# ------------------------------------------------------------
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
# ------------------------------------------------------------
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.oracle/extraHistID.sql
# ------------------------------------------------------------
-- ----
-- Extra Schema objects/definitions for history.hist_id in Oracle
-- ----
-- ----
--      This is an extra column not present in the TPC-C
--      specs. It is useful for replication systems like
--      Bucardo and Slony-I, which like to have a primary
--      key on a table. It is an auto-increment or serial
--      column type. The definition below is compatible
--      with Oracle 11g, using the sequence in a trigger.
-- ----
-- Adjust the sequence above the current max(hist_id)
alter sequence bmsql_hist_id_seq increment by 30000;
declare
n integer;
i integer;
dummy integer;
begin
select max(hist_id) into n from bmsql_history;
i := 0;
while i < = n loop
select bmsql_hist_id_seq.nextval into dummy from dual;
i := i + 30000;
end loop;
end;
;
alter sequence bmsql_hist_id_seq increment by 1;
-- Create a trigger that forces hist_id to be hist_id_seq.nextval
create trigger bmsql_history_before_insert
before insert on bmsql_history
for each row
begin
if :new.hist_id is null then
select bmsql_hist_id_seq.nextval into :new.hist_id from dual;
end if;
end;
;
-- Add a primary key history(hist_id)
alter table bmsql_history add primary key (hist_id);
# ------------------------------------------------------------
# Loading SQL file ./sql.common/buildFinish.sql
# ------------------------------------------------------------
-- ----
-- Extra commands to run after the tables are created, loaded,
-- indexes built and extra's created.
-- ----‘

执行压测

[oracle@sjjh run]$ ./runBenchmark.sh props.ora
10:51:30,810 [main] INFO   jTPCC : Term-00,
10:51:30,815 [main] INFO   jTPCC : Term-00, +-------------------------------------------------------------+
10:51:30,816 [main] INFO   jTPCC : Term-00,      BenchmarkSQL v5.0
10:51:30,816 [main] INFO   jTPCC : Term-00, +-------------------------------------------------------------+
10:51:30,816 [main] INFO   jTPCC : Term-00,  (c) 2003, Raul Barbosa
10:51:30,817 [main] INFO   jTPCC : Term-00,  (c) 2004-2016, Denis Lussier
10:51:30,821 [main] INFO   jTPCC : Term-00,  (c) 2016, Jan Wieck
10:51:30,821 [main] INFO   jTPCC : Term-00, +-------------------------------------------------------------+
10:51:30,822 [main] INFO   jTPCC : Term-00,
10:51:30,822 [main] INFO   jTPCC : Term-00, db=oracle
10:51:30,822 [main] INFO   jTPCC : Term-00, driver=oracle.jdbc.driver.OracleDriver
10:51:30,823 [main] INFO   jTPCC : Term-00, conn=jdbc:oracle:thin:@10.138.130.101:1521:sjjh
10:51:30,823 [main] INFO   jTPCC : Term-00, user=tpcs
10:51:30,823 [main] INFO   jTPCC : Term-00,
10:51:30,823 [main] INFO   jTPCC : Term-00, warehouses=40
10:51:30,824 [main] INFO   jTPCC : Term-00, terminals=10
10:51:30,827 [main] INFO   jTPCC : Term-00, runMins=10
10:51:30,827 [main] INFO   jTPCC : Term-00, limitTxnsPerMin=0
10:51:30,827 [main] INFO   jTPCC : Term-00, terminalWarehouseFixed=true
10:51:30,828 [main] INFO   jTPCC : Term-00,
10:51:30,828 [main] INFO   jTPCC : Term-00, newOrderWeight=45
10:51:30,828 [main] INFO   jTPCC : Term-00, paymentWeight=43
10:51:30,828 [main] INFO   jTPCC : Term-00, orderStatusWeight=4
10:51:30,829 [main] INFO   jTPCC : Term-00, deliveryWeight=4
10:51:30,829 [main] INFO   jTPCC : Term-00, stockLevelWeight=4
10:51:30,829 [main] INFO   jTPCC : Term-00,
10:51:30,829 [main] INFO   jTPCC : Term-00, resultDirectory=my_result_%tY-%tm-%td_%tH%tM%tS
10:51:30,830 [main] INFO   jTPCC : Term-00, osCollectorScript=./misc/os_collector_linux.py
10:51:30,830 [main] INFO   jTPCC : Term-00,
10:51:31,026 [main] INFO   jTPCC : Term-00, copied props.ora to my_result_2022-11-14_105131/run.properties
10:51:31,027 [main] INFO   jTPCC : Term-00, created my_result_2022-11-14_105131/data/runInfo.csv for runID 1
10:51:31,027 [main] INFO   jTPCC : Term-00, writing per transaction results to my_result_2022-11-14_105131/data/result.csv
10:51:31,028 [main] INFO   jTPCC : Term-00, osCollectorScript=./misc/os_collector_linux.py
10:51:31,029 [main] INFO   jTPCC : Term-00, osCollectorInterval=1
10:51:31,029 [main] INFO   jTPCC : Term-00, osCollectorSSHAddr=null
10:51:31,029 [main] INFO   jTPCC : Term-00, osCollectorDevices=null
10:51:31,161 [main] INFO   jTPCC : Term-00,
10:51:31,676 [main] INFO   jTPCC : Term-00, C value for C_LAST during load: 243
10:51:31,677 [main] INFO   jTPCC : Term-00, C value for C_LAST this run:    125
10:51:31,677 [main] INFO   jTPCC : Term-00,
Term-00, Running Average tpmTOTAL: 10382.94    Current tpmTOTAL: 684828    Memory Usage: 107MB / 649MB
11:01:32,117 [Thread-2] INFO   jTPCC : Term-00,
11:01:32,118 [Thread-2] INFO   jTPCC : Term-00,
11:01:32,118 [Thread-2] INFO   jTPCC : Term-00, Measured tpmC (NewOrders) = 4686.82
11:01:32,118 [Thread-2] INFO   jTPCC : Term-00, Measured tpmTOTAL = 10382.59
11:01:32,118 [Thread-2] INFO   jTPCC : Term-00, Session Start     = 2022-11-14 10:51:32
11:01:32,118 [Thread-2] INFO   jTPCC : Term-00, Session End       = 2022-11-14 11:01:32
11:01:32,119 [Thread-2] INFO   jTPCC : Term-00, Transaction Count = 103831'

清理数据

[oracle@sjjh run]$ ./runDatabaseDestroy.sh props.ora
# ------------------------------------------------------------
# Loading SQL file ./sql.common/tableDrops.sql
# ------------------------------------------------------------
drop table bmsql_config;
drop table bmsql_new_order;
drop table bmsql_order_line;
drop table bmsql_oorder;
drop table bmsql_history;
drop table bmsql_customer;
drop table bmsql_stock;
drop table bmsql_item;
drop table bmsql_district;
drop table bmsql_warehouse;
drop sequence bmsql_hist_id_seq;

benchmarksql 5.0 支持对MySQL的TPC-C测试
根据官方文档介绍的测试环境，本文中涉及的TPC-C测试将使用 BenchmarkSQL5.0 软件实现。BenchmarkSQL是一款基于JDBC实现的类似于OLTP的TPC-C标准测试工具，目前支持的数据库如：PostgreSQL、Oracle等。

一.下载&编译安装

1.先要确定服务器是否安装了 JDK1.8

[root@shard1 /]# java -version
java version "1.7.0_75"
OpenJDK Runtime Environment (rhel-2.5.4.2.0.1.el7_0-x86_64 u75-b13)
OpenJDK 64-Bit Server VM (build 24.75-b04, mixed mode)

因为自带jdk存储在/usr/lib/jvm下，需要将其删除。

[root@shard1 lib]# mv jvm jvmold
[root@shard1 lib]# java -version
-bash: /usr/bin/java: ???

2.安装JDK1.8

[root@shard1 /]# tar -zxvf jdk-linux-x64.tar.gz

[root@shard1 /]# mkdir /usr/java
[root@shard1 /]# mv jdk1.8.0_131 /usr/java/
[root@shard1 /]# vi /etc/profile
....
export JAVA_HOME=/usr/java/jdk1.8.0_131
export JRE_HOME=${JAVA_HOME}/jre
export CLASSPATH=.:${JAVA_HOME}/lib:${JRE_HOME}/lib:$CLASSPATH
export JAVA_PATH=${JAVA_HOME}/bin:${JRE_HOME}/bin
export PATH=$PATH:${JAVA_PATH}

[root@shard1 /]# source /etc/profile
[root@shard1 /]# java -version
java version "1.8.0_131"
Java(TM) SE Runtime Environment (build 1.8.0_131-b11)
Java HotSpot(TM) 64-Bit Server VM (build 25.131-b11, mixed mode)

[root@shard1 /]# unzip benchmarksql-5.0.zip
[root@shard1 /]# cd benchmarksql-5.0/

加载oracle 驱动(这里要使用11g版本的驱动ojdbc6.jar不能使用oracle 12c的ojdbc8.jar)

[oracle@shard1 lib]$ pwd
/u01/app/oracle/product/12.2.0/db/jdbc/lib
[oracle@shard1 lib]$ ls -lrt
2604
-rw-r--r--. 1 oracle oinstall   29051 123 2016 simplefan.jar
-rw-r--r--. 1 oracle oinstall 4036257 123 2016 ojdbc8.jar
-rw-r--r--. 1 oracle oinstall 5623186 123 2016 ojdbc8dms.jar
-rw-r--r--. 1 oracle oinstall 6708730 123 2016 ojdbc8_g.jar
-rw-r--r--. 1 oracle oinstall 6738172 123 2016 ojdbc8dms_g.jar
[oracle@shard1 lib]$ cp ojdbc8.jar /benchmarksql-5.0/lib/oracle/

使用oracle 12c的ojdbc8.jar在执行测试时就会报以下错误信息

[oracle@shard1 run]$ ./runBenchmark.sh props.ora
10:04:25,158 [main] INFO   jTPCC : Term-00,
10:04:25,192 [main] INFO   jTPCC : Term-00, +-------------------------------------------------------------+
10:04:25,192 [main] INFO   jTPCC : Term-00,      BenchmarkSQL v5.0
10:04:25,192 [main] INFO   jTPCC : Term-00, +-------------------------------------------------------------+
10:04:25,192 [main] INFO   jTPCC : Term-00,  (c) 2003, Raul Barbosa
10:04:25,192 [main] INFO   jTPCC : Term-00,  (c) 2004-2016, Denis Lussier
10:04:25,196 [main] INFO   jTPCC : Term-00,  (c) 2016, Jan Wieck
10:04:25,196 [main] INFO   jTPCC : Term-00, +-------------------------------------------------------------+
10:04:25,197 [main] INFO   jTPCC : Term-00,
10:04:25,197 [main] INFO   jTPCC : Term-00, db=oracle
10:04:25,197 [main] INFO   jTPCC : Term-00, driver=oracle.jdbc.driver.OracleDriver
10:04:25,197 [main] INFO   jTPCC : Term-00, conn=jdbc:oracle:thin:@localhost:1521:shardcat
10:04:25,197 [main] INFO   jTPCC : Term-00, user=tpcs
10:04:25,198 [main] INFO   jTPCC : Term-00,
10:04:25,198 [main] INFO   jTPCC : Term-00, warehouses=40
10:04:25,198 [main] INFO   jTPCC : Term-00, terminals=10
Exception in thread "main" java.lang.NumberFormatException: For input string: ""
        at java.lang.NumberFormatException.forInputString(NumberFormatException.java:65)
        at java.lang.Integer.parseInt(Integer.java:592)
        at java.lang.Integer.parseInt(Integer.java:615)
        at jTPCC.(jTPCC.java:95)
        at jTPCC.main(jTPCC.java:53)


[oracle@shard1 lib]$ ls -lrt
total 26084
-rw-r--r--. 1 oracle oinstall 2091135 Jul 11  2013 ojdbc5.jar
-rw-r--r--. 1 oracle oinstall 2739616 Jul 11  2013 ojdbc6.jar
-rw-r--r--. 1 oracle oinstall 2609739 Jul 11  2013 ojdbc5dms.jar
-rw-r--r--. 1 oracle oinstall 3350717 Jul 11  2013 ojdbc6dms.jar
-rw-r--r--. 1 oracle oinstall 3424145 Jul 11  2013 ojdbc5_g.jar
-rw-r--r--. 1 oracle oinstall 3445412 Jul 11  2013 ojdbc5dms_g.jar
-rw-r--r--. 1 oracle oinstall 4494540 Jul 11  2013 ojdbc6_g.jar
-rw-r--r--. 1 oracle oinstall 4517780 Jul 11  2013 ojdbc6dms_g.jar
-rw-r--r--. 1 oracle oinstall   20365 Jul 11  2013 simplefan.jar
[oracle@shard1 lib]$ pwd
/u01/app/oracle/product/11.2.0.4/db/jdbc/lib

[oracle@shard1 lib]$ cp ojdbc6.jar /benchmarksql-5.0/lib/oracle/

[oracle@shard1 lib]$ cd /benchmarksql-5.0/lib/oracle/
[oracle@shard1 oracle]$ pwd
/benchmarksql-5.0/lib/oracle
[oracle@shard1 oracle]$ ls -lrt
total 2680
-rwxrwxr-x. 1 oracle oinstall     174 May 26  2016 README.txt
-rw-r--r--. 1 oracle oinstall 2739616 Nov 14 10:21 ojdbc6.jar

修改props.ora

[oracle@shard1 run]$ vi props.ora
db=oracle
driver=oracle.jdbc.driver.OracleDriver
conn=jdbc:oracle:thin:@localhost:1521:shardcat
user=tpcs
password=tpcs

warehouses=40
loadWorkers=10

terminals=10
//To run specified transactions per terminal- runMins must equal zero
runTxnsPerTerminal=
//To run for specified minutes- runTxnsPerTerminal must equal zero
runMins=10
//Number of total transactions per minute
limitTxnsPerMin=0

//Set to true to run in 4.x compatible mode. Set to false to use the
//entire configured database evenly.
terminalWarehouseFixed=true

//The following five values must add up to 100
newOrderWeight=45
paymentWeight=43
orderStatusWeight=4
deliveryWeight=4
stockLevelWeight=4

// Directory name to create for collecting detailed result data.
// Comment this out to suppress.
resultDirectory=my_result_%tY-%tm-%td_%tH%tM%tS
osCollectorScript=./misc/os_collector_linux.py
osCollectorInterval=1
//osCollectorSSHAddr=user@dbhost
//osCollectorDevices=net_eth0 blk_sda

使用ant进行编译

[oracle@shard1 benchmarksql-5.0]$ ant
Buildfile: /benchmarksql-5.0/build.xml

init:

compile:
    [javac] Compiling 11 source files to /benchmarksql-5.0/build

dist:
    [mkdir] Created dir: /benchmarksql-5.0/dist
      [jar] Building jar: /benchmarksql-5.0/dist/BenchmarkSQL-5.0.jar

BUILD SUCCESSFUL
Total time: 2 seconds

初始化数据

[oracle@shard1 run]$ ./runDatabaseBuild.sh props.ora
# ------------------------------------------------------------
# Loading SQL file ./sql.common/tableCreates.sql
# ------------------------------------------------------------
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;
ORA-00955: name is already used by an existing object

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)
);
Starting BenchmarkSQL LoadData

driver=oracle.jdbc.driver.OracleDriver
conn=jdbc:oracle:thin:@localhost:1521:shardcat
user=tpcc
password=***********
warehouses=40
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 003: Loading Warehouse      3 done
Worker 003: Loading Warehouse     11
Worker 004: Loading Warehouse      4 done
Worker 004: Loading Warehouse     12
Worker 006: Loading Warehouse      6 done
Worker 006: Loading Warehouse     13
Worker 002: Loading Warehouse      2 done
Worker 002: Loading Warehouse     14
Worker 005: Loading Warehouse      5 done
Worker 005: Loading Warehouse     15
Worker 007: Loading Warehouse      7 done
Worker 007: Loading Warehouse     16
Worker 001: Loading Warehouse      1 done
Worker 001: Loading Warehouse     17
Worker 009: Loading Warehouse      9 done
Worker 009: Loading Warehouse     18
Worker 008: Loading Warehouse      8 done
Worker 008: Loading Warehouse     19
Worker 000: Loading Warehouse     10 done
Worker 000: Loading Warehouse     20
Worker 006: Loading Warehouse     13 done
Worker 006: Loading Warehouse     21
Worker 002: Loading Warehouse     14 done
Worker 002: Loading Warehouse     22
Worker 003: Loading Warehouse     11 done
Worker 003: Loading Warehouse     23
Worker 005: Loading Warehouse     15 done
Worker 005: Loading Warehouse     24
Worker 004: Loading Warehouse     12 done
Worker 004: Loading Warehouse     25
Worker 007: Loading Warehouse     16 done
Worker 007: Loading Warehouse     26
Worker 008: Loading Warehouse     19 done
Worker 008: Loading Warehouse     27
Worker 000: Loading Warehouse     20 done
Worker 000: Loading Warehouse     28
Worker 009: Loading Warehouse     18 done
Worker 009: Loading Warehouse     29
Worker 001: Loading Warehouse     17 done
Worker 001: Loading Warehouse     30
Worker 000: Loading Warehouse     28 done
Worker 000: Loading Warehouse     31
Worker 006: Loading Warehouse     21 done
Worker 006: Loading Warehouse     32
Worker 009: Loading Warehouse     29 done
Worker 009: Loading Warehouse     33
Worker 008: Loading Warehouse     27 done
Worker 008: Loading Warehouse     34
Worker 003: Loading Warehouse     23 done
Worker 003: Loading Warehouse     35
Worker 007: Loading Warehouse     26 done
Worker 007: Loading Warehouse     36
Worker 005: Loading Warehouse     24 done
Worker 005: Loading Warehouse     37
Worker 001: Loading Warehouse     30 done
Worker 001: Loading Warehouse     38
Worker 002: Loading Warehouse     22 done
Worker 002: Loading Warehouse     39
Worker 004: Loading Warehouse     25 done
Worker 004: Loading Warehouse     40
Worker 000: Loading Warehouse     31 done
Worker 009: Loading Warehouse     33 done
Worker 005: Loading Warehouse     37 done
Worker 004: Loading Warehouse     40 done
Worker 008: Loading Warehouse     34 done
Worker 007: Loading Warehouse     36 done
Worker 003: Loading Warehouse     35 done
Worker 006: Loading Warehouse     32 done
Worker 001: Loading Warehouse     38 done
Worker 002: Loading Warehouse     39 done
# ------------------------------------------------------------
# Loading SQL file ./sql.common/indexCreates.sql
# ------------------------------------------------------------
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
# ------------------------------------------------------------
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.oracle/extraHistID.sql
# ------------------------------------------------------------
-- ----
-- Extra Schema objects/definitions for history.hist_id in Oracle
-- ----
-- ----
--      This is an extra column not present in the TPC-C
--      specs. It is useful for replication systems like
--      Bucardo and Slony-I, which like to have a primary
--      key on a table. It is an auto-increment or serial
--      column type. The definition below is compatible
--      with Oracle 11g, using the sequence in a trigger.
-- ----
-- Adjust the sequence above the current max(hist_id)
alter sequence bmsql_hist_id_seq increment by 30000;
declare
n integer;
i integer;
dummy integer;
begin
select max(hist_id) into n from bmsql_history;
i := 0;
while i < = n loop
select bmsql_hist_id_seq.nextval into dummy from dual;
i := i + 30000;
end loop;
end;
;
alter sequence bmsql_hist_id_seq increment by 1;
-- Create a trigger that forces hist_id to be hist_id_seq.nextval
create trigger bmsql_history_before_insert
before insert on bmsql_history
for each row
begin
if :new.hist_id is null then
select bmsql_hist_id_seq.nextval into :new.hist_id from dual;
end if;
end;
;
-- Add a primary key history(hist_id)
alter table bmsql_history add primary key (hist_id);
# ------------------------------------------------------------
# Loading SQL file ./sql.common/buildFinish.sql
# ------------------------------------------------------------
-- ----
-- Extra commands to run after the tables are created, loaded,
-- indexes built and extra's created.
-- ----

执行压测

[oracle@shard1 run]$ ./runBenchmark.sh props.ora
10:55:01,136 [main] INFO   jTPCC : Term-00,
10:55:01,142 [main] INFO   jTPCC : Term-00, +-------------------------------------------------------------+
10:55:01,142 [main] INFO   jTPCC : Term-00,      BenchmarkSQL v5.0
10:55:01,142 [main] INFO   jTPCC : Term-00, +-------------------------------------------------------------+
10:55:01,143 [main] INFO   jTPCC : Term-00,  (c) 2003, Raul Barbosa
10:55:01,143 [main] INFO   jTPCC : Term-00,  (c) 2004-2016, Denis Lussier
10:55:01,147 [main] INFO   jTPCC : Term-00,  (c) 2016, Jan Wieck
10:55:01,147 [main] INFO   jTPCC : Term-00, +-------------------------------------------------------------+
10:55:01,147 [main] INFO   jTPCC : Term-00,
10:55:01,147 [main] INFO   jTPCC : Term-00, db=oracle
10:55:01,148 [main] INFO   jTPCC : Term-00, driver=oracle.jdbc.driver.OracleDriver
10:55:01,148 [main] INFO   jTPCC : Term-00, conn=jdbc:oracle:thin:@localhost:1521:shardcat
10:55:01,148 [main] INFO   jTPCC : Term-00, user=tpcc
10:55:01,148 [main] INFO   jTPCC : Term-00,
10:55:01,148 [main] INFO   jTPCC : Term-00, warehouses=40
10:55:01,149 [main] INFO   jTPCC : Term-00, terminals=10
10:55:01,151 [main] INFO   jTPCC : Term-00, runMins=10
10:55:01,152 [main] INFO   jTPCC : Term-00, limitTxnsPerMin=0
10:55:01,152 [main] INFO   jTPCC : Term-00, terminalWarehouseFixed=true
10:55:01,152 [main] INFO   jTPCC : Term-00,
10:55:01,152 [main] INFO   jTPCC : Term-00, newOrderWeight=45
10:55:01,152 [main] INFO   jTPCC : Term-00, paymentWeight=43
10:55:01,152 [main] INFO   jTPCC : Term-00, orderStatusWeight=4
10:55:01,153 [main] INFO   jTPCC : Term-00, deliveryWeight=4
10:55:01,153 [main] INFO   jTPCC : Term-00, stockLevelWeight=4
10:55:01,153 [main] INFO   jTPCC : Term-00,
10:55:01,153 [main] INFO   jTPCC : Term-00, resultDirectory=my_result_%tY-%tm-%td_%tH%tM%tS
10:55:01,154 [main] INFO   jTPCC : Term-00, osCollectorScript=./misc/os_collector_linux.py
10:55:01,154 [main] INFO   jTPCC : Term-00,
10:55:01,455 [main] INFO   jTPCC : Term-00, copied props.ora to my_result_2022-11-14_105501/run.properties
10:55:01,456 [main] INFO   jTPCC : Term-00, created my_result_2022-11-14_105501/data/runInfo.csv for runID 5
10:55:01,456 [main] INFO   jTPCC : Term-00, writing per transaction results to my_result_2022-11-14_105501/data/result.csv
10:55:01,457 [main] INFO   jTPCC : Term-00, osCollectorScript=./misc/os_collector_linux.py
10:55:01,457 [main] INFO   jTPCC : Term-00, osCollectorInterval=1
10:55:01,458 [main] INFO   jTPCC : Term-00, osCollectorSSHAddr=null
10:55:01,458 [main] INFO   jTPCC : Term-00, osCollectorDevices=null
10:55:01,543 [main] INFO   jTPCC : Term-00,
10:55:02,053 [main] INFO   jTPCC : Term-00, C value for C_LAST during load: 74
10:55:02,054 [main] INFO   jTPCC : Term-00, C value for C_LAST this run:    175
10:55:02,054 [main] INFO   jTPCC : Term-00,
Term-00, Running Average tpmTOTAL: 33105.98    Current tpmTOTAL: 2183436    Memory Usage: 39MB / 196MB
11:05:02,526 [Thread-6] INFO   jTPCC : Term-00,
11:05:02,526 [Thread-6] INFO   jTPCC : Term-00,
11:05:02,527 [Thread-6] INFO   jTPCC : Term-00, Measured tpmC (NewOrders) = 14913.98
11:05:02,527 [Thread-6] INFO   jTPCC : Term-00, Measured tpmTOTAL = 33102.08
11:05:02,527 [Thread-6] INFO   jTPCC : Term-00, Session Start     = 2022-11-14 10:55:02
11:05:02,528 [Thread-6] INFO   jTPCC : Term-00, Session End       = 2022-11-14 11:05:02
11:05:02,528 [Thread-6] INFO   jTPCC : Term-00, Transaction Count = 331069

清理数据

[oracle@shard1 run]$ ./runDatabaseDestroy.sh props.ora
# ------------------------------------------------------------
# Loading SQL file ./sql.common/tableDrops.sql
# ------------------------------------------------------------
drop table bmsql_config;
drop table bmsql_new_order;
drop table bmsql_order_line;
drop table bmsql_oorder;
drop table bmsql_history;
drop table bmsql_customer;
drop table bmsql_stock;
drop table bmsql_item;
drop table bmsql_district;
drop table bmsql_warehouse;
drop sequence bmsql_hist_id_seq;

sysbench是一款测试工具主要包括以下几种方式的测试：
1、cpu性能
2、磁盘io性能
3、调度程式性能
4、内存分配及传输速度
5、POSIX线程性能
6、数据库性能(OLTP基准测试)现在sysbench主要支持 MySQL,pgsql,oracle 这3种数据库，默认支持MySQL，想要支持pgsql和oracle需要在编译时指定参数

环境介绍

名称	             版本
sysbench软件版本	sysbench 0.5
操作系统	        oracle linux 7.1
Oracle	          11.2.0.4

安装
1.安装依赖包

[root@shard1 /]# yum -y install make m4  autoconf automake libtool pkgconfig libaio-devel

2.解压sysbench软件

[root@sjjh /]# unzip sysbench-0.5.zip
Archive:  sysbench-0.5.zip
b23a7db377916e424cb555108dc5f784f615993b
   creating: sysbench-0.5/
  inflating: sysbench-0.5/.gitignore
  inflating: sysbench-0.5/.travis.yml
  inflating: sysbench-0.5/COPYING
  inflating: sysbench-0.5/ChangeLog
  inflating: sysbench-0.5/Makefile.am
  inflating: sysbench-0.5/README-WIN.txt
  inflating: sysbench-0.5/README.md
 extracting: sysbench-0.5/TODO
  inflating: sysbench-0.5/autogen.sh
   creating: sysbench-0.5/config/
  inflating: sysbench-0.5/config/config.rpath
  inflating: sysbench-0.5/configure.ac
   creating: sysbench-0.5/doc/
  inflating: sysbench-0.5/doc/Makefile.am
  inflating: sysbench-0.5/doc/manual.xml
   creating: sysbench-0.5/doc/xsl/
  inflating: sysbench-0.5/doc/xsl/Makefile.am
  inflating: sysbench-0.5/doc/xsl/catalog.xml.in
  inflating: sysbench-0.5/doc/xsl/xhtml-chunk.xsl
  inflating: sysbench-0.5/doc/xsl/xhtml-common.xsl
  inflating: sysbench-0.5/doc/xsl/xhtml.xsl
  inflating: sysbench-0.5/install-sh
   creating: sysbench-0.5/m4/
  inflating: sysbench-0.5/m4/ac_check_aio.m4
  inflating: sysbench-0.5/m4/ac_check_mysqlr.m4
  inflating: sysbench-0.5/m4/ac_check_pgsql.m4
  inflating: sysbench-0.5/m4/ac_lua_devel.m4
  inflating: sysbench-0.5/m4/acx_pthread.m4
  inflating: sysbench-0.5/m4/ax_check_docbook.m4
  inflating: sysbench-0.5/m4/extensions.m4
  inflating: sysbench-0.5/m4/lib-ld.m4
  inflating: sysbench-0.5/m4/lib-link.m4
  inflating: sysbench-0.5/m4/lib-prefix.m4
  inflating: sysbench-0.5/missing
  inflating: sysbench-0.5/mkinstalldirs
   creating: sysbench-0.5/sysbench/
  inflating: sysbench-0.5/sysbench/CMakeLists.txt
  inflating: sysbench-0.5/sysbench/Makefile.am
  inflating: sysbench-0.5/sysbench/db_driver.c
  inflating: sysbench-0.5/sysbench/db_driver.h
   creating: sysbench-0.5/sysbench/drivers/
  inflating: sysbench-0.5/sysbench/drivers/Makefile.am
   creating: sysbench-0.5/sysbench/drivers/attachsql/
  inflating: sysbench-0.5/sysbench/drivers/attachsql/Makefile.am
  inflating: sysbench-0.5/sysbench/drivers/attachsql/drv_attachsql.c
   creating: sysbench-0.5/sysbench/drivers/drizzle/
  inflating: sysbench-0.5/sysbench/drivers/drizzle/Makefile.am
  inflating: sysbench-0.5/sysbench/drivers/drizzle/drv_drizzle.c
   creating: sysbench-0.5/sysbench/drivers/mysql/
  inflating: sysbench-0.5/sysbench/drivers/mysql/CMakeLists.txt
  inflating: sysbench-0.5/sysbench/drivers/mysql/Makefile.am
  inflating: sysbench-0.5/sysbench/drivers/mysql/drv_mysql.c
   creating: sysbench-0.5/sysbench/drivers/oracle/
  inflating: sysbench-0.5/sysbench/drivers/oracle/Makefile.am
  inflating: sysbench-0.5/sysbench/drivers/oracle/drv_oracle.c
   creating: sysbench-0.5/sysbench/drivers/pgsql/
  inflating: sysbench-0.5/sysbench/drivers/pgsql/Makefile.am
  inflating: sysbench-0.5/sysbench/drivers/pgsql/drv_pgsql.c
  inflating: sysbench-0.5/sysbench/sb_barrier.c
  inflating: sysbench-0.5/sysbench/sb_barrier.h
  inflating: sysbench-0.5/sysbench/sb_list.h
  inflating: sysbench-0.5/sysbench/sb_logger.c
  inflating: sysbench-0.5/sysbench/sb_logger.h
  inflating: sysbench-0.5/sysbench/sb_options.c
  inflating: sysbench-0.5/sysbench/sb_options.h
  inflating: sysbench-0.5/sysbench/sb_percentile.c
  inflating: sysbench-0.5/sysbench/sb_percentile.h
  inflating: sysbench-0.5/sysbench/sb_timer.c
  inflating: sysbench-0.5/sysbench/sb_timer.h
  inflating: sysbench-0.5/sysbench/sb_win.c
  inflating: sysbench-0.5/sysbench/sb_win.h
   creating: sysbench-0.5/sysbench/scripting/
  inflating: sysbench-0.5/sysbench/scripting/CMakeLists.txt
  inflating: sysbench-0.5/sysbench/scripting/Makefile.am
   creating: sysbench-0.5/sysbench/scripting/lua/
  inflating: sysbench-0.5/sysbench/scripting/lua/COPYRIGHT
  inflating: sysbench-0.5/sysbench/scripting/lua/Makefile.am
  inflating: sysbench-0.5/sysbench/scripting/lua/README
   creating: sysbench-0.5/sysbench/scripting/lua/src/
  inflating: sysbench-0.5/sysbench/scripting/lua/src/CMakeLists.txt
  inflating: sysbench-0.5/sysbench/scripting/lua/src/Makefile.am
  inflating: sysbench-0.5/sysbench/scripting/lua/src/lapi.c
  inflating: sysbench-0.5/sysbench/scripting/lua/src/lapi.h
  inflating: sysbench-0.5/sysbench/scripting/lua/src/lauxlib.c
  inflating: sysbench-0.5/sysbench/scripting/lua/src/lauxlib.h
  inflating: sysbench-0.5/sysbench/scripting/lua/src/lbaselib.c
  inflating: sysbench-0.5/sysbench/scripting/lua/src/lcode.c
  inflating: sysbench-0.5/sysbench/scripting/lua/src/lcode.h
  inflating: sysbench-0.5/sysbench/scripting/lua/src/ldblib.c
  inflating: sysbench-0.5/sysbench/scripting/lua/src/ldebug.c
  inflating: sysbench-0.5/sysbench/scripting/lua/src/ldebug.h
  inflating: sysbench-0.5/sysbench/scripting/lua/src/ldo.c
  inflating: sysbench-0.5/sysbench/scripting/lua/src/ldo.h
  inflating: sysbench-0.5/sysbench/scripting/lua/src/ldump.c
  inflating: sysbench-0.5/sysbench/scripting/lua/src/lfunc.c
  inflating: sysbench-0.5/sysbench/scripting/lua/src/lfunc.h
  inflating: sysbench-0.5/sysbench/scripting/lua/src/lgc.c
  inflating: sysbench-0.5/sysbench/scripting/lua/src/lgc.h
  inflating: sysbench-0.5/sysbench/scripting/lua/src/linit.c
  inflating: sysbench-0.5/sysbench/scripting/lua/src/liolib.c
  inflating: sysbench-0.5/sysbench/scripting/lua/src/llex.c
  inflating: sysbench-0.5/sysbench/scripting/lua/src/llex.h
  inflating: sysbench-0.5/sysbench/scripting/lua/src/llimits.h
  inflating: sysbench-0.5/sysbench/scripting/lua/src/lmathlib.c
  inflating: sysbench-0.5/sysbench/scripting/lua/src/lmem.c
  inflating: sysbench-0.5/sysbench/scripting/lua/src/lmem.h
  inflating: sysbench-0.5/sysbench/scripting/lua/src/loadlib.c
  inflating: sysbench-0.5/sysbench/scripting/lua/src/lobject.c
  inflating: sysbench-0.5/sysbench/scripting/lua/src/lobject.h
  inflating: sysbench-0.5/sysbench/scripting/lua/src/lopcodes.c
  inflating: sysbench-0.5/sysbench/scripting/lua/src/lopcodes.h
  inflating: sysbench-0.5/sysbench/scripting/lua/src/loslib.c
  inflating: sysbench-0.5/sysbench/scripting/lua/src/lparser.c
  inflating: sysbench-0.5/sysbench/scripting/lua/src/lparser.h
  inflating: sysbench-0.5/sysbench/scripting/lua/src/lstate.c
  inflating: sysbench-0.5/sysbench/scripting/lua/src/lstate.h
  inflating: sysbench-0.5/sysbench/scripting/lua/src/lstring.c
  inflating: sysbench-0.5/sysbench/scripting/lua/src/lstring.h
  inflating: sysbench-0.5/sysbench/scripting/lua/src/lstrlib.c
  inflating: sysbench-0.5/sysbench/scripting/lua/src/ltable.c
  inflating: sysbench-0.5/sysbench/scripting/lua/src/ltable.h
  inflating: sysbench-0.5/sysbench/scripting/lua/src/ltablib.c
  inflating: sysbench-0.5/sysbench/scripting/lua/src/ltm.c
  inflating: sysbench-0.5/sysbench/scripting/lua/src/ltm.h
  inflating: sysbench-0.5/sysbench/scripting/lua/src/lua.h
  inflating: sysbench-0.5/sysbench/scripting/lua/src/luaconf.h
  inflating: sysbench-0.5/sysbench/scripting/lua/src/lualib.h
  inflating: sysbench-0.5/sysbench/scripting/lua/src/lundump.c
  inflating: sysbench-0.5/sysbench/scripting/lua/src/lundump.h
  inflating: sysbench-0.5/sysbench/scripting/lua/src/lvm.c
  inflating: sysbench-0.5/sysbench/scripting/lua/src/lvm.h
  inflating: sysbench-0.5/sysbench/scripting/lua/src/lzio.c
  inflating: sysbench-0.5/sysbench/scripting/lua/src/lzio.h
  inflating: sysbench-0.5/sysbench/scripting/lua/src/print.c
  inflating: sysbench-0.5/sysbench/scripting/sb_script.c
  inflating: sysbench-0.5/sysbench/scripting/sb_script.h
  inflating: sysbench-0.5/sysbench/scripting/script_lua.c
  inflating: sysbench-0.5/sysbench/scripting/script_lua.h
  inflating: sysbench-0.5/sysbench/sysbench.c
  inflating: sysbench-0.5/sysbench/sysbench.h
   creating: sysbench-0.5/sysbench/tests/
  inflating: sysbench-0.5/sysbench/tests/CMakeLists.txt
  inflating: sysbench-0.5/sysbench/tests/Makefile.am
   creating: sysbench-0.5/sysbench/tests/cpu/
  inflating: sysbench-0.5/sysbench/tests/cpu/CMakeLists.txt
  inflating: sysbench-0.5/sysbench/tests/cpu/Makefile.am
  inflating: sysbench-0.5/sysbench/tests/cpu/sb_cpu.c
   creating: sysbench-0.5/sysbench/tests/db/
  inflating: sysbench-0.5/sysbench/tests/db/Makefile.am
  inflating: sysbench-0.5/sysbench/tests/db/bulk_insert.lua
  inflating: sysbench-0.5/sysbench/tests/db/common.lua
  inflating: sysbench-0.5/sysbench/tests/db/delete.lua
  inflating: sysbench-0.5/sysbench/tests/db/insert.lua
  inflating: sysbench-0.5/sysbench/tests/db/oltp.lua
  inflating: sysbench-0.5/sysbench/tests/db/oltp_simple.lua
  inflating: sysbench-0.5/sysbench/tests/db/parallel_prepare.lua
  inflating: sysbench-0.5/sysbench/tests/db/select.lua
  inflating: sysbench-0.5/sysbench/tests/db/select_random_points.lua
  inflating: sysbench-0.5/sysbench/tests/db/select_random_ranges.lua
  inflating: sysbench-0.5/sysbench/tests/db/update_index.lua
  inflating: sysbench-0.5/sysbench/tests/db/update_non_index.lua
   creating: sysbench-0.5/sysbench/tests/fileio/
  inflating: sysbench-0.5/sysbench/tests/fileio/CMakeLists.txt
  inflating: sysbench-0.5/sysbench/tests/fileio/Makefile.am
  inflating: sysbench-0.5/sysbench/tests/fileio/crc32.c
  inflating: sysbench-0.5/sysbench/tests/fileio/crc32.h
  inflating: sysbench-0.5/sysbench/tests/fileio/crc32tbl.h
  inflating: sysbench-0.5/sysbench/tests/fileio/sb_fileio.c
   creating: sysbench-0.5/sysbench/tests/memory/
  inflating: sysbench-0.5/sysbench/tests/memory/CMakeLists.txt
  inflating: sysbench-0.5/sysbench/tests/memory/Makefile.am
  inflating: sysbench-0.5/sysbench/tests/memory/sb_memory.c
   creating: sysbench-0.5/sysbench/tests/mutex/
  inflating: sysbench-0.5/sysbench/tests/mutex/CMakeLists.txt
  inflating: sysbench-0.5/sysbench/tests/mutex/Makefile.am
  inflating: sysbench-0.5/sysbench/tests/mutex/sb_mutex.c
  inflating: sysbench-0.5/sysbench/tests/sb_cpu.h
  inflating: sysbench-0.5/sysbench/tests/sb_fileio.h
  inflating: sysbench-0.5/sysbench/tests/sb_memory.h
  inflating: sysbench-0.5/sysbench/tests/sb_mutex.h
  inflating: sysbench-0.5/sysbench/tests/sb_threads.h
   creating: sysbench-0.5/sysbench/tests/threads/
  inflating: sysbench-0.5/sysbench/tests/threads/CMakeLists.txt
  inflating: sysbench-0.5/sysbench/tests/threads/Makefile.am
  inflating: sysbench-0.5/sysbench/tests/threads/sb_threads.c
   creating: sysbench-0.5/tests/
  inflating: sysbench-0.5/tests/Makefile.am
  inflating: sysbench-0.5/tests/README.md
   creating: sysbench-0.5/tests/include/
  inflating: sysbench-0.5/tests/include/config.sh.in
  inflating: sysbench-0.5/tests/include/drv_common.sh
  inflating: sysbench-0.5/tests/include/script_oltp_common.sh
   creating: sysbench-0.5/tests/t/
 extracting: sysbench-0.5/tests/t/1st.t
  inflating: sysbench-0.5/tests/t/api_basic.t
  inflating: sysbench-0.5/tests/t/api_rand.t
  inflating: sysbench-0.5/tests/t/api_sql.t
  inflating: sysbench-0.5/tests/t/cleanup.t
  inflating: sysbench-0.5/tests/t/commands.t
  inflating: sysbench-0.5/tests/t/drivers.t
  inflating: sysbench-0.5/tests/t/drv_mysql.t
  inflating: sysbench-0.5/tests/t/drv_pgsql.t
  inflating: sysbench-0.5/tests/t/help.t
  inflating: sysbench-0.5/tests/t/help_drv_mysql.t
  inflating: sysbench-0.5/tests/t/help_drv_pgsql.t
  inflating: sysbench-0.5/tests/t/prepare.t
  inflating: sysbench-0.5/tests/t/run.t
  inflating: sysbench-0.5/tests/t/script_oltp_mysql.t
  inflating: sysbench-0.5/tests/t/script_oltp_pgsql.t
  inflating: sysbench-0.5/tests/t/test_cpu.t
  inflating: sysbench-0.5/tests/t/test_fileio.t
  inflating: sysbench-0.5/tests/t/test_memory.t
  inflating: sysbench-0.5/tests/t/test_mutex.t
  inflating: sysbench-0.5/tests/t/test_threads.t
  inflating: sysbench-0.5/tests/t/tests.t
  inflating: sysbench-0.5/tests/t/version.t
  inflating: sysbench-0.5/tests/test_run.sh

3.配置环境变量，使用实际的ORACLE_HOME目录

export CC=cc
export CXX=c++
export CFLAGS="-m64 -I /u01/app/oracle/product/11.2.0.4/db/rdbms/public"
export CXXFLAGS="$CFLAGS"
export ORACLE_HOME=/u01/app/oracle/product/11.2.0.4/db
export LD_LIBRARY_PATH=/u01/app/oracle/product/11.2.0.4/db/lib

[root@sjjh /]# export CC=cc
[root@sjjh /]# export CXX=c++
[root@sjjh /]# export CFLAGS="-m64 -I /u01/app/oracle/product/11.2.0.4/db/rdbms/public"
[root@sjjh /]# export CXXFLAGS="$CFLAGS"
[root@sjjh /]# export ORACLE_HOME=/u01/app/oracle/product/11.2.0.4/db
[root@sjjh /]# export LD_LIBRARY_PATH=/u01/app/oracle/product/11.2.0.4/db/lib

4.运行autogen.sh，生成configure目录

[root@sjjh sysbench-0.5]# ./autogen.sh
./autogen.sh: running `aclocal -I m4'
./autogen.sh: running `libtoolize --copy --force'
libtoolize: putting auxiliary files in AC_CONFIG_AUX_DIR, `config'.
libtoolize: copying file `config/ltmain.sh'
libtoolize: putting macros in AC_CONFIG_MACRO_DIR, `m4'.
libtoolize: copying file `m4/libtool.m4'
libtoolize: copying file `m4/ltoptions.m4'
libtoolize: copying file `m4/ltsugar.m4'
libtoolize: copying file `m4/ltversion.m4'
libtoolize: copying file `m4/lt~obsolete.m4'
./autogen.sh: running `autoheader'
./autogen.sh: running `automake -c --foreign --add-missing'
configure.ac:25: installing `config/compile'
configure.ac:11: installing `config/config.guess'
configure.ac:11: installing `config/config.sub'
configure.ac:16: installing `config/install-sh'
configure.ac:16: installing `config/missing'
sysbench/Makefile.am: installing `config/depcomp'
./autogen.sh: running `autoconf'
Libtoolized with: libtoolize (GNU libtool) 2.2.6b
Automade with: automake (GNU automake) 1.11.1
Configured with: autoconf (GNU Autoconf) 2.63

5.编译参数配置，加上–with-oracle

[root@sjjh sysbench-0.5]# ./configure --with-oracle --libdir=/u01/app/oracle/product/11.2.0.4/db/lib --without-mysql
checking build system type... x86_64-unknown-linux-gnu
checking host system type... x86_64-unknown-linux-gnu
checking target system type... x86_64-unknown-linux-gnu
checking for a BSD-compatible install... /usr/bin/install -c
checking whether build environment is sane... yes
checking for a thread-safe mkdir -p... /bin/mkdir -p
checking for gawk... gawk
checking whether make sets $(MAKE)... yes
checking for style of include used by make... GNU
checking for gcc... cc
checking for C compiler default output file name... a.out
checking whether the C compiler works... yes
checking whether we are cross compiling... no
checking for suffix of executables...
checking for suffix of object files... o
checking whether we are using the GNU C compiler... yes
checking whether cc accepts -g... yes
checking for cc option to accept ISO C89... none needed
checking dependency style of cc... gcc3
checking how to run the C preprocessor... cc -E
checking for grep that handles long lines and -e... /bin/grep
checking for egrep... /bin/grep -E
checking for ANSI C header files... yes
checking for sys/types.h... yes
checking for sys/stat.h... yes
checking for stdlib.h... yes
checking for string.h... yes
checking for memory.h... yes
checking for strings.h... yes
checking for inttypes.h... yes
checking for stdint.h... yes
checking for unistd.h... yes
checking minix/config.h usability... no
checking minix/config.h presence... no
checking for minix/config.h... no
checking whether it is safe to define __EXTENSIONS__... yes
checking for gcc... (cached) cc
checking whether we are using the GNU C compiler... (cached) yes
checking whether cc accepts -g... (cached) yes
checking for cc option to accept ISO C89... (cached) none needed
checking dependency style of cc... (cached) gcc3
checking how to run the C preprocessor... cc -E
checking whether cc understands -c and -o together... yes
checking for a sed that does not truncate output... /bin/sed
checking for fgrep... /bin/grep -F
checking for ld used by cc... /usr/bin/ld
checking if the linker (/usr/bin/ld) is GNU ld... yes
checking for BSD- or MS-compatible name lister (nm)... /usr/bin/nm -B
checking the name lister (/usr/bin/nm -B) interface... BSD nm
checking whether ln -s works... yes
checking the maximum length of command line arguments... 1572864
checking whether the shell understands some XSI constructs... yes
checking whether the shell understands "+="... yes
checking for /usr/bin/ld option to reload object files... -r
checking for objdump... objdump
checking how to recognize dependent libraries... pass_all
checking for ar... ar
checking for strip... strip
checking for ranlib... ranlib
checking command to parse /usr/bin/nm -B output from cc object... ok
checking for dlfcn.h... yes
checking for objdir... .libs
checking if cc supports -fno-rtti -fno-exceptions... no
checking for cc option to produce PIC... -fPIC -DPIC
checking if cc PIC flag -fPIC -DPIC works... yes
checking if cc static flag -static works... no
checking if cc supports -c -o file.o... yes
checking if cc supports -c -o file.o... (cached) yes
checking whether the cc linker (/usr/bin/ld -m elf_x86_64) supports shared libraries... yes
checking whether -lc should be explicitly linked in... no
checking dynamic linker characteristics... GNU/Linux ld.so
checking how to hardcode library paths into programs... immediate
checking whether stripping libraries is possible... yes
checking if libtool supports shared libraries... yes
checking whether to build shared libraries... yes
checking whether to build static libraries... yes
checking whether __SUNPRO_C is declared... no
checking "C Compiler version"... "cc (GCC) 4.4.7 20120313 (Red Hat 4.4.7-16)"
checking whether to compile with MySQL support... (cached) no
checking whether to compile with Drizzle support... (cached) yes
checking whether to compile with libattachsql support... (cached) yes
checking whether to compile with Oracle support... (cached) yes
checking whether to compile with PostgreSQL support... (cached) no
checking whether to compile with Lua support... (cached) yes
checking whether SHM_HUGETLB is declared... yes
checking whether O_SYNC is declared... yes
checking for xsltproc... xsltproc
checking whether xsltproc works... yes
checking for the pthreads library -lpthreads... no
checking whether pthreads work without any flags... no
checking whether pthreads work with -Kthread... no
checking whether pthreads work with -kthread... no
checking for the pthreads library -llthread... no
checking whether pthreads work with -pthread... yes
checking for joinable pthread attribute... PTHREAD_CREATE_JOINABLE
checking if more special flags are required for pthreads... no
checking for sqrt in -lm... yes
checking for ld used by GCC... /usr/bin/ld -m elf_x86_64
checking if the linker (/usr/bin/ld -m elf_x86_64) is GNU ld... yes
checking for shared library run path origin... done
checking for libdrizzle... no
checking for libattachsql... no
checking libaio.h usability... yes
checking libaio.h presence... yes
checking for libaio.h... yes
checking for io_queue_init in -laio... yes
checking if io_getevents() has an old interface... no
checking for malloc in -lumem... no
checking for malloc in -lmtmalloc... no
checking for ANSI C header files... (cached) yes
checking errno.h usability... yes
checking errno.h presence... yes
checking for errno.h... yes
checking fcntl.h usability... yes
checking fcntl.h presence... yes
checking for fcntl.h... yes
checking math.h usability... yes
checking math.h presence... yes
checking for math.h... yes
checking pthread.h usability... yes
checking pthread.h presence... yes
checking for pthread.h... yes
checking sched.h usability... yes
checking sched.h presence... yes
checking for sched.h... yes
checking signal.h usability... yes
checking signal.h presence... yes
checking for signal.h... yes
checking for stdlib.h... (cached) yes
checking for string.h... (cached) yes
checking sys/aio.h usability... no
checking sys/aio.h presence... no
checking for sys/aio.h... no
checking sys/ipc.h usability... yes
checking sys/ipc.h presence... yes
checking for sys/ipc.h... yes
checking sys/time.h usability... yes
checking sys/time.h presence... yes
checking for sys/time.h... yes
checking sys/mman.h usability... yes
checking sys/mman.h presence... yes
checking for sys/mman.h... yes
checking sys/shm.h usability... yes
checking sys/shm.h presence... yes
checking for sys/shm.h... yes
checking thread.h usability... no
checking thread.h presence... no
checking for thread.h... no
checking for unistd.h... (cached) yes
checking limits.h usability... yes
checking limits.h presence... yes
checking for limits.h... yes
checking for inline... inline
checking for off_t... yes
checking for size_t... yes
checking whether time.h and sys/time.h may both be included... yes
checking for special C compiler options needed for large files... no
checking for _FILE_OFFSET_BITS value needed for large files... no
checking size of size_t... 8
checking for stdlib.h... (cached) yes
checking for GNU libc compatible malloc... yes
checking for stdlib.h... (cached) yes
checking for unistd.h... (cached) yes
checking for getpagesize... yes
checking for working mmap... yes
checking whether strerror_r is declared... yes
checking for strerror_r... yes
checking whether strerror_r returns char *... yes
checking whether clock_gettime is declared... yes
checking for library containing clock_gettime... -lrt
checking for alarm... yes
checking for directio... no
checking for fdatasync... yes
checking for gettimeofday... yes
checking for lrand48... yes
checking for drand48... yes
checking for memalign... yes
checking for memset... yes
checking for mkstemp... yes
checking for popen... yes
checking for posix_memalign... yes
checking for pthread_yield... yes
checking for _setjmp... yes
checking for setvbuf... yes
checking for sqrt... yes
checking for strdup... yes
checking for thr_setconcurrency... no
checking for valloc... yes
checking for pthread_once... yes
configure: creating ./config.status
config.status: creating Makefile
config.status: creating doc/xsl/Makefile
config.status: creating doc/xsl/catalog.xml
config.status: creating doc/Makefile
config.status: creating sysbench/Makefile
config.status: creating sysbench/drivers/Makefile
config.status: creating sysbench/drivers/mysql/Makefile
config.status: creating sysbench/drivers/drizzle/Makefile
config.status: creating sysbench/drivers/oracle/Makefile
config.status: creating sysbench/drivers/pgsql/Makefile
config.status: creating sysbench/drivers/attachsql/Makefile
config.status: creating sysbench/tests/Makefile
config.status: creating sysbench/tests/cpu/Makefile
config.status: creating sysbench/tests/fileio/Makefile
config.status: creating sysbench/tests/memory/Makefile
config.status: creating sysbench/tests/threads/Makefile
config.status: creating sysbench/tests/mutex/Makefile
config.status: creating sysbench/tests/db/Makefile
config.status: creating sysbench/scripting/Makefile
config.status: creating sysbench/scripting/lua/Makefile
config.status: creating sysbench/scripting/lua/src/Makefile
config.status: creating tests/Makefile
config.status: creating tests/include/config.sh
config.status: creating config/config.h
config.status: executing depfiles commands
config.status: executing libtool commands

6.编译及安装，注意这里要带上oracle的一个so

[oracle@sjjh db]$ pwd
/u01/app/oracle/product/11.2.0.4/db
[oracle@sjjh db]$ cd /u01/app/oracle/product/11.2.0.4/db/lib
[oracle@sjjh lib]$ ls -lrt libclntsh.so
lrwxrwxrwx. 1 oracle oinstall 57 Sep 18 10:06 libclntsh.so -> /u01/app/oracle/product/11.2.0.4/db/lib/libclntsh.so.11.1

[root@sjjh sysbench-0.5]# make ORA_LIBS=/u01/app/oracle/product/11.2.0.4/db/lib/libclntsh.so -j 4
Making all in doc
make[1]: Entering directory `/sysbench-0.5/doc'
Making all in xsl
make[2]: Entering directory `/sysbench-0.5/doc/xsl'
make[2]: Nothing to be done for `all'.
make[2]: Leaving directory `/sysbench-0.5/doc/xsl'
make[2]: Entering directory `/sysbench-0.5/doc'
XML_CATALOG_FILES=./xsl/catalog.xml xsltproc --nonet -o manual.html ./xsl/xhtml.xsl ../doc/manual.xml
make[2]: Leaving directory `/sysbench-0.5/doc'
make[1]: Leaving directory `/sysbench-0.5/doc'
Making all in sysbench
make[1]: Entering directory `/sysbench-0.5/sysbench'
Making all in drivers
make[2]: Entering directory `/sysbench-0.5/sysbench/drivers'
Making all in oracle
make[3]: Entering directory `/sysbench-0.5/sysbench/drivers/oracle'
cc -DHAVE_CONFIG_H -I. -I../../../config  -Iyes/rdbms/demo -Iyes/rdbms/public -I../../../sysbench -D_XOPEN_SOURCE=500 -D_GNU_SOURCE  -W -Wall -Wextra -Wpointer-arith -Wbad-function-cast   -Wstrict-prototypes -Wnested-externs -Winline   -funroll-loops  -Wundef -Wstrict-prototypes -Wmissing-prototypes -Wmissing-declarations -Wredundant-decls -Wcast-align        -pthread -O2 -ggdb3 -m64 -I /u01/app/oracle/product/11.2.0.4/db/rdbms/public -MT libsboracle_a-drv_oracle.o -MD -MP -MF .deps/libsboracle_a-drv_oracle.Tpo -c -o libsboracle_a-drv_oracle.o `test -f 'drv_oracle.c' || echo './'`drv_oracle.c
In file included from /u01/app/oracle/product/11.2.0.4/db/rdbms/public/oci.h:3045,
                 from drv_oracle.c:30:
/u01/app/oracle/product/11.2.0.4/db/rdbms/public/ociap.h:10795: warning: function declaration isn’t a prototype
/u01/app/oracle/product/11.2.0.4/db/rdbms/public/ociap.h:10801: warning: function declaration isn’t a prototype
drv_oracle.c: In function ‘ora_drv_init’:
drv_oracle.c:243: warning: pointer targets in assignment differ in signedness
drv_oracle.c: In function ‘ora_drv_connect’:
drv_oracle.c:310: warning: pointer targets in passing argument 1 of ‘strlen’ differ in signedness
/usr/include/string.h:399: note: expected ‘const char *’ but argument is of type ‘unsigned char *’
drv_oracle.c: In function ‘ora_drv_prepare’:
drv_oracle.c:472: warning: pointer targets in passing argument 3 of ‘OCIStmtPrepare’ differ in signedness
/u01/app/oracle/product/11.2.0.4/db/rdbms/public/ociap.h:7163: note: expected ‘const OraText *’ but argument is of type ‘char *’
drv_oracle.c: In function ‘ora_drv_store_results’:
drv_oracle.c:852: warning: pointer targets in assignment differ in signedness
drv_oracle.c:855: warning: pointer targets in passing argument 1 of ‘__builtin_strncpy’ differ in signedness
drv_oracle.c:855: note: expected ‘char *’ but argument is of type ‘text *’
drv_oracle.c:855: warning: pointer targets in passing argument 2 of ‘__builtin_strncpy’ differ in signedness
drv_oracle.c:855: note: expected ‘const char *’ but argument is of type ‘text *’
drv_oracle.c: At top level:
drv_oracle.c:1077: warning: no previous prototype for ‘get_db_bind_type’
mv -f .deps/libsboracle_a-drv_oracle.Tpo .deps/libsboracle_a-drv_oracle.Po
rm -f libsboracle.a
ar cru libsboracle.a libsboracle_a-drv_oracle.o
ranlib libsboracle.a
make[3]: Leaving directory `/sysbench-0.5/sysbench/drivers/oracle'
make[3]: Entering directory `/sysbench-0.5/sysbench/drivers'
make[3]: Nothing to be done for `all-am'.
make[3]: Leaving directory `/sysbench-0.5/sysbench/drivers'
make[2]: Leaving directory `/sysbench-0.5/sysbench/drivers'
Making all in tests
make[2]: Entering directory `/sysbench-0.5/sysbench/tests'
Making all in cpu
make[3]: Entering directory `/sysbench-0.5/sysbench/tests/cpu'
cc -DHAVE_CONFIG_H -I. -I../../../config  -I../../../sysbench -D_XOPEN_SOURCE=500 -D_GNU_SOURCE  -W -Wall -Wextra -Wpointer-arith -Wbad-function-cast   -Wstrict-prototypes -Wnested-externs -Winline   -funroll-loops  -Wundef -Wstrict-prototypes -Wmissing-prototypes -Wmissing-declarations -Wredundant-decls -Wcast-align        -pthread -O2 -ggdb3 -m64 -I /u01/app/oracle/product/11.2.0.4/db/rdbms/public -MT libsbcpu_a-sb_cpu.o -MD -MP -MF .deps/libsbcpu_a-sb_cpu.Tpo -c -o libsbcpu_a-sb_cpu.o `test -f 'sb_cpu.c' || echo './'`sb_cpu.c
mv -f .deps/libsbcpu_a-sb_cpu.Tpo .deps/libsbcpu_a-sb_cpu.Po
rm -f libsbcpu.a
ar cru libsbcpu.a libsbcpu_a-sb_cpu.o
ranlib libsbcpu.a
make[3]: Leaving directory `/sysbench-0.5/sysbench/tests/cpu'
Making all in fileio
make[3]: Entering directory `/sysbench-0.5/sysbench/tests/fileio'
cc -DHAVE_CONFIG_H -I. -I../../../config  -I../../../sysbench -D_XOPEN_SOURCE=500 -D_GNU_SOURCE  -W -Wall -Wextra -Wpointer-arith -Wbad-function-cast   -Wstrict-prototypes -Wnested-externs -Winline   -funroll-loops  -Wundef -Wstrict-prototypes -Wmissing-prototypes -Wmissing-declarations -Wredundant-decls -Wcast-align        -pthread -O2 -ggdb3 -m64 -I /u01/app/oracle/product/11.2.0.4/db/rdbms/public -MT libsbfileio_a-sb_fileio.o -MD -MP -MF .deps/libsbfileio_a-sb_fileio.Tpo -c -o libsbfileio_a-sb_fileio.o `test -f 'sb_fileio.c' || echo './'`sb_fileio.c
cc -DHAVE_CONFIG_H -I. -I../../../config  -I../../../sysbench -D_XOPEN_SOURCE=500 -D_GNU_SOURCE  -W -Wall -Wextra -Wpointer-arith -Wbad-function-cast   -Wstrict-prototypes -Wnested-externs -Winline   -funroll-loops  -Wundef -Wstrict-prototypes -Wmissing-prototypes -Wmissing-declarations -Wredundant-decls -Wcast-align        -pthread -O2 -ggdb3 -m64 -I /u01/app/oracle/product/11.2.0.4/db/rdbms/public -MT libsbfileio_a-crc32.o -MD -MP -MF .deps/libsbfileio_a-crc32.Tpo -c -o libsbfileio_a-crc32.o `test -f 'crc32.c' || echo './'`crc32.c
mv -f .deps/libsbfileio_a-crc32.Tpo .deps/libsbfileio_a-crc32.Po
mv -f .deps/libsbfileio_a-sb_fileio.Tpo .deps/libsbfileio_a-sb_fileio.Po
rm -f libsbfileio.a
ar cru libsbfileio.a libsbfileio_a-sb_fileio.o libsbfileio_a-crc32.o
ranlib libsbfileio.a
make[3]: Leaving directory `/sysbench-0.5/sysbench/tests/fileio'
Making all in memory
make[3]: Entering directory `/sysbench-0.5/sysbench/tests/memory'
cc -DHAVE_CONFIG_H -I. -I../../../config  -I../../../sysbench -D_XOPEN_SOURCE=500 -D_GNU_SOURCE  -W -Wall -Wextra -Wpointer-arith -Wbad-function-cast   -Wstrict-prototypes -Wnested-externs -Winline   -funroll-loops  -Wundef -Wstrict-prototypes -Wmissing-prototypes -Wmissing-declarations -Wredundant-decls -Wcast-align        -pthread -O2 -ggdb3 -m64 -I /u01/app/oracle/product/11.2.0.4/db/rdbms/public -MT libsbmemory_a-sb_memory.o -MD -MP -MF .deps/libsbmemory_a-sb_memory.Tpo -c -o libsbmemory_a-sb_memory.o `test -f 'sb_memory.c' || echo './'`sb_memory.c
mv -f .deps/libsbmemory_a-sb_memory.Tpo .deps/libsbmemory_a-sb_memory.Po
rm -f libsbmemory.a
ar cru libsbmemory.a libsbmemory_a-sb_memory.o
ranlib libsbmemory.a
make[3]: Leaving directory `/sysbench-0.5/sysbench/tests/memory'
Making all in threads
make[3]: Entering directory `/sysbench-0.5/sysbench/tests/threads'
cc -DHAVE_CONFIG_H -I. -I../../../config  -I../../../sysbench -D_XOPEN_SOURCE=500 -D_GNU_SOURCE  -W -Wall -Wextra -Wpointer-arith -Wbad-function-cast   -Wstrict-prototypes -Wnested-externs -Winline   -funroll-loops  -Wundef -Wstrict-prototypes -Wmissing-prototypes -Wmissing-declarations -Wredundant-decls -Wcast-align        -pthread -O2 -ggdb3 -m64 -I /u01/app/oracle/product/11.2.0.4/db/rdbms/public -MT libsbthreads_a-sb_threads.o -MD -MP -MF .deps/libsbthreads_a-sb_threads.Tpo -c -o libsbthreads_a-sb_threads.o `test -f 'sb_threads.c' || echo './'`sb_threads.c
mv -f .deps/libsbthreads_a-sb_threads.Tpo .deps/libsbthreads_a-sb_threads.Po
rm -f libsbthreads.a
ar cru libsbthreads.a libsbthreads_a-sb_threads.o
ranlib libsbthreads.a
make[3]: Leaving directory `/sysbench-0.5/sysbench/tests/threads'
Making all in mutex
make[3]: Entering directory `/sysbench-0.5/sysbench/tests/mutex'
cc -DHAVE_CONFIG_H -I. -I../../../config  -I../../../sysbench -D_XOPEN_SOURCE=500 -D_GNU_SOURCE  -W -Wall -Wextra -Wpointer-arith -Wbad-function-cast   -Wstrict-prototypes -Wnested-externs -Winline   -funroll-loops  -Wundef -Wstrict-prototypes -Wmissing-prototypes -Wmissing-declarations -Wredundant-decls -Wcast-align        -pthread -O2 -ggdb3 -m64 -I /u01/app/oracle/product/11.2.0.4/db/rdbms/public -MT libsbmutex_a-sb_mutex.o -MD -MP -MF .deps/libsbmutex_a-sb_mutex.Tpo -c -o libsbmutex_a-sb_mutex.o `test -f 'sb_mutex.c' || echo './'`sb_mutex.c
mv -f .deps/libsbmutex_a-sb_mutex.Tpo .deps/libsbmutex_a-sb_mutex.Po
rm -f libsbmutex.a
ar cru libsbmutex.a libsbmutex_a-sb_mutex.o
ranlib libsbmutex.a
make[3]: Leaving directory `/sysbench-0.5/sysbench/tests/mutex'
Making all in db
make[3]: Entering directory `/sysbench-0.5/sysbench/tests/db'
make[3]: Nothing to be done for `all'.
make[3]: Leaving directory `/sysbench-0.5/sysbench/tests/db'
make[3]: Entering directory `/sysbench-0.5/sysbench/tests'
make[3]: Nothing to be done for `all-am'.
make[3]: Leaving directory `/sysbench-0.5/sysbench/tests'
make[2]: Leaving directory `/sysbench-0.5/sysbench/tests'
Making all in scripting
make[2]: Entering directory `/sysbench-0.5/sysbench/scripting'
Making all in lua
make[3]: Entering directory `/sysbench-0.5/sysbench/scripting/lua'
Making all in src
make[4]: Entering directory `/sysbench-0.5/sysbench/scripting/lua/src'
cc -DHAVE_CONFIG_H -I. -I../../../../config  -I../../../../sysbench -D_XOPEN_SOURCE=500 -D_GNU_SOURCE  -W -Wall -Wextra -Wpointer-arith -Wbad-function-cast   -Wstrict-prototypes -Wnested-externs -Winline   -funroll-loops  -Wundef -Wstrict-prototypes -Wmissing-prototypes -Wmissing-declarations -Wredundant-decls -Wcast-align        -pthread -Wno-bad-function-cast -O2 -ggdb3 -m64 -I /u01/app/oracle/product/11.2.0.4/db/rdbms/public -MT lapi.o -MD -MP -MF .deps/lapi.Tpo -c -o lapi.o lapi.c
cc -DHAVE_CONFIG_H -I. -I../../../../config  -I../../../../sysbench -D_XOPEN_SOURCE=500 -D_GNU_SOURCE  -W -Wall -Wextra -Wpointer-arith -Wbad-function-cast   -Wstrict-prototypes -Wnested-externs -Winline   -funroll-loops  -Wundef -Wstrict-prototypes -Wmissing-prototypes -Wmissing-declarations -Wredundant-decls -Wcast-align        -pthread -Wno-bad-function-cast -O2 -ggdb3 -m64 -I /u01/app/oracle/product/11.2.0.4/db/rdbms/public -MT lcode.o -MD -MP -MF .deps/lcode.Tpo -c -o lcode.o lcode.c
cc -DHAVE_CONFIG_H -I. -I../../../../config  -I../../../../sysbench -D_XOPEN_SOURCE=500 -D_GNU_SOURCE  -W -Wall -Wextra -Wpointer-arith -Wbad-function-cast   -Wstrict-prototypes -Wnested-externs -Winline   -funroll-loops  -Wundef -Wstrict-prototypes -Wmissing-prototypes -Wmissing-declarations -Wredundant-decls -Wcast-align        -pthread -Wno-bad-function-cast -O2 -ggdb3 -m64 -I /u01/app/oracle/product/11.2.0.4/db/rdbms/public -MT ldebug.o -MD -MP -MF .deps/ldebug.Tpo -c -o ldebug.o ldebug.c
cc -DHAVE_CONFIG_H -I. -I../../../../config  -I../../../../sysbench -D_XOPEN_SOURCE=500 -D_GNU_SOURCE  -W -Wall -Wextra -Wpointer-arith -Wbad-function-cast   -Wstrict-prototypes -Wnested-externs -Winline   -funroll-loops  -Wundef -Wstrict-prototypes -Wmissing-prototypes -Wmissing-declarations -Wredundant-decls -Wcast-align        -pthread -Wno-bad-function-cast -O2 -ggdb3 -m64 -I /u01/app/oracle/product/11.2.0.4/db/rdbms/public -MT ldo.o -MD -MP -MF .deps/ldo.Tpo -c -o ldo.o ldo.c
mv -f .deps/ldebug.Tpo .deps/ldebug.Po
cc -DHAVE_CONFIG_H -I. -I../../../../config  -I../../../../sysbench -D_XOPEN_SOURCE=500 -D_GNU_SOURCE  -W -Wall -Wextra -Wpointer-arith -Wbad-function-cast   -Wstrict-prototypes -Wnested-externs -Winline   -funroll-loops  -Wundef -Wstrict-prototypes -Wmissing-prototypes -Wmissing-declarations -Wredundant-decls -Wcast-align        -pthread -Wno-bad-function-cast -O2 -ggdb3 -m64 -I /u01/app/oracle/product/11.2.0.4/db/rdbms/public -MT ldump.o -MD -MP -MF .deps/ldump.Tpo -c -o ldump.o ldump.c
mv -f .deps/ldo.Tpo .deps/ldo.Po
cc -DHAVE_CONFIG_H -I. -I../../../../config  -I../../../../sysbench -D_XOPEN_SOURCE=500 -D_GNU_SOURCE  -W -Wall -Wextra -Wpointer-arith -Wbad-function-cast   -Wstrict-prototypes -Wnested-externs -Winline   -funroll-loops  -Wundef -Wstrict-prototypes -Wmissing-prototypes -Wmissing-declarations -Wredundant-decls -Wcast-align        -pthread -Wno-bad-function-cast -O2 -ggdb3 -m64 -I /u01/app/oracle/product/11.2.0.4/db/rdbms/public -MT lfunc.o -MD -MP -MF .deps/lfunc.Tpo -c -o lfunc.o lfunc.c
mv -f .deps/lcode.Tpo .deps/lcode.Po
cc -DHAVE_CONFIG_H -I. -I../../../../config  -I../../../../sysbench -D_XOPEN_SOURCE=500 -D_GNU_SOURCE  -W -Wall -Wextra -Wpointer-arith -Wbad-function-cast   -Wstrict-prototypes -Wnested-externs -Winline   -funroll-loops  -Wundef -Wstrict-prototypes -Wmissing-prototypes -Wmissing-declarations -Wredundant-decls -Wcast-align        -pthread -Wno-bad-function-cast -O2 -ggdb3 -m64 -I /u01/app/oracle/product/11.2.0.4/db/rdbms/public -MT lgc.o -MD -MP -MF .deps/lgc.Tpo -c -o lgc.o lgc.c
mv -f .deps/ldump.Tpo .deps/ldump.Po
cc -DHAVE_CONFIG_H -I. -I../../../../config  -I../../../../sysbench -D_XOPEN_SOURCE=500 -D_GNU_SOURCE  -W -Wall -Wextra -Wpointer-arith -Wbad-function-cast   -Wstrict-prototypes -Wnested-externs -Winline   -funroll-loops  -Wundef -Wstrict-prototypes -Wmissing-prototypes -Wmissing-declarations -Wredundant-decls -Wcast-align        -pthread -Wno-bad-function-cast -O2 -ggdb3 -m64 -I /u01/app/oracle/product/11.2.0.4/db/rdbms/public -MT llex.o -MD -MP -MF .deps/llex.Tpo -c -o llex.o llex.c
mv -f .deps/lapi.Tpo .deps/lapi.Po
mv -f .deps/lfunc.Tpo .deps/lfunc.Po
cc -DHAVE_CONFIG_H -I. -I../../../../config  -I../../../../sysbench -D_XOPEN_SOURCE=500 -D_GNU_SOURCE  -W -Wall -Wextra -Wpointer-arith -Wbad-function-cast   -Wstrict-prototypes -Wnested-externs -Winline   -funroll-loops  -Wundef -Wstrict-prototypes -Wmissing-prototypes -Wmissing-declarations -Wredundant-decls -Wcast-align        -pthread -Wno-bad-function-cast -O2 -ggdb3 -m64 -I /u01/app/oracle/product/11.2.0.4/db/rdbms/public -MT lmem.o -MD -MP -MF .deps/lmem.Tpo -c -o lmem.o lmem.c
cc -DHAVE_CONFIG_H -I. -I../../../../config  -I../../../../sysbench -D_XOPEN_SOURCE=500 -D_GNU_SOURCE  -W -Wall -Wextra -Wpointer-arith -Wbad-function-cast   -Wstrict-prototypes -Wnested-externs -Winline   -funroll-loops  -Wundef -Wstrict-prototypes -Wmissing-prototypes -Wmissing-declarations -Wredundant-decls -Wcast-align        -pthread -Wno-bad-function-cast -O2 -ggdb3 -m64 -I /u01/app/oracle/product/11.2.0.4/db/rdbms/public -MT lobject.o -MD -MP -MF .deps/lobject.Tpo -c -o lobject.o lobject.c
mv -f .deps/lmem.Tpo .deps/lmem.Po
cc -DHAVE_CONFIG_H -I. -I../../../../config  -I../../../../sysbench -D_XOPEN_SOURCE=500 -D_GNU_SOURCE  -W -Wall -Wextra -Wpointer-arith -Wbad-function-cast   -Wstrict-prototypes -Wnested-externs -Winline   -funroll-loops  -Wundef -Wstrict-prototypes -Wmissing-prototypes -Wmissing-declarations -Wredundant-decls -Wcast-align        -pthread -Wno-bad-function-cast -O2 -ggdb3 -m64 -I /u01/app/oracle/product/11.2.0.4/db/rdbms/public -MT lopcodes.o -MD -MP -MF .deps/lopcodes.Tpo -c -o lopcodes.o lopcodes.c
mv -f .deps/lopcodes.Tpo .deps/lopcodes.Po
cc -DHAVE_CONFIG_H -I. -I../../../../config  -I../../../../sysbench -D_XOPEN_SOURCE=500 -D_GNU_SOURCE  -W -Wall -Wextra -Wpointer-arith -Wbad-function-cast   -Wstrict-prototypes -Wnested-externs -Winline   -funroll-loops  -Wundef -Wstrict-prototypes -Wmissing-prototypes -Wmissing-declarations -Wredundant-decls -Wcast-align        -pthread -Wno-bad-function-cast -O2 -ggdb3 -m64 -I /u01/app/oracle/product/11.2.0.4/db/rdbms/public -MT lparser.o -MD -MP -MF .deps/lparser.Tpo -c -o lparser.o lparser.c
mv -f .deps/lobject.Tpo .deps/lobject.Po
cc -DHAVE_CONFIG_H -I. -I../../../../config  -I../../../../sysbench -D_XOPEN_SOURCE=500 -D_GNU_SOURCE  -W -Wall -Wextra -Wpointer-arith -Wbad-function-cast   -Wstrict-prototypes -Wnested-externs -Winline   -funroll-loops  -Wundef -Wstrict-prototypes -Wmissing-prototypes -Wmissing-declarations -Wredundant-decls -Wcast-align        -pthread -Wno-bad-function-cast -O2 -ggdb3 -m64 -I /u01/app/oracle/product/11.2.0.4/db/rdbms/public -MT lstate.o -MD -MP -MF .deps/lstate.Tpo -c -o lstate.o lstate.c
mv -f .deps/llex.Tpo .deps/llex.Po
cc -DHAVE_CONFIG_H -I. -I../../../../config  -I../../../../sysbench -D_XOPEN_SOURCE=500 -D_GNU_SOURCE  -W -Wall -Wextra -Wpointer-arith -Wbad-function-cast   -Wstrict-prototypes -Wnested-externs -Winline   -funroll-loops  -Wundef -Wstrict-prototypes -Wmissing-prototypes -Wmissing-declarations -Wredundant-decls -Wcast-align        -pthread -Wno-bad-function-cast -O2 -ggdb3 -m64 -I /u01/app/oracle/product/11.2.0.4/db/rdbms/public -MT lstring.o -MD -MP -MF .deps/lstring.Tpo -c -o lstring.o lstring.c
mv -f .deps/lstate.Tpo .deps/lstate.Po
cc -DHAVE_CONFIG_H -I. -I../../../../config  -I../../../../sysbench -D_XOPEN_SOURCE=500 -D_GNU_SOURCE  -W -Wall -Wextra -Wpointer-arith -Wbad-function-cast   -Wstrict-prototypes -Wnested-externs -Winline   -funroll-loops  -Wundef -Wstrict-prototypes -Wmissing-prototypes -Wmissing-declarations -Wredundant-decls -Wcast-align        -pthread -Wno-bad-function-cast -O2 -ggdb3 -m64 -I /u01/app/oracle/product/11.2.0.4/db/rdbms/public -MT ltable.o -MD -MP -MF .deps/ltable.Tpo -c -o ltable.o ltable.c
mv -f .deps/lgc.Tpo .deps/lgc.Po
cc -DHAVE_CONFIG_H -I. -I../../../../config  -I../../../../sysbench -D_XOPEN_SOURCE=500 -D_GNU_SOURCE  -W -Wall -Wextra -Wpointer-arith -Wbad-function-cast   -Wstrict-prototypes -Wnested-externs -Winline   -funroll-loops  -Wundef -Wstrict-prototypes -Wmissing-prototypes -Wmissing-declarations -Wredundant-decls -Wcast-align        -pthread -Wno-bad-function-cast -O2 -ggdb3 -m64 -I /u01/app/oracle/product/11.2.0.4/db/rdbms/public -MT ltm.o -MD -MP -MF .deps/ltm.Tpo -c -o ltm.o ltm.c
mv -f .deps/lstring.Tpo .deps/lstring.Po
cc -DHAVE_CONFIG_H -I. -I../../../../config  -I../../../../sysbench -D_XOPEN_SOURCE=500 -D_GNU_SOURCE  -W -Wall -Wextra -Wpointer-arith -Wbad-function-cast   -Wstrict-prototypes -Wnested-externs -Winline   -funroll-loops  -Wundef -Wstrict-prototypes -Wmissing-prototypes -Wmissing-declarations -Wredundant-decls -Wcast-align        -pthread -Wno-bad-function-cast -O2 -ggdb3 -m64 -I /u01/app/oracle/product/11.2.0.4/db/rdbms/public -MT lundump.o -MD -MP -MF .deps/lundump.Tpo -c -o lundump.o lundump.c
mv -f .deps/ltm.Tpo .deps/ltm.Po
cc -DHAVE_CONFIG_H -I. -I../../../../config  -I../../../../sysbench -D_XOPEN_SOURCE=500 -D_GNU_SOURCE  -W -Wall -Wextra -Wpointer-arith -Wbad-function-cast   -Wstrict-prototypes -Wnested-externs -Winline   -funroll-loops  -Wundef -Wstrict-prototypes -Wmissing-prototypes -Wmissing-declarations -Wredundant-decls -Wcast-align        -pthread -Wno-bad-function-cast -O2 -ggdb3 -m64 -I /u01/app/oracle/product/11.2.0.4/db/rdbms/public -MT lvm.o -MD -MP -MF .deps/lvm.Tpo -c -o lvm.o lvm.c
mv -f .deps/lundump.Tpo .deps/lundump.Po
cc -DHAVE_CONFIG_H -I. -I../../../../config  -I../../../../sysbench -D_XOPEN_SOURCE=500 -D_GNU_SOURCE  -W -Wall -Wextra -Wpointer-arith -Wbad-function-cast   -Wstrict-prototypes -Wnested-externs -Winline   -funroll-loops  -Wundef -Wstrict-prototypes -Wmissing-prototypes -Wmissing-declarations -Wredundant-decls -Wcast-align        -pthread -Wno-bad-function-cast -O2 -ggdb3 -m64 -I /u01/app/oracle/product/11.2.0.4/db/rdbms/public -MT lzio.o -MD -MP -MF .deps/lzio.Tpo -c -o lzio.o lzio.c
mv -f .deps/lparser.Tpo .deps/lparser.Po
cc -DHAVE_CONFIG_H -I. -I../../../../config  -I../../../../sysbench -D_XOPEN_SOURCE=500 -D_GNU_SOURCE  -W -Wall -Wextra -Wpointer-arith -Wbad-function-cast   -Wstrict-prototypes -Wnested-externs -Winline   -funroll-loops  -Wundef -Wstrict-prototypes -Wmissing-prototypes -Wmissing-declarations -Wredundant-decls -Wcast-align        -pthread -Wno-bad-function-cast -O2 -ggdb3 -m64 -I /u01/app/oracle/product/11.2.0.4/db/rdbms/public -MT lauxlib.o -MD -MP -MF .deps/lauxlib.Tpo -c -o lauxlib.o lauxlib.c
mv -f .deps/ltable.Tpo .deps/ltable.Po
cc -DHAVE_CONFIG_H -I. -I../../../../config  -I../../../../sysbench -D_XOPEN_SOURCE=500 -D_GNU_SOURCE  -W -Wall -Wextra -Wpointer-arith -Wbad-function-cast   -Wstrict-prototypes -Wnested-externs -Winline   -funroll-loops  -Wundef -Wstrict-prototypes -Wmissing-prototypes -Wmissing-declarations -Wredundant-decls -Wcast-align        -pthread -Wno-bad-function-cast -O2 -ggdb3 -m64 -I /u01/app/oracle/product/11.2.0.4/db/rdbms/public -MT lbaselib.o -MD -MP -MF .deps/lbaselib.Tpo -c -o lbaselib.o lbaselib.c
mv -f .deps/lzio.Tpo .deps/lzio.Po
cc -DHAVE_CONFIG_H -I. -I../../../../config  -I../../../../sysbench -D_XOPEN_SOURCE=500 -D_GNU_SOURCE  -W -Wall -Wextra -Wpointer-arith -Wbad-function-cast   -Wstrict-prototypes -Wnested-externs -Winline   -funroll-loops  -Wundef -Wstrict-prototypes -Wmissing-prototypes -Wmissing-declarations -Wredundant-decls -Wcast-align        -pthread -Wno-bad-function-cast -O2 -ggdb3 -m64 -I /u01/app/oracle/product/11.2.0.4/db/rdbms/public -MT ldblib.o -MD -MP -MF .deps/ldblib.Tpo -c -o ldblib.o ldblib.c
mv -f .deps/ldblib.Tpo .deps/ldblib.Po
cc -DHAVE_CONFIG_H -I. -I../../../../config  -I../../../../sysbench -D_XOPEN_SOURCE=500 -D_GNU_SOURCE  -W -Wall -Wextra -Wpointer-arith -Wbad-function-cast   -Wstrict-prototypes -Wnested-externs -Winline   -funroll-loops  -Wundef -Wstrict-prototypes -Wmissing-prototypes -Wmissing-declarations -Wredundant-decls -Wcast-align        -pthread -Wno-bad-function-cast -O2 -ggdb3 -m64 -I /u01/app/oracle/product/11.2.0.4/db/rdbms/public -MT liolib.o -MD -MP -MF .deps/liolib.Tpo -c -o liolib.o liolib.c
mv -f .deps/lauxlib.Tpo .deps/lauxlib.Po
cc -DHAVE_CONFIG_H -I. -I../../../../config  -I../../../../sysbench -D_XOPEN_SOURCE=500 -D_GNU_SOURCE  -W -Wall -Wextra -Wpointer-arith -Wbad-function-cast   -Wstrict-prototypes -Wnested-externs -Winline   -funroll-loops  -Wundef -Wstrict-prototypes -Wmissing-prototypes -Wmissing-declarations -Wredundant-decls -Wcast-align        -pthread -Wno-bad-function-cast -O2 -ggdb3 -m64 -I /u01/app/oracle/product/11.2.0.4/db/rdbms/public -MT lmathlib.o -MD -MP -MF .deps/lmathlib.Tpo -c -o lmathlib.o lmathlib.c
mv -f .deps/lbaselib.Tpo .deps/lbaselib.Po
cc -DHAVE_CONFIG_H -I. -I../../../../config  -I../../../../sysbench -D_XOPEN_SOURCE=500 -D_GNU_SOURCE  -W -Wall -Wextra -Wpointer-arith -Wbad-function-cast   -Wstrict-prototypes -Wnested-externs -Winline   -funroll-loops  -Wundef -Wstrict-prototypes -Wmissing-prototypes -Wmissing-declarations -Wredundant-decls -Wcast-align        -pthread -Wno-bad-function-cast -O2 -ggdb3 -m64 -I /u01/app/oracle/product/11.2.0.4/db/rdbms/public -MT loslib.o -MD -MP -MF .deps/loslib.Tpo -c -o loslib.o loslib.c
mv -f .deps/lvm.Tpo .deps/lvm.Po
cc -DHAVE_CONFIG_H -I. -I../../../../config  -I../../../../sysbench -D_XOPEN_SOURCE=500 -D_GNU_SOURCE  -W -Wall -Wextra -Wpointer-arith -Wbad-function-cast   -Wstrict-prototypes -Wnested-externs -Winline   -funroll-loops  -Wundef -Wstrict-prototypes -Wmissing-prototypes -Wmissing-declarations -Wredundant-decls -Wcast-align        -pthread -Wno-bad-function-cast -O2 -ggdb3 -m64 -I /u01/app/oracle/product/11.2.0.4/db/rdbms/public -MT ltablib.o -MD -MP -MF .deps/ltablib.Tpo -c -o ltablib.o ltablib.c
mv -f .deps/loslib.Tpo .deps/loslib.Po
cc -DHAVE_CONFIG_H -I. -I../../../../config  -I../../../../sysbench -D_XOPEN_SOURCE=500 -D_GNU_SOURCE  -W -Wall -Wextra -Wpointer-arith -Wbad-function-cast   -Wstrict-prototypes -Wnested-externs -Winline   -funroll-loops  -Wundef -Wstrict-prototypes -Wmissing-prototypes -Wmissing-declarations -Wredundant-decls -Wcast-align        -pthread -Wno-bad-function-cast -O2 -ggdb3 -m64 -I /u01/app/oracle/product/11.2.0.4/db/rdbms/public -MT lstrlib.o -MD -MP -MF .deps/lstrlib.Tpo -c -o lstrlib.o lstrlib.c
mv -f .deps/lmathlib.Tpo .deps/lmathlib.Po
cc -DHAVE_CONFIG_H -I. -I../../../../config  -I../../../../sysbench -D_XOPEN_SOURCE=500 -D_GNU_SOURCE  -W -Wall -Wextra -Wpointer-arith -Wbad-function-cast   -Wstrict-prototypes -Wnested-externs -Winline   -funroll-loops  -Wundef -Wstrict-prototypes -Wmissing-prototypes -Wmissing-declarations -Wredundant-decls -Wcast-align        -pthread -Wno-bad-function-cast -O2 -ggdb3 -m64 -I /u01/app/oracle/product/11.2.0.4/db/rdbms/public -MT loadlib.o -MD -MP -MF .deps/loadlib.Tpo -c -o loadlib.o loadlib.c
mv -f .deps/ltablib.Tpo .deps/ltablib.Po
cc -DHAVE_CONFIG_H -I. -I../../../../config  -I../../../../sysbench -D_XOPEN_SOURCE=500 -D_GNU_SOURCE  -W -Wall -Wextra -Wpointer-arith -Wbad-function-cast   -Wstrict-prototypes -Wnested-externs -Winline   -funroll-loops  -Wundef -Wstrict-prototypes -Wmissing-prototypes -Wmissing-declarations -Wredundant-decls -Wcast-align        -pthread -Wno-bad-function-cast -O2 -ggdb3 -m64 -I /u01/app/oracle/product/11.2.0.4/db/rdbms/public -MT linit.o -MD -MP -MF .deps/linit.Tpo -c -o linit.o linit.c
mv -f .deps/liolib.Tpo .deps/liolib.Po
mv -f .deps/linit.Tpo .deps/linit.Po
mv -f .deps/loadlib.Tpo .deps/loadlib.Po
mv -f .deps/lstrlib.Tpo .deps/lstrlib.Po
rm -f liblua.a
ar cru liblua.a lapi.o lcode.o ldebug.o ldo.o ldump.o lfunc.o lgc.o llex.o lmem.o lobject.o lopcodes.o lparser.o lstate.o lstring.o ltable.o ltm.o lundump.o lvm.o lzio.o lauxlib.o lbaselib.o ldblib.o liolib.o lmathlib.o loslib.o ltablib.o lstrlib.o loadlib.o linit.o
ranlib liblua.a
make[4]: Leaving directory `/sysbench-0.5/sysbench/scripting/lua/src'
make[4]: Entering directory `/sysbench-0.5/sysbench/scripting/lua'
make[4]: Nothing to be done for `all-am'.
make[4]: Leaving directory `/sysbench-0.5/sysbench/scripting/lua'
make[3]: Leaving directory `/sysbench-0.5/sysbench/scripting/lua'
Making all in .
make[3]: Entering directory `/sysbench-0.5/sysbench/scripting'
cc -DHAVE_CONFIG_H -I. -I../../config  -I../../sysbench -I./lua/src -DDATA_PATH=\"/usr/local/share/sysbench\" -D_XOPEN_SOURCE=500 -D_GNU_SOURCE  -W -Wall -Wextra -Wpointer-arith -Wbad-function-cast   -Wstrict-prototypes -Wnested-externs -Winline   -funroll-loops  -Wundef -Wstrict-prototypes -Wmissing-prototypes -Wmissing-declarations -Wredundant-decls -Wcast-align        -pthread -O2 -ggdb3 -m64 -I /u01/app/oracle/product/11.2.0.4/db/rdbms/public -MT libsbscript_a-sb_script.o -MD -MP -MF .deps/libsbscript_a-sb_script.Tpo -c -o libsbscript_a-sb_script.o `test -f 'sb_script.c' || echo './'`sb_script.c
cc -DHAVE_CONFIG_H -I. -I../../config  -I../../sysbench -I./lua/src -DDATA_PATH=\"/usr/local/share/sysbench\" -D_XOPEN_SOURCE=500 -D_GNU_SOURCE  -W -Wall -Wextra -Wpointer-arith -Wbad-function-cast   -Wstrict-prototypes -Wnested-externs -Winline   -funroll-loops  -Wundef -Wstrict-prototypes -Wmissing-prototypes -Wmissing-declarations -Wredundant-decls -Wcast-align        -pthread -O2 -ggdb3 -m64 -I /u01/app/oracle/product/11.2.0.4/db/rdbms/public -MT libsbscript_a-script_lua.o -MD -MP -MF .deps/libsbscript_a-script_lua.Tpo -c -o libsbscript_a-script_lua.o `test -f 'script_lua.c' || echo './'`script_lua.c
mv -f .deps/libsbscript_a-sb_script.Tpo .deps/libsbscript_a-sb_script.Po
mv -f .deps/libsbscript_a-script_lua.Tpo .deps/libsbscript_a-script_lua.Po
rm -f libsbscript.a
ar cru libsbscript.a libsbscript_a-sb_script.o libsbscript_a-script_lua.o
ranlib libsbscript.a
make[3]: Leaving directory `/sysbench-0.5/sysbench/scripting'
make[2]: Leaving directory `/sysbench-0.5/sysbench/scripting'
Making all in .
make[2]: Entering directory `/sysbench-0.5/sysbench'
cc -DHAVE_CONFIG_H -I. -I../config  -I../sysbench -D_XOPEN_SOURCE=500 -D_GNU_SOURCE  -W -Wall -Wextra -Wpointer-arith -Wbad-function-cast   -Wstrict-prototypes -Wnested-externs -Winline   -funroll-loops  -Wundef -Wstrict-prototypes -Wmissing-prototypes -Wmissing-declarations -Wredundant-decls -Wcast-align        -pthread -O2 -ggdb3 -m64 -I /u01/app/oracle/product/11.2.0.4/db/rdbms/public -MT sysbench.o -MD -MP -MF .deps/sysbench.Tpo -c -o sysbench.o sysbench.c
cc -DHAVE_CONFIG_H -I. -I../config  -I../sysbench -D_XOPEN_SOURCE=500 -D_GNU_SOURCE  -W -Wall -Wextra -Wpointer-arith -Wbad-function-cast   -Wstrict-prototypes -Wnested-externs -Winline   -funroll-loops  -Wundef -Wstrict-prototypes -Wmissing-prototypes -Wmissing-declarations -Wredundant-decls -Wcast-align        -pthread -O2 -ggdb3 -m64 -I /u01/app/oracle/product/11.2.0.4/db/rdbms/public -MT sb_timer.o -MD -MP -MF .deps/sb_timer.Tpo -c -o sb_timer.o sb_timer.c
cc -DHAVE_CONFIG_H -I. -I../config  -I../sysbench -D_XOPEN_SOURCE=500 -D_GNU_SOURCE  -W -Wall -Wextra -Wpointer-arith -Wbad-function-cast   -Wstrict-prototypes -Wnested-externs -Winline   -funroll-loops  -Wundef -Wstrict-prototypes -Wmissing-prototypes -Wmissing-declarations -Wredundant-decls -Wcast-align        -pthread -O2 -ggdb3 -m64 -I /u01/app/oracle/product/11.2.0.4/db/rdbms/public -MT sb_options.o -MD -MP -MF .deps/sb_options.Tpo -c -o sb_options.o sb_options.c
cc -DHAVE_CONFIG_H -I. -I../config  -I../sysbench -D_XOPEN_SOURCE=500 -D_GNU_SOURCE  -W -Wall -Wextra -Wpointer-arith -Wbad-function-cast   -Wstrict-prototypes -Wnested-externs -Winline   -funroll-loops  -Wundef -Wstrict-prototypes -Wmissing-prototypes -Wmissing-declarations -Wredundant-decls -Wcast-align        -pthread -O2 -ggdb3 -m64 -I /u01/app/oracle/product/11.2.0.4/db/rdbms/public -MT sb_logger.o -MD -MP -MF .deps/sb_logger.Tpo -c -o sb_logger.o sb_logger.c
mv -f .deps/sb_timer.Tpo .deps/sb_timer.Po
cc -DHAVE_CONFIG_H -I. -I../config  -I../sysbench -D_XOPEN_SOURCE=500 -D_GNU_SOURCE  -W -Wall -Wextra -Wpointer-arith -Wbad-function-cast   -Wstrict-prototypes -Wnested-externs -Winline   -funroll-loops  -Wundef -Wstrict-prototypes -Wmissing-prototypes -Wmissing-declarations -Wredundant-decls -Wcast-align        -pthread -O2 -ggdb3 -m64 -I /u01/app/oracle/product/11.2.0.4/db/rdbms/public -MT db_driver.o -MD -MP -MF .deps/db_driver.Tpo -c -o db_driver.o db_driver.c
mv -f .deps/sb_logger.Tpo .deps/sb_logger.Po
cc -DHAVE_CONFIG_H -I. -I../config  -I../sysbench -D_XOPEN_SOURCE=500 -D_GNU_SOURCE  -W -Wall -Wextra -Wpointer-arith -Wbad-function-cast   -Wstrict-prototypes -Wnested-externs -Winline   -funroll-loops  -Wundef -Wstrict-prototypes -Wmissing-prototypes -Wmissing-declarations -Wredundant-decls -Wcast-align        -pthread -O2 -ggdb3 -m64 -I /u01/app/oracle/product/11.2.0.4/db/rdbms/public -MT sb_percentile.o -MD -MP -MF .deps/sb_percentile.Tpo -c -o sb_percentile.o sb_percentile.c
mv -f .deps/sb_options.Tpo .deps/sb_options.Po
cc -DHAVE_CONFIG_H -I. -I../config  -I../sysbench -D_XOPEN_SOURCE=500 -D_GNU_SOURCE  -W -Wall -Wextra -Wpointer-arith -Wbad-function-cast   -Wstrict-prototypes -Wnested-externs -Winline   -funroll-loops  -Wundef -Wstrict-prototypes -Wmissing-prototypes -Wmissing-declarations -Wredundant-decls -Wcast-align        -pthread -O2 -ggdb3 -m64 -I /u01/app/oracle/product/11.2.0.4/db/rdbms/public -MT sb_barrier.o -MD -MP -MF .deps/sb_barrier.Tpo -c -o sb_barrier.o sb_barrier.c
mv -f .deps/sb_barrier.Tpo .deps/sb_barrier.Po
mv -f .deps/sb_percentile.Tpo .deps/sb_percentile.Po
mv -f .deps/sysbench.Tpo .deps/sysbench.Po
mv -f .deps/db_driver.Tpo .deps/db_driver.Po
/bin/sh ../libtool --tag=CC   --mode=link cc -W -Wall -Wextra -Wpointer-arith -Wbad-function-cast   -Wstrict-prototypes -Wnested-externs -Winline   -funroll-loops  -Wundef -Wstrict-prototypes -Wmissing-prototypes -Wmissing-declarations -Wredundant-decls -Wcast-align        -pthread -O2 -ggdb3 -m64 -I /u01/app/oracle/product/11.2.0.4/db/rdbms/public       -L/u01/app/oracle/product/11.2.0.4/db/lib -o sysbench sysbench.o sb_timer.o sb_options.o sb_logger.o db_driver.o sb_percentile.o sb_barrier.o tests/fileio/libsbfileio.a tests/threads/libsbthreads.a tests/memory/libsbmemory.a tests/cpu/libsbcpu.a tests/mutex/libsbmutex.a scripting/libsbscript.a     drivers/oracle/libsboracle.a /u01/app/oracle/product/11.2.0.4/db/lib/libclntsh.so scripting/lua/src/liblua.a -lm -ldl -lrt -laio -lm
libtool: link: cc -W -Wall -Wextra -Wpointer-arith -Wbad-function-cast -Wstrict-prototypes -Wnested-externs -Winline -funroll-loops -Wundef -Wstrict-prototypes -Wmissing-prototypes -Wmissing-declarations -Wredundant-decls -Wcast-align -pthread -O2 -ggdb3 -m64 -I /u01/app/oracle/product/11.2.0.4/db/rdbms/public -o sysbench sysbench.o sb_timer.o sb_options.o sb_logger.o db_driver.o sb_percentile.o sb_barrier.o /u01/app/oracle/product/11.2.0.4/db/lib/libclntsh.so  -L/u01/app/oracle/product/11.2.0.4/db/lib tests/fileio/libsbfileio.a tests/threads/libsbthreads.a tests/memory/libsbmemory.a tests/cpu/libsbcpu.a tests/mutex/libsbmutex.a scripting/libsbscript.a drivers/oracle/libsboracle.a scripting/lua/src/liblua.a -ldl -lrt -laio -lm -pthread
make[2]: Leaving directory `/sysbench-0.5/sysbench'
make[1]: Leaving directory `/sysbench-0.5/sysbench'
Making all in tests
make[1]: Entering directory `/sysbench-0.5/tests'
make[1]: Nothing to be done for `all'.
make[1]: Leaving directory `/sysbench-0.5/tests'
make[1]: Entering directory `/sysbench-0.5'
make[1]: Nothing to be done for `all-am'.
make[1]: Leaving directory `/sysbench-0.5'


[root@sjjh sysbench-0.5]# make install
Making install in doc
make[1]: Entering directory `/sysbench-0.5/doc'
Making install in xsl
make[2]: Entering directory `/sysbench-0.5/doc/xsl'
make[3]: Entering directory `/sysbench-0.5/doc/xsl'
make[3]: Nothing to be done for `install-exec-am'.
make[3]: Nothing to be done for `install-data-am'.
make[3]: Leaving directory `/sysbench-0.5/doc/xsl'
make[2]: Leaving directory `/sysbench-0.5/doc/xsl'
make[2]: Entering directory `/sysbench-0.5/doc'
make[3]: Entering directory `/sysbench-0.5/doc'
make[3]: Nothing to be done for `install-exec-am'.
test -z "/usr/local/share/doc/sysbench" || /bin/mkdir -p "/usr/local/share/doc/sysbench"
 /usr/bin/install -c -m 644 manual.html '/usr/local/share/doc/sysbench'
make[3]: Leaving directory `/sysbench-0.5/doc'
make[2]: Leaving directory `/sysbench-0.5/doc'
make[1]: Leaving directory `/sysbench-0.5/doc'
Making install in sysbench
make[1]: Entering directory `/sysbench-0.5/sysbench'
Making install in drivers
make[2]: Entering directory `/sysbench-0.5/sysbench/drivers'
Making install in oracle
make[3]: Entering directory `/sysbench-0.5/sysbench/drivers/oracle'
make[4]: Entering directory `/sysbench-0.5/sysbench/drivers/oracle'
make[4]: Nothing to be done for `install-exec-am'.
make[4]: Nothing to be done for `install-data-am'.
make[4]: Leaving directory `/sysbench-0.5/sysbench/drivers/oracle'
make[3]: Leaving directory `/sysbench-0.5/sysbench/drivers/oracle'
make[3]: Entering directory `/sysbench-0.5/sysbench/drivers'
make[4]: Entering directory `/sysbench-0.5/sysbench/drivers'
make[4]: Nothing to be done for `install-exec-am'.
make[4]: Nothing to be done for `install-data-am'.
make[4]: Leaving directory `/sysbench-0.5/sysbench/drivers'
make[3]: Leaving directory `/sysbench-0.5/sysbench/drivers'
make[2]: Leaving directory `/sysbench-0.5/sysbench/drivers'
Making install in tests
make[2]: Entering directory `/sysbench-0.5/sysbench/tests'
Making install in cpu
make[3]: Entering directory `/sysbench-0.5/sysbench/tests/cpu'
make[4]: Entering directory `/sysbench-0.5/sysbench/tests/cpu'
make[4]: Nothing to be done for `install-exec-am'.
make[4]: Nothing to be done for `install-data-am'.
make[4]: Leaving directory `/sysbench-0.5/sysbench/tests/cpu'
make[3]: Leaving directory `/sysbench-0.5/sysbench/tests/cpu'
Making install in fileio
make[3]: Entering directory `/sysbench-0.5/sysbench/tests/fileio'
make[4]: Entering directory `/sysbench-0.5/sysbench/tests/fileio'
make[4]: Nothing to be done for `install-exec-am'.
make[4]: Nothing to be done for `install-data-am'.
make[4]: Leaving directory `/sysbench-0.5/sysbench/tests/fileio'
make[3]: Leaving directory `/sysbench-0.5/sysbench/tests/fileio'
Making install in memory
make[3]: Entering directory `/sysbench-0.5/sysbench/tests/memory'
make[4]: Entering directory `/sysbench-0.5/sysbench/tests/memory'
make[4]: Nothing to be done for `install-exec-am'.
make[4]: Nothing to be done for `install-data-am'.
make[4]: Leaving directory `/sysbench-0.5/sysbench/tests/memory'
make[3]: Leaving directory `/sysbench-0.5/sysbench/tests/memory'
Making install in threads
make[3]: Entering directory `/sysbench-0.5/sysbench/tests/threads'
make[4]: Entering directory `/sysbench-0.5/sysbench/tests/threads'
make[4]: Nothing to be done for `install-exec-am'.
make[4]: Nothing to be done for `install-data-am'.
make[4]: Leaving directory `/sysbench-0.5/sysbench/tests/threads'
make[3]: Leaving directory `/sysbench-0.5/sysbench/tests/threads'
Making install in mutex
make[3]: Entering directory `/sysbench-0.5/sysbench/tests/mutex'
make[4]: Entering directory `/sysbench-0.5/sysbench/tests/mutex'
make[4]: Nothing to be done for `install-exec-am'.
make[4]: Nothing to be done for `install-data-am'.
make[4]: Leaving directory `/sysbench-0.5/sysbench/tests/mutex'
make[3]: Leaving directory `/sysbench-0.5/sysbench/tests/mutex'
Making install in db
make[3]: Entering directory `/sysbench-0.5/sysbench/tests/db'
make[4]: Entering directory `/sysbench-0.5/sysbench/tests/db'
make[4]: Nothing to be done for `install-exec-am'.
test -z "/usr/local/share/sysbench" || /bin/mkdir -p "/usr/local/share/sysbench"
 /usr/bin/install -c -m 644 common.lua delete.lua insert.lua bulk_insert.lua oltp.lua oltp_simple.lua parallel_prepare.lua select_random_points.lua select_random_ranges.lua select.lua update_index.lua update_non_index.lua '/usr/local/share/sysbench'
make[4]: Leaving directory `/sysbench-0.5/sysbench/tests/db'
make[3]: Leaving directory `/sysbench-0.5/sysbench/tests/db'
make[3]: Entering directory `/sysbench-0.5/sysbench/tests'
make[4]: Entering directory `/sysbench-0.5/sysbench/tests'
make[4]: Nothing to be done for `install-exec-am'.
make[4]: Nothing to be done for `install-data-am'.
make[4]: Leaving directory `/sysbench-0.5/sysbench/tests'
make[3]: Leaving directory `/sysbench-0.5/sysbench/tests'
make[2]: Leaving directory `/sysbench-0.5/sysbench/tests'
Making install in scripting
make[2]: Entering directory `/sysbench-0.5/sysbench/scripting'
Making install in lua
make[3]: Entering directory `/sysbench-0.5/sysbench/scripting/lua'
Making install in src
make[4]: Entering directory `/sysbench-0.5/sysbench/scripting/lua/src'
make[5]: Entering directory `/sysbench-0.5/sysbench/scripting/lua/src'
make[5]: Nothing to be done for `install-exec-am'.
make[5]: Nothing to be done for `install-data-am'.
make[5]: Leaving directory `/sysbench-0.5/sysbench/scripting/lua/src'
make[4]: Leaving directory `/sysbench-0.5/sysbench/scripting/lua/src'
make[4]: Entering directory `/sysbench-0.5/sysbench/scripting/lua'
make[5]: Entering directory `/sysbench-0.5/sysbench/scripting/lua'
make[5]: Nothing to be done for `install-exec-am'.
make[5]: Nothing to be done for `install-data-am'.
make[5]: Leaving directory `/sysbench-0.5/sysbench/scripting/lua'
make[4]: Leaving directory `/sysbench-0.5/sysbench/scripting/lua'
make[3]: Leaving directory `/sysbench-0.5/sysbench/scripting/lua'
Making install in .
make[3]: Entering directory `/sysbench-0.5/sysbench/scripting'
make[4]: Entering directory `/sysbench-0.5/sysbench/scripting'
make[4]: Nothing to be done for `install-exec-am'.
make[4]: Nothing to be done for `install-data-am'.
make[4]: Leaving directory `/sysbench-0.5/sysbench/scripting'
make[3]: Leaving directory `/sysbench-0.5/sysbench/scripting'
make[2]: Leaving directory `/sysbench-0.5/sysbench/scripting'
Making install in .
make[2]: Entering directory `/sysbench-0.5/sysbench'
make[3]: Entering directory `/sysbench-0.5/sysbench'
test -z "/usr/local/bin" || /bin/mkdir -p "/usr/local/bin"
  /bin/sh ../libtool   --mode=install /usr/bin/install -c sysbench '/usr/local/bin'
libtool: install: /usr/bin/install -c sysbench /usr/local/bin/sysbench
make[3]: Nothing to be done for `install-data-am'.
make[3]: Leaving directory `/sysbench-0.5/sysbench'
make[2]: Leaving directory `/sysbench-0.5/sysbench'
make[1]: Leaving directory `/sysbench-0.5/sysbench'
Making install in tests
make[1]: Entering directory `/sysbench-0.5/tests'
make[2]: Entering directory `/sysbench-0.5/tests'
make[2]: Nothing to be done for `install-exec-am'.
make    INSTALL_TO_DIR="/usr/local/share/sysbench/tests" install_test_files
make[3]: Entering directory `/sysbench-0.5/tests'
make[3]: Leaving directory `/sysbench-0.5/tests'
test -z "/usr/local/share/sysbench/tests" || /bin/mkdir -p "/usr/local/share/sysbench/tests"
 /usr/bin/install -c test_run.sh '/usr/local/share/sysbench/tests'
make[2]: Leaving directory `/sysbench-0.5/tests'
make[1]: Leaving directory `/sysbench-0.5/tests'
make[1]: Entering directory `/sysbench-0.5'
make[2]: Entering directory `/sysbench-0.5'
make[2]: Nothing to be done for `install-exec-am'.
make[2]: Nothing to be done for `install-data-am'.
make[2]: Leaving directory `/sysbench-0.5'
make[1]: Leaving directory `/sysbench-0.5'


[root@shard1 sysbench-0.5]# which sysbench
/usr/local/bin/sysbench

7.设置sysbench到path环境变量

[root@sjjh sysbench-0.5]# echo "export PATH=$PATH:/usr/local/sysbench/bin">>/etc/profile
[root@sjjh sysbench-0.5]# source /etc/profile

8.验证安装是否成功

[root@sjjh ~]# su - oracle
[oracle@sjjh ~]$ sysbench
Missing required command argument.
Usage:
  sysbench --test= [options]... 

Commands: prepare run cleanup help version

General options:
  --num-threads=N             number of threads to use [1]
  --max-requests=N            limit for total number of requests [10000]
  --max-time=N                limit for total execution time in seconds [0]
  --forced-shutdown=STRING    amount of time to wait after --max-time before forcing shutdown [off]
  --thread-stack-size=SIZE    size of stack per thread [64K]
  --tx-rate=N                 target transaction rate (tps) [0]
  --report-interval=N         periodically report intermediate statistics with a specified interval in seconds. 0 disables intermediate reports [0]
  --report-checkpoints=[LIST,...]dump full statistics and reset all counters at specified points in time. The argument is a list of comma-separated values representing the amount of time in seconds elapsed from start of test when report checkpoint(s) must be performed. Report checkpoints are off by default. []
  --test=STRING               test to run
  --debug=[on|off]            print more debugging info [off]
  --validate=[on|off]         perform validation checks where possible [off]
  --help=[on|off]             print help and exit
  --version=[on|off]          print version and exit [off]
  --rand-init=[on|off]        initialize random number generator [off]
  --rand-type=STRING          random numbers distribution {uniform,gaussian,special,pareto} [special]
  --rand-spec-iter=N          number of iterations used for numbers generation [12]
  --rand-spec-pct=N           percentage of values to be treated as 'special' (for special distribution) [1]
  --rand-spec-res=N           percentage of 'special' values to use (for special distribution) [75]
  --rand-seed=N               seed for random number generator, ignored when 0 [0]
  --rand-pareto-h=N           parameter h for pareto distibution [0.2]
  --config-file=FILENAME      File containing command line options

Log options:
  --verbosity=N      verbosity level {5 - debug, 0 - only critical messages} [3]

  --percentile=N      percentile rank of query response times to count [95]

General database options:

  --db-driver=STRING  specifies database driver to use ('help' to get list of available drivers)
  --db-ps-mode=STRING prepared statements usage mode {auto, disable} [auto]
  --db-debug=[on|off] print database-specific debug information [off]


Compiled-in database drivers:
  oracle - Oracle driver

oracle options:
  --oracle-user=STRING     Oracle user [sbtest]
  --oracle-password=STRING Oracle password []
  --oracle-db=STRING       Oracle database name [sbtest]

Compiled-in tests:
  fileio - File I/O test
  cpu - CPU performance test
  memory - Memory functions speed test
  threads - Threads subsystem performance test
  mutex - Mutex performance test

See 'sysbench --test= help' for a list of options for each test.

9.将.lua文件存储在sysbench-0.5/tests/db

[root@sjjh /]# unzip sysbench_lua-master.zip
Archive:  sysbench_lua-master.zip
f2ceb6cdf7315dbb8dd5f43d9c6757320a80a270
   creating: sysbench_lua-master/
  inflating: sysbench_lua-master/README.md
   creating: sysbench_lua-master/lua/
  inflating: sysbench_lua-master/lua/common.lua
  inflating: sysbench_lua-master/lua/delete.lua
  inflating: sysbench_lua-master/lua/insert.lua
  inflating: sysbench_lua-master/lua/oltp.lua
  inflating: sysbench_lua-master/lua/oltp_simple.lua
  inflating: sysbench_lua-master/lua/parallel_prepare.lua
  inflating: sysbench_lua-master/lua/select.lua
  inflating: sysbench_lua-master/lua/select_ora.lua
  inflating: sysbench_lua-master/lua/select_random_points.lua
  inflating: sysbench_lua-master/lua/select_random_ranges.lua
  inflating: sysbench_lua-master/lua/update_index.lua
  inflating: sysbench_lua-master/lua/update_index_ora.lua
  inflating: sysbench_lua-master/lua/update_index_pg_with_prepare.lua
  inflating: sysbench_lua-master/lua/update_index_with_commit.lua
  inflating: sysbench_lua-master/lua/update_non_index.lua
  inflating: sysbench_lua-master/lua/update_non_index_pg_with_prepare.lua
  inflating: sysbench_lua-master/lua/update_non_index_with_commit.lua

[root@sjjh db]# cd /sysbench_lua-master
[root@sjjh sysbench_lua-master]# ls
lua  README.md
[root@sjjh sysbench_lua-master]# cd lua
[root@sjjh lua]# ls -lrt
total 72
-rw-r--r--. 1 root root  595 Dec 18  2015 update_non_index_with_commit.lua
-rw-r--r--. 1 root root  640 Dec 18  2015 update_non_index_pg_with_prepare.lua
-rw-r--r--. 1 root root  552 Dec 18  2015 update_non_index.lua
-rw-r--r--. 1 root root  386 Dec 18  2015 update_index_with_commit.lua
-rw-r--r--. 1 root root  496 Dec 18  2015 update_index_pg_with_prepare.lua
-rw-r--r--. 1 root root  551 Dec 18  2015 update_index_ora.lua
-rw-r--r--. 1 root root  343 Dec 18  2015 update_index.lua
-rw-r--r--. 1 root root 4066 Dec 18  2015 select_random_ranges.lua
-rw-r--r--. 1 root root 3964 Dec 18  2015 select_random_points.lua
-rw-r--r--. 1 root root  526 Dec 18  2015 select_ora.lua
-rw-r--r--. 1 root root  343 Dec 18  2015 select.lua
-rw-r--r--. 1 root root  425 Dec 18  2015 parallel_prepare.lua
-rw-r--r--. 1 root root  342 Dec 18  2015 oltp_simple.lua
-rw-r--r--. 1 root root 3139 Dec 18  2015 oltp.lua
-rw-r--r--. 1 root root  830 Dec 18  2015 insert.lua
-rw-r--r--. 1 root root  340 Dec 18  2015 delete.lua
-rw-r--r--. 1 root root 4576 Dec 18  2015 common.lua

[root@sjjh lua]# cp *.lua  /sysbench-0.5/tests/db/
[root@sjjh lua]# cd /sysbench-0.5/tests/db/
[root@sjjh db]# ls -lrt
total 72
-rw-r--r--. 1 root root  830 Nov 10 12:18 insert.lua
-rw-r--r--. 1 root root  340 Nov 10 12:18 delete.lua
-rw-r--r--. 1 root root 4576 Nov 10 12:18 common.lua
-rw-r--r--. 1 root root  526 Nov 10 12:18 select_ora.lua
-rw-r--r--. 1 root root  343 Nov 10 12:18 select.lua
-rw-r--r--. 1 root root  425 Nov 10 12:18 parallel_prepare.lua
-rw-r--r--. 1 root root  342 Nov 10 12:18 oltp_simple.lua
-rw-r--r--. 1 root root 3139 Nov 10 12:18 oltp.lua
-rw-r--r--. 1 root root  640 Nov 10 12:18 update_non_index_pg_with_prepare.lua
-rw-r--r--. 1 root root  552 Nov 10 12:18 update_non_index.lua
-rw-r--r--. 1 root root  386 Nov 10 12:18 update_index_with_commit.lua
-rw-r--r--. 1 root root  496 Nov 10 12:18 update_index_pg_with_prepare.lua
-rw-r--r--. 1 root root  551 Nov 10 12:18 update_index_ora.lua
-rw-r--r--. 1 root root  343 Nov 10 12:18 update_index.lua
-rw-r--r--. 1 root root 4066 Nov 10 12:18 select_random_ranges.lua
-rw-r--r--. 1 root root 3964 Nov 10 12:18 select_random_points.lua
-rw-r--r--. 1 root root  595 Nov 10 12:18 update_non_index_with_commit.lua

测试
1.创建测试用户

SQL> create user sysbench identified by sysbench default tablespace users;

User created.

SQL> grant connect,resource,dba to sysbench;

Grant succeeded.

2.准备数据，lua文件需要指定绝对路径 需要进去oracle用户，并且数据库TNS配置在tnsnames.ora中

[oracle@sjjh admin]$ cat tnsnames.ora
sjjh =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.138.130.101)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = sjjh)(UR=A)
    )
  )

[oracle@sjjh admin]$ sysbench --test=/sysbench-0.5/tests/db/oltp.lua --db-driver=oracle --oltp-table-name=sysbench --oltp-table-size=250000 --oltp-tables-count=25 --oracle-db=sjjh --oracle-user=sysbench --oracle-password=sysbench --max-time=600 --max-requests=10000000 --num-threads=32 --report-interval=1 prepare
sysbench 0.5:  multi-threaded system evaluation benchmark

Creating table 'sbtest1'...
Inserting 250000 records into 'sbtest1'
Creating table 'sbtest2'...
Inserting 250000 records into 'sbtest2'
Creating table 'sbtest3'...
Inserting 250000 records into 'sbtest3'
Creating table 'sbtest4'...
Inserting 250000 records into 'sbtest4'
Creating table 'sbtest5'...
Inserting 250000 records into 'sbtest5'
Creating table 'sbtest6'...
Inserting 250000 records into 'sbtest6'
Creating table 'sbtest7'...
Inserting 250000 records into 'sbtest7'
Creating table 'sbtest8'...
Inserting 250000 records into 'sbtest8'
Creating table 'sbtest9'...
Inserting 250000 records into 'sbtest9'
Creating table 'sbtest10'...
Inserting 250000 records into 'sbtest10'
Creating table 'sbtest11'...
Inserting 250000 records into 'sbtest11'
Creating table 'sbtest12'...
Inserting 250000 records into 'sbtest12'
Creating table 'sbtest13'...
Inserting 250000 records into 'sbtest13'
Creating table 'sbtest14'...
Inserting 250000 records into 'sbtest14'
Creating table 'sbtest15'...
Inserting 250000 records into 'sbtest15'
Creating table 'sbtest16'...
Inserting 250000 records into 'sbtest16'
Creating table 'sbtest17'...
Inserting 250000 records into 'sbtest17'
Creating table 'sbtest18'...
Inserting 250000 records into 'sbtest18'
Creating table 'sbtest19'...
Inserting 250000 records into 'sbtest19'
Creating table 'sbtest20'...
Inserting 250000 records into 'sbtest20'
Creating table 'sbtest21'...
Inserting 250000 records into 'sbtest21'
Creating table 'sbtest22'...
Inserting 250000 records into 'sbtest22'
Creating table 'sbtest23'...
Inserting 250000 records into 'sbtest23'
Creating table 'sbtest24'...
Inserting 250000 records into 'sbtest24'
Creating table 'sbtest25'...
Inserting 250000 records into 'sbtest25'

[oracle@sjjh admin]$ sysbench --test=/sysbench-0.5/tests/db/oltp.lua --db-driver=oracle --oltp-table-name=sysbench --oltp-table-size=250000 --oltp-tables-count=25 --oracle-db=sjjh --oracle-user=sysbench --oracle-password=sysbench --max-time=600 --max-requests=10000000 --num-threads=32 --report-interval=1 run
sysbench 0.5:  multi-threaded system evaluation benchmark

Running the test with following options:
Number of threads: 32
Report intermediate results every 1 second(s)
Random number generator seed is 0 and will be ignored


Initializing worker threads...

Threads started!

[   1s] threads: 32, tps: 193.63, reads: 2939.43, writes: 792.50, response time: 381.18ms (95%), errors: 0.00, reconnects:  0.00
[   2s] threads: 32, tps: 254.03, reads: 3611.49, writes: 1015.14, response time: 181.98ms (95%), errors: 0.00, reconnects:  0.00
[   3s] threads: 32, tps: 267.99, reads: 3887.91, writes: 1105.97, response time: 156.17ms (95%), errors: 0.00, reconnects:  0.00
[   4s] threads: 32, tps: 295.00, reads: 3854.02, writes: 1129.00, response time: 150.21ms (95%), errors: 0.00, reconnects:  0.00
[   5s] threads: 32, tps: 270.00, reads: 3867.02, writes: 1105.00, response time: 153.39ms (95%), errors: 0.00, reconnects:  0.00
[   6s] threads: 32, tps: 271.00, reads: 3825.97, writes: 1099.99, response time: 153.76ms (95%), errors: 0.00, reconnects:  0.00
[   7s] threads: 32, tps: 267.01, reads: 3880.10, writes: 1091.03, response time: 174.88ms (95%), errors: 0.00, reconnects:  0.00
[   8s] threads: 32, tps: 289.99, reads: 4054.90, writes: 1143.97, response time: 141.61ms (95%), errors: 0.00, reconnects:  0.00
[   9s] threads: 32, tps: 279.00, reads: 3897.03, writes: 1127.01, response time: 190.62ms (95%), errors: 0.00, reconnects:  0.00
[  10s] threads: 32, tps: 268.00, reads: 3746.98, writes: 1074.99, response time: 201.17ms (95%), errors: 0.00, reconnects:  0.00
[  11s] threads: 32, tps: 297.99, reads: 3987.83, writes: 1136.95, response time: 147.84ms (95%), errors: 0.00, reconnects:  0.00
[  12s] threads: 32, tps: 297.01, reads: 4255.20, writes: 1208.06, response time: 142.07ms (95%), errors: 0.00, reconnects:  0.00
[  13s] threads: 32, tps: 304.96, reads: 4248.48, writes: 1225.85, response time: 145.12ms (95%), errors: 0.00, reconnects:  0.00
[  14s] threads: 32, tps: 296.04, reads: 4177.59, writes: 1185.17, response time: 144.60ms (95%), errors: 0.00, reconnects:  0.00
[  15s] threads: 32, tps: 302.99, reads: 4357.84, writes: 1256.95, response time: 148.51ms (95%), errors: 0.00, reconnects:  0.00
[  16s] threads: 32, tps: 298.01, reads: 4097.07, writes: 1166.02, response time: 194.31ms (95%), errors: 0.00, reconnects:  0.00
[  17s] threads: 32, tps: 311.00, reads: 4312.98, writes: 1202.99, response time: 132.82ms (95%), errors: 0.00, reconnects:  0.00
[  18s] threads: 32, tps: 274.00, reads: 3973.01, writes: 1202.00, response time: 151.43ms (95%), errors: 0.00, reconnects:  0.00
[  19s] threads: 32, tps: 300.00, reads: 4070.02, writes: 1101.01, response time: 179.71ms (95%), errors: 0.00, reconnects:  0.00
[  20s] threads: 32, tps: 306.00, reads: 4347.07, writes: 1270.02, response time: 144.78ms (95%), errors: 0.00, reconnects:  0.00
[  21s] threads: 32, tps: 285.00, reads: 3910.99, writes: 1075.00, response time: 177.94ms (95%), errors: 0.00, reconnects:  0.00
[  22s] threads: 32, tps: 302.99, reads: 4350.84, writes: 1249.96, response time: 151.79ms (95%), errors: 0.00, reconnects:  0.00
[  23s] threads: 32, tps: 313.01, reads: 4256.07, writes: 1261.02, response time: 141.78ms (95%), errors: 0.00, reconnects:  0.00
[  24s] threads: 32, tps: 300.01, reads: 4042.08, writes: 1155.02, response time: 160.58ms (95%), errors: 0.00, reconnects:  0.00
[  25s] threads: 32, tps: 318.00, reads: 4708.94, writes: 1304.98, response time: 123.46ms (95%), errors: 0.00, reconnects:  0.00
[  26s] threads: 32, tps: 318.99, reads: 4360.92, writes: 1260.98, response time: 142.24ms (95%), errors: 0.00, reconnects:  0.00
[  27s] threads: 32, tps: 316.01, reads: 4531.16, writes: 1281.05, response time: 128.56ms (95%), errors: 0.00, reconnects:  0.00
[  28s] threads: 32, tps: 307.00, reads: 4296.94, writes: 1279.98, response time: 163.10ms (95%), errors: 0.00, reconnects:  0.00
[  29s] threads: 32, tps: 293.00, reads: 4101.96, writes: 1156.99, response time: 196.06ms (95%), errors: 0.00, reconnects:  0.00
[  30s] threads: 32, tps: 309.00, reads: 4371.06, writes: 1274.02, response time: 132.46ms (95%), errors: 0.00, reconnects:  0.00
[  31s] threads: 32, tps: 289.00, reads: 3932.93, writes: 1111.98, response time: 206.17ms (95%), errors: 0.00, reconnects:  0.00
[  32s] threads: 32, tps: 334.00, reads: 4695.96, writes: 1307.99, response time: 130.22ms (95%), errors: 0.00, reconnects:  0.00
[  33s] threads: 32, tps: 280.01, reads: 3995.12, writes: 1176.03, response time: 206.73ms (95%), errors: 0.00, reconnects:  0.00
[  34s] threads: 32, tps: 334.00, reads: 4484.98, writes: 1291.99, response time: 142.07ms (95%), errors: 0.00, reconnects:  0.00
[  35s] threads: 32, tps: 319.00, reads: 4671.97, writes: 1322.99, response time: 122.95ms (95%), errors: 0.00, reconnects:  0.00
[  36s] threads: 32, tps: 308.00, reads: 4333.04, writes: 1261.01, response time: 126.72ms (95%), errors: 0.00, reconnects:  0.00
[  37s] threads: 32, tps: 332.97, reads: 4528.63, writes: 1255.90, response time: 156.03ms (95%), errors: 0.00, reconnects:  0.00
[  38s] threads: 32, tps: 336.02, reads: 4702.32, writes: 1304.09, response time: 128.59ms (95%), errors: 0.00, reconnects:  0.00
[  39s] threads: 32, tps: 323.00, reads: 4603.01, writes: 1349.00, response time: 129.99ms (95%), errors: 0.00, reconnects:  0.00
[  40s] threads: 32, tps: 341.91, reads: 4618.82, writes: 1338.66, response time: 130.96ms (95%), errors: 0.00, reconnects:  0.00
[  41s] threads: 32, tps: 305.07, reads: 4395.94, writes: 1218.26, response time: 171.76ms (95%), errors: 0.00, reconnects:  0.00
[  42s] threads: 32, tps: 321.01, reads: 4574.20, writes: 1343.06, response time: 123.02ms (95%), errors: 0.00, reconnects:  0.00
[  43s] threads: 32, tps: 319.01, reads: 4298.11, writes: 1215.03, response time: 141.82ms (95%), errors: 0.00, reconnects:  0.00
[  44s] threads: 32, tps: 314.99, reads: 4544.90, writes: 1282.97, response time: 144.39ms (95%), errors: 0.00, reconnects:  0.00
[  45s] threads: 32, tps: 287.00, reads: 4068.02, writes: 1217.01, response time: 191.77ms (95%), errors: 0.00, reconnects:  0.00
[  46s] threads: 32, tps: 340.98, reads: 4629.77, writes: 1246.94, response time: 135.96ms (95%), errors: 0.00, reconnects:  0.00
[  47s] threads: 32, tps: 325.01, reads: 4626.17, writes: 1306.05, response time: 123.76ms (95%), errors: 0.00, reconnects:  0.00
[  48s] threads: 32, tps: 341.00, reads: 4773.01, writes: 1428.00, response time: 123.24ms (95%), errors: 0.00, reconnects:  0.00
[  49s] threads: 32, tps: 343.00, reads: 4723.06, writes: 1314.02, response time: 120.61ms (95%), errors: 0.00, reconnects:  0.00
[  50s] threads: 32, tps: 328.00, reads: 4604.96, writes: 1352.99, response time: 137.88ms (95%), errors: 0.00, reconnects:  0.00
[  51s] threads: 32, tps: 330.99, reads: 4719.90, writes: 1344.97, response time: 135.92ms (95%), errors: 0.00, reconnects:  0.00
[  52s] threads: 32, tps: 360.00, reads: 4867.04, writes: 1399.01, response time: 123.61ms (95%), errors: 0.00, reconnects:  0.00
[  53s] threads: 32, tps: 298.01, reads: 4214.08, writes: 1208.02, response time: 168.76ms (95%), errors: 0.00, reconnects:  0.00
[  54s] threads: 32, tps: 343.89, reads: 4698.55, writes: 1331.59, response time: 130.07ms (95%), errors: 0.00, reconnects:  0.00
[  55s] threads: 32, tps: 275.08, reads: 4147.25, writes: 1211.37, response time: 185.11ms (95%), errors: 0.00, reconnects:  0.00
[  56s] threads: 32, tps: 309.01, reads: 4289.08, writes: 1182.02, response time: 153.57ms (95%), errors: 0.00, reconnects:  0.00
[  57s] threads: 32, tps: 322.99, reads: 4494.91, writes: 1264.98, response time: 179.28ms (95%), errors: 0.00, reconnects:  0.00
[  58s] threads: 32, tps: 300.00, reads: 4186.94, writes: 1222.98, response time: 154.91ms (95%), errors: 0.00, reconnects:  0.00
[  59s] threads: 32, tps: 335.00, reads: 4638.05, writes: 1286.01, response time: 151.15ms (95%), errors: 0.00, reconnects:  0.00
[  60s] threads: 32, tps: 310.01, reads: 4353.11, writes: 1263.03, response time: 184.89ms (95%), errors: 0.00, reconnects:  0.00
[  61s] threads: 32, tps: 318.99, reads: 4528.81, writes: 1278.95, response time: 168.71ms (95%), errors: 0.00, reconnects:  0.00
[  62s] threads: 32, tps: 337.00, reads: 4681.06, writes: 1338.02, response time: 147.62ms (95%), errors: 0.00, reconnects:  0.00
[  63s] threads: 32, tps: 345.00, reads: 4830.05, writes: 1361.02, response time: 130.69ms (95%), errors: 0.00, reconnects:  0.00
[  64s] threads: 32, tps: 332.00, reads: 4660.98, writes: 1386.99, response time: 123.87ms (95%), errors: 0.00, reconnects:  0.00
[  65s] threads: 32, tps: 317.00, reads: 4494.98, writes: 1300.99, response time: 173.26ms (95%), errors: 0.00, reconnects:  0.00
[  66s] threads: 32, tps: 341.00, reads: 4772.93, writes: 1339.98, response time: 128.52ms (95%), errors: 0.00, reconnects:  0.00
[  67s] threads: 32, tps: 300.01, reads: 4011.18, writes: 1163.05, response time: 140.13ms (95%), errors: 0.00, reconnects:  0.00
[  68s] threads: 32, tps: 309.00, reads: 4331.98, writes: 1222.99, response time: 238.46ms (95%), errors: 0.00, reconnects:  0.00
[  69s] threads: 32, tps: 322.99, reads: 4679.90, writes: 1329.97, response time: 169.26ms (95%), errors: 0.00, reconnects:  0.00
[  70s] threads: 32, tps: 353.93, reads: 4895.04, writes: 1354.73, response time: 118.89ms (95%), errors: 0.00, reconnects:  0.00
[  71s] threads: 32, tps: 339.07, reads: 4717.98, writes: 1373.28, response time: 131.87ms (95%), errors: 0.00, reconnects:  0.00
[  72s] threads: 32, tps: 322.00, reads: 4472.01, writes: 1309.00, response time: 149.71ms (95%), errors: 0.00, reconnects:  0.00
[  73s] threads: 32, tps: 308.00, reads: 4313.95, writes: 1234.99, response time: 146.92ms (95%), errors: 0.00, reconnects:  0.00
[  74s] threads: 32, tps: 335.00, reads: 4647.02, writes: 1307.01, response time: 133.78ms (95%), errors: 0.00, reconnects:  0.00
[  75s] threads: 32, tps: 356.00, reads: 4998.99, writes: 1427.00, response time: 121.78ms (95%), errors: 0.00, reconnects:  0.00
[  76s] threads: 32, tps: 347.00, reads: 4898.01, writes: 1390.00, response time: 124.47ms (95%), errors: 0.00, reconnects:  0.00
[  77s] threads: 32, tps: 353.00, reads: 4987.02, writes: 1425.01, response time: 121.78ms (95%), errors: 0.00, reconnects:  0.00
[  78s] threads: 32, tps: 320.00, reads: 4449.97, writes: 1303.99, response time: 208.91ms (95%), errors: 0.00, reconnects:  0.00
[  79s] threads: 32, tps: 348.00, reads: 4819.00, writes: 1363.00, response time: 122.21ms (95%), errors: 0.00, reconnects:  0.00
[  80s] threads: 32, tps: 297.00, reads: 4221.07, writes: 1220.02, response time: 166.90ms (95%), errors: 0.00, reconnects:  0.00
[  81s] threads: 32, tps: 328.99, reads: 4644.85, writes: 1303.96, response time: 137.80ms (95%), errors: 0.00, reconnects:  0.00
[  82s] threads: 32, tps: 327.97, reads: 4574.64, writes: 1316.90, response time: 148.86ms (95%), errors: 0.00, reconnects:  0.00
[  83s] threads: 32, tps: 344.04, reads: 4840.55, writes: 1351.15, response time: 130.69ms (95%), errors: 0.00, reconnects:  0.00
[  84s] threads: 32, tps: 351.98, reads: 4789.74, writes: 1399.92, response time: 124.80ms (95%), errors: 0.00, reconnects:  0.00
[  85s] threads: 32, tps: 296.01, reads: 4302.14, writes: 1249.04, response time: 166.55ms (95%), errors: 0.00, reconnects:  0.00
[  86s] threads: 32, tps: 332.99, reads: 4558.89, writes: 1279.97, response time: 146.13ms (95%), errors: 0.00, reconnects:  0.00
[  87s] threads: 32, tps: 323.01, reads: 4473.21, writes: 1291.06, response time: 154.86ms (95%), errors: 0.00, reconnects:  0.00
[  88s] threads: 32, tps: 345.00, reads: 4957.94, writes: 1396.98, response time: 129.79ms (95%), errors: 0.00, reconnects:  0.00
[  89s] threads: 32, tps: 327.00, reads: 4489.93, writes: 1285.98, response time: 136.00ms (95%), errors: 0.00, reconnects:  0.00
[  90s] threads: 32, tps: 362.01, reads: 5145.08, writes: 1453.02, response time: 115.08ms (95%), errors: 0.00, reconnects:  0.00
[  91s] threads: 32, tps: 350.00, reads: 4819.95, writes: 1391.99, response time: 142.80ms (95%), errors: 0.00, reconnects:  0.00
[  92s] threads: 32, tps: 310.00, reads: 4515.03, writes: 1325.01, response time: 157.81ms (95%), errors: 0.00, reconnects:  0.00
[  93s] threads: 32, tps: 312.00, reads: 4374.02, writes: 1267.01, response time: 133.26ms (95%), errors: 0.00, reconnects:  0.00
[  94s] threads: 32, tps: 340.00, reads: 4684.99, writes: 1254.00, response time: 222.26ms (95%), errors: 0.00, reconnects:  0.00
[  95s] threads: 32, tps: 349.00, reads: 4889.06, writes: 1410.02, response time: 121.85ms (95%), errors: 0.00, reconnects:  0.00
[  96s] threads: 32, tps: 343.99, reads: 4776.86, writes: 1383.96, response time: 135.47ms (95%), errors: 0.00, reconnects:  0.00
[  97s] threads: 32, tps: 341.01, reads: 4677.12, writes: 1340.04, response time: 136.28ms (95%), errors: 0.00, reconnects:  0.00
[  98s] threads: 32, tps: 313.00, reads: 4432.93, writes: 1280.98, response time: 172.80ms (95%), errors: 0.00, reconnects:  0.00
[  99s] threads: 32, tps: 358.00, reads: 4953.01, writes: 1383.00, response time: 121.81ms (95%), errors: 0.00, reconnects:  0.00
[ 100s] threads: 32, tps: 337.99, reads: 4868.87, writes: 1410.96, response time: 118.18ms (95%), errors: 0.00, reconnects:  0.00
[ 101s] threads: 32, tps: 339.01, reads: 4697.16, writes: 1301.04, response time: 132.66ms (95%), errors: 0.00, reconnects:  0.00
[ 102s] threads: 32, tps: 337.00, reads: 4741.97, writes: 1385.99, response time: 136.73ms (95%), errors: 0.00, reconnects:  0.00
[ 103s] threads: 32, tps: 316.00, reads: 4489.00, writes: 1296.00, response time: 178.95ms (95%), errors: 0.00, reconnects:  0.00
[ 104s] threads: 32, tps: 368.00, reads: 5075.99, writes: 1405.00, response time: 115.46ms (95%), errors: 0.00, reconnects:  0.00
[ 105s] threads: 32, tps: 356.00, reads: 4953.01, writes: 1445.00, response time: 121.81ms (95%), errors: 0.00, reconnects:  0.00
[ 106s] threads: 32, tps: 318.99, reads: 4472.89, writes: 1276.97, response time: 169.36ms (95%), errors: 0.00, reconnects:  0.00
[ 107s] threads: 32, tps: 351.84, reads: 4843.87, writes: 1412.38, response time: 140.00ms (95%), errors: 0.00, reconnects:  0.00
[ 108s] threads: 32, tps: 351.16, reads: 4884.20, writes: 1406.63, response time: 129.83ms (95%), errors: 0.00, reconnects:  0.00
[ 109s] threads: 32, tps: 355.00, reads: 5105.00, writes: 1428.00, response time: 119.86ms (95%), errors: 0.00, reconnects:  0.00
[ 110s] threads: 32, tps: 359.01, reads: 4830.14, writes: 1392.04, response time: 121.09ms (95%), errors: 0.00, reconnects:  0.00
[ 111s] threads: 32, tps: 353.00, reads: 5070.01, writes: 1424.00, response time: 118.72ms (95%), errors: 0.00, reconnects:  0.00
[ 112s] threads: 32, tps: 349.99, reads: 4980.91, writes: 1447.97, response time: 127.10ms (95%), errors: 0.00, reconnects:  0.00
[ 113s] threads: 32, tps: 318.01, reads: 4486.08, writes: 1242.02, response time: 175.66ms (95%), errors: 0.00, reconnects:  0.00
[ 114s] threads: 32, tps: 344.99, reads: 4861.91, writes: 1445.97, response time: 127.10ms (95%), errors: 0.00, reconnects:  0.00
[ 115s] threads: 32, tps: 320.00, reads: 4415.97, writes: 1188.99, response time: 160.05ms (95%), errors: 0.00, reconnects:  0.00
[ 116s] threads: 32, tps: 314.00, reads: 4468.96, writes: 1344.99, response time: 132.82ms (95%), errors: 0.00, reconnects:  0.00
[ 117s] threads: 32, tps: 369.01, reads: 5009.17, writes: 1426.05, response time: 143.18ms (95%), errors: 0.00, reconnects:  0.00
[ 118s] threads: 32, tps: 343.99, reads: 5002.89, writes: 1459.97, response time: 115.73ms (95%), errors: 0.00, reconnects:  0.00
[ 119s] threads: 32, tps: 343.00, reads: 4781.00, writes: 1327.00, response time: 173.21ms (95%), errors: 0.00, reconnects:  0.00
[ 120s] threads: 32, tps: 370.01, reads: 5124.11, writes: 1466.03, response time: 114.87ms (95%), errors: 0.00, reconnects:  0.00
[ 121s] threads: 32, tps: 319.99, reads: 4556.89, writes: 1333.97, response time: 141.48ms (95%), errors: 0.00, reconnects:  0.00
[ 122s] threads: 32, tps: 377.00, reads: 5042.00, writes: 1399.00, response time: 131.95ms (95%), errors: 0.00, reconnects:  0.00
[ 123s] threads: 32, tps: 304.01, reads: 4402.10, writes: 1228.03, response time: 203.54ms (95%), errors: 0.00, reconnects:  0.00
[ 124s] threads: 32, tps: 348.00, reads: 4917.02, writes: 1417.01, response time: 142.12ms (95%), errors: 0.00, reconnects:  0.00
[ 125s] threads: 32, tps: 374.00, reads: 5098.99, writes: 1463.00, response time: 116.78ms (95%), errors: 0.00, reconnects:  0.00
[ 126s] threads: 32, tps: 354.00, reads: 4958.01, writes: 1401.00, response time: 126.49ms (95%), errors: 0.00, reconnects:  0.00
[ 127s] threads: 32, tps: 361.99, reads: 5137.87, writes: 1496.96, response time: 120.36ms (95%), errors: 0.00, reconnects:  0.00
[ 128s] threads: 32, tps: 314.01, reads: 4457.09, writes: 1272.03, response time: 173.00ms (95%), errors: 0.00, reconnects:  0.00
[ 129s] threads: 32, tps: 326.00, reads: 4567.00, writes: 1303.00, response time: 165.95ms (95%), errors: 0.00, reconnects:  0.00
[ 130s] threads: 32, tps: 338.99, reads: 4750.89, writes: 1372.97, response time: 128.29ms (95%), errors: 0.00, reconnects:  0.00
[ 131s] threads: 32, tps: 365.96, reads: 5082.44, writes: 1440.84, response time: 138.59ms (95%), errors: 0.00, reconnects:  0.00
[ 132s] threads: 32, tps: 368.05, reads: 5083.68, writes: 1413.19, response time: 111.78ms (95%), errors: 0.00, reconnects:  0.00
[ 133s] threads: 32, tps: 368.95, reads: 5047.36, writes: 1473.81, response time: 119.97ms (95%), errors: 0.00, reconnects:  0.00
[ 134s] threads: 32, tps: 327.03, reads: 4749.51, writes: 1358.14, response time: 128.98ms (95%), errors: 0.00, reconnects:  0.00
[ 135s] threads: 32, tps: 348.01, reads: 4954.08, writes: 1429.02, response time: 130.69ms (95%), errors: 0.00, reconnects:  0.00
[ 136s] threads: 32, tps: 345.99, reads: 4696.93, writes: 1300.98, response time: 135.96ms (95%), errors: 0.00, reconnects:  0.00
[ 137s] threads: 32, tps: 346.00, reads: 4934.04, writes: 1438.01, response time: 133.86ms (95%), errors: 0.00, reconnects:  0.00
[ 138s] threads: 32, tps: 374.00, reads: 5179.06, writes: 1496.02, response time: 117.20ms (95%), errors: 0.00, reconnects:  0.00
[ 139s] threads: 32, tps: 350.99, reads: 4988.88, writes: 1385.97, response time: 118.72ms (95%), errors: 0.00, reconnects:  0.00
[ 140s] threads: 32, tps: 388.01, reads: 5286.12, writes: 1530.04, response time: 113.50ms (95%), errors: 0.00, reconnects:  0.00
[ 141s] threads: 32, tps: 347.99, reads: 5062.88, writes: 1492.97, response time: 119.11ms (95%), errors: 0.00, reconnects:  0.00
[ 142s] threads: 32, tps: 340.01, reads: 4637.12, writes: 1241.03, response time: 140.21ms (95%), errors: 0.00, reconnects:  0.00
[ 143s] threads: 32, tps: 320.99, reads: 4474.89, writes: 1288.97, response time: 154.73ms (95%), errors: 0.00, reconnects:  0.00
[ 144s] threads: 32, tps: 367.01, reads: 5105.10, writes: 1463.03, response time: 112.12ms (95%), errors: 0.00, reconnects:  0.00
[ 145s] threads: 32, tps: 360.99, reads: 4917.91, writes: 1443.97, response time: 120.40ms (95%), errors: 0.00, reconnects:  0.00
[ 146s] threads: 32, tps: 243.00, reads: 3641.00, writes: 1075.00, response time: 193.67ms (95%), errors: 0.00, reconnects:  0.00
[ 147s] threads: 32, tps: 317.00, reads: 4520.02, writes: 1293.01, response time: 126.72ms (95%), errors: 0.00, reconnects:  0.00
[ 148s] threads: 32, tps: 292.00, reads: 3823.97, writes: 1050.99, response time: 191.19ms (95%), errors: 0.00, reconnects:  0.00
[ 149s] threads: 32, tps: 221.01, reads: 3349.09, writes: 973.03, response time: 226.36ms (95%), errors: 0.00, reconnects:  0.00
[ 150s] threads: 32, tps: 360.99, reads: 4948.92, writes: 1355.98, response time: 116.53ms (95%), errors: 0.00, reconnects:  0.00
[ 151s] threads: 32, tps: 354.79, reads: 4965.10, writes: 1426.17, response time: 120.69ms (95%), errors: 0.00, reconnects:  0.00
[ 152s] threads: 32, tps: 292.17, reads: 4084.35, writes: 1164.67, response time: 194.25ms (95%), errors: 0.00, reconnects:  0.00
[ 153s] threads: 32, tps: 368.01, reads: 5193.12, writes: 1466.03, response time: 109.01ms (95%), errors: 0.00, reconnects:  0.00
[ 154s] threads: 32, tps: 360.00, reads: 5010.93, writes: 1445.98, response time: 118.47ms (95%), errors: 0.00, reconnects:  0.00
[ 155s] threads: 32, tps: 327.00, reads: 4531.95, writes: 1299.98, response time: 175.77ms (95%), errors: 0.00, reconnects:  0.00
[ 156s] threads: 32, tps: 348.99, reads: 4992.89, writes: 1422.97, response time: 125.74ms (95%), errors: 0.00, reconnects:  0.00
[ 157s] threads: 32, tps: 347.02, reads: 4815.23, writes: 1399.07, response time: 135.06ms (95%), errors: 0.00, reconnects:  0.00
[ 158s] threads: 32, tps: 389.00, reads: 5460.00, writes: 1531.00, response time: 107.32ms (95%), errors: 0.00, reconnects:  0.00
[ 159s] threads: 32, tps: 314.00, reads: 4373.00, writes: 1316.00, response time: 146.26ms (95%), errors: 0.00, reconnects:  0.00
[ 160s] threads: 32, tps: 380.99, reads: 5295.90, writes: 1465.97, response time: 112.83ms (95%), errors: 0.00, reconnects:  0.00
[ 161s] threads: 32, tps: 344.01, reads: 4851.08, writes: 1361.02, response time: 128.09ms (95%), errors: 0.00, reconnects:  0.00
[ 162s] threads: 32, tps: 347.00, reads: 4899.94, writes: 1484.98, response time: 129.41ms (95%), errors: 0.00, reconnects:  0.00
[ 163s] threads: 32, tps: 361.00, reads: 5078.00, writes: 1436.00, response time: 126.95ms (95%), errors: 0.00, reconnects:  0.00
[ 164s] threads: 32, tps: 302.00, reads: 4192.04, writes: 1170.01, response time: 179.81ms (95%), errors: 0.00, reconnects:  0.00
[ 165s] threads: 32, tps: 324.00, reads: 4407.02, writes: 1259.01, response time: 185.72ms (95%), errors: 0.00, reconnects:  0.00
[ 166s] threads: 32, tps: 334.00, reads: 4688.01, writes: 1315.00, response time: 147.62ms (95%), errors: 0.00, reconnects:  0.00
[ 167s] threads: 32, tps: 364.00, reads: 5177.99, writes: 1504.00, response time: 118.43ms (95%), errors: 0.00, reconnects:  0.00
[ 168s] threads: 32, tps: 331.00, reads: 4674.01, writes: 1298.00, response time: 140.05ms (95%), errors: 0.00, reconnects:  0.00
[ 169s] threads: 32, tps: 354.96, reads: 4924.44, writes: 1454.83, response time: 136.24ms (95%), errors: 0.00, reconnects:  0.00
[ 170s] threads: 32, tps: 358.03, reads: 5118.49, writes: 1483.14, response time: 118.15ms (95%), errors: 0.00, reconnects:  0.00
[ 171s] threads: 32, tps: 352.00, reads: 4882.95, writes: 1352.99, response time: 132.50ms (95%), errors: 0.00, reconnects:  0.00
[ 172s] threads: 32, tps: 377.01, reads: 5209.15, writes: 1507.04, response time: 107.71ms (95%), errors: 0.00, reconnects:  0.00
[ 173s] threads: 32, tps: 372.98, reads: 5084.79, writes: 1459.94, response time: 117.58ms (95%), errors: 0.00, reconnects:  0.00
[ 174s] threads: 32, tps: 315.01, reads: 4669.11, writes: 1368.03, response time: 136.16ms (95%), errors: 0.00, reconnects:  0.00
[ 175s] threads: 32, tps: 355.00, reads: 4941.03, writes: 1405.01, response time: 147.67ms (95%), errors: 0.00, reconnects:  0.00
[ 176s] threads: 32, tps: 361.00, reads: 5064.04, writes: 1398.01, response time: 118.93ms (95%), errors: 0.00, reconnects:  0.00
[ 177s] threads: 32, tps: 370.00, reads: 5096.01, writes: 1417.00, response time: 120.15ms (95%), errors: 0.00, reconnects:  0.00
[ 178s] threads: 32, tps: 379.00, reads: 5254.02, writes: 1551.01, response time: 111.68ms (95%), errors: 0.00, reconnects:  0.00
[ 179s] threads: 32, tps: 333.99, reads: 4752.86, writes: 1383.96, response time: 150.39ms (95%), errors: 0.00, reconnects:  0.00
[ 180s] threads: 32, tps: 378.00, reads: 5328.00, writes: 1505.00, response time: 107.55ms (95%), errors: 0.00, reconnects:  0.00
[ 181s] threads: 32, tps: 395.01, reads: 5419.13, writes: 1515.04, response time: 106.97ms (95%), errors: 0.00, reconnects:  0.00
[ 182s] threads: 32, tps: 359.95, reads: 5037.36, writes: 1476.81, response time: 126.49ms (95%), errors: 0.00, reconnects:  0.00
[ 183s] threads: 32, tps: 335.03, reads: 4836.50, writes: 1386.14, response time: 127.22ms (95%), errors: 0.00, reconnects:  0.00
[ 184s] threads: 32, tps: 362.01, reads: 4945.12, writes: 1400.03, response time: 129.99ms (95%), errors: 0.00, reconnects:  0.00
[ 185s] threads: 32, tps: 325.99, reads: 4654.88, writes: 1294.97, response time: 133.62ms (95%), errors: 0.00, reconnects:  0.00
[ 186s] threads: 32, tps: 352.00, reads: 4969.03, writes: 1495.01, response time: 120.40ms (95%), errors: 0.00, reconnects:  0.00
[ 187s] threads: 32, tps: 330.00, reads: 4480.00, writes: 1221.00, response time: 180.03ms (95%), errors: 0.00, reconnects:  0.00
[ 188s] threads: 32, tps: 333.99, reads: 4487.83, writes: 1322.95, response time: 170.13ms (95%), errors: 0.00, reconnects:  0.00
[ 189s] threads: 32, tps: 357.02, reads: 5295.31, writes: 1488.09, response time: 119.11ms (95%), errors: 0.00, reconnects:  0.00
[ 190s] threads: 32, tps: 365.98, reads: 5046.71, writes: 1458.92, response time: 141.06ms (95%), errors: 0.00, reconnects:  0.00
[ 191s] threads: 32, tps: 340.01, reads: 4868.21, writes: 1417.06, response time: 113.67ms (95%), errors: 0.00, reconnects:  0.00
[ 192s] threads: 32, tps: 393.00, reads: 5283.04, writes: 1496.01, response time: 175.30ms (95%), errors: 0.00, reconnects:  0.00
[ 193s] threads: 32, tps: 353.00, reads: 5133.03, writes: 1436.01, response time: 125.03ms (95%), errors: 0.00, reconnects:  0.00
[ 194s] threads: 32, tps: 378.90, reads: 5276.55, writes: 1512.58, response time: 122.65ms (95%), errors: 0.00, reconnects:  0.00
[ 195s] threads: 32, tps: 376.10, reads: 5191.42, writes: 1458.40, response time: 115.56ms (95%), errors: 0.00, reconnects:  0.00
[ 196s] threads: 32, tps: 357.99, reads: 5046.86, writes: 1432.96, response time: 112.32ms (95%), errors: 0.00, reconnects:  0.00
[ 197s] threads: 32, tps: 344.01, reads: 4882.15, writes: 1407.04, response time: 127.86ms (95%), errors: 0.00, reconnects:  0.00
[ 198s] threads: 32, tps: 351.99, reads: 4934.84, writes: 1445.95, response time: 130.26ms (95%), errors: 0.00, reconnects:  0.00
[ 199s] threads: 32, tps: 342.01, reads: 4670.11, writes: 1294.03, response time: 163.24ms (95%), errors: 0.00, reconnects:  0.00
[ 200s] threads: 32, tps: 328.00, reads: 4497.00, writes: 1293.00, response time: 183.07ms (95%), errors: 0.00, reconnects:  0.00
[ 201s] threads: 32, tps: 330.99, reads: 4760.92, writes: 1396.98, response time: 166.80ms (95%), errors: 0.00, reconnects:  0.00
[ 202s] threads: 32, tps: 340.00, reads: 4760.00, writes: 1355.00, response time: 134.90ms (95%), errors: 0.00, reconnects:  0.00
[ 203s] threads: 32, tps: 352.00, reads: 4974.02, writes: 1390.01, response time: 134.34ms (95%), errors: 0.00, reconnects:  0.00
[ 204s] threads: 32, tps: 325.00, reads: 4576.07, writes: 1286.02, response time: 163.93ms (95%), errors: 0.00, reconnects:  0.00
[ 205s] threads: 32, tps: 355.00, reads: 4897.01, writes: 1388.00, response time: 119.93ms (95%), errors: 0.00, reconnects:  0.00
[ 206s] threads: 32, tps: 327.00, reads: 4633.00, writes: 1333.00, response time: 137.10ms (95%), errors: 0.00, reconnects:  0.00
[ 207s] threads: 32, tps: 387.00, reads: 5284.02, writes: 1533.01, response time: 113.78ms (95%), errors: 0.00, reconnects:  0.00
[ 208s] threads: 32, tps: 380.00, reads: 5446.96, writes: 1531.99, response time: 111.12ms (95%), errors: 0.00, reconnects:  0.00
[ 209s] threads: 32, tps: 379.99, reads: 5080.91, writes: 1494.97, response time: 115.01ms (95%), errors: 0.00, reconnects:  0.00
[ 210s] threads: 32, tps: 330.00, reads: 4919.03, writes: 1430.01, response time: 140.47ms (95%), errors: 0.00, reconnects:  0.00
[ 211s] threads: 32, tps: 366.00, reads: 4933.98, writes: 1412.99, response time: 119.14ms (95%), errors: 0.00, reconnects:  0.00
[ 212s] threads: 32, tps: 366.01, reads: 5259.11, writes: 1483.03, response time: 137.84ms (95%), errors: 0.00, reconnects:  0.00
[ 213s] threads: 32, tps: 397.99, reads: 5443.87, writes: 1521.96, response time: 107.84ms (95%), errors: 0.00, reconnects:  0.00
[ 214s] threads: 32, tps: 320.00, reads: 4568.04, writes: 1328.01, response time: 199.50ms (95%), errors: 0.00, reconnects:  0.00
[ 215s] threads: 32, tps: 380.00, reads: 5314.05, writes: 1488.01, response time: 115.77ms (95%), errors: 0.00, reconnects:  0.00
[ 216s] threads: 32, tps: 349.00, reads: 4963.03, writes: 1430.01, response time: 126.00ms (95%), errors: 0.00, reconnects:  0.00
[ 217s] threads: 32, tps: 321.99, reads: 4422.89, writes: 1248.97, response time: 185.94ms (95%), errors: 0.00, reconnects:  0.00
[ 218s] threads: 32, tps: 359.00, reads: 5013.03, writes: 1445.01, response time: 162.95ms (95%), errors: 0.00, reconnects:  0.00
[ 219s] threads: 32, tps: 366.00, reads: 5039.96, writes: 1438.99, response time: 115.28ms (95%), errors: 0.00, reconnects:  0.00
[ 220s] threads: 32, tps: 378.01, reads: 5367.14, writes: 1572.04, response time: 107.20ms (95%), errors: 0.00, reconnects:  0.00
[ 221s] threads: 32, tps: 380.99, reads: 5382.83, writes: 1468.95, response time: 109.50ms (95%), errors: 0.00, reconnects:  0.00
[ 222s] threads: 32, tps: 394.01, reads: 5502.16, writes: 1599.05, response time: 106.52ms (95%), errors: 0.00, reconnects:  0.00
[ 223s] threads: 32, tps: 364.99, reads: 5081.88, writes: 1447.97, response time: 127.98ms (95%), errors: 0.00, reconnects:  0.00
[ 224s] threads: 32, tps: 367.01, reads: 5104.12, writes: 1463.04, response time: 123.95ms (95%), errors: 0.00, reconnects:  0.00
[ 225s] threads: 32, tps: 336.00, reads: 4804.99, writes: 1366.00, response time: 154.73ms (95%), errors: 0.00, reconnects:  0.00
[ 226s] threads: 32, tps: 342.99, reads: 4787.86, writes: 1354.96, response time: 176.24ms (95%), errors: 0.00, reconnects:  0.00
[ 227s] threads: 32, tps: 356.00, reads: 5052.06, writes: 1518.02, response time: 113.67ms (95%), errors: 0.00, reconnects:  0.00
[ 228s] threads: 32, tps: 352.00, reads: 4781.99, writes: 1291.00, response time: 151.56ms (95%), errors: 0.00, reconnects:  0.00
[ 229s] threads: 32, tps: 381.00, reads: 5282.99, writes: 1540.00, response time: 109.99ms (95%), errors: 0.00, reconnects:  0.00
[ 230s] threads: 32, tps: 353.98, reads: 4951.72, writes: 1407.92, response time: 127.56ms (95%), errors: 0.00, reconnects:  0.00
[ 231s] threads: 32, tps: 351.02, reads: 5018.32, writes: 1431.09, response time: 136.16ms (95%), errors: 0.00, reconnects:  0.00
[ 232s] threads: 32, tps: 394.01, reads: 5438.09, writes: 1552.03, response time: 105.67ms (95%), errors: 0.00, reconnects:  0.00
[ 233s] threads: 32, tps: 375.94, reads: 5376.12, writes: 1575.74, response time: 112.79ms (95%), errors: 0.00, reconnects:  0.00
[ 234s] threads: 32, tps: 345.05, reads: 4748.70, writes: 1367.20, response time: 157.25ms (95%), errors: 0.00, reconnects:  0.00
[ 235s] threads: 32, tps: 366.00, reads: 4969.96, writes: 1420.99, response time: 146.13ms (95%), errors: 0.00, reconnects:  0.00
[ 236s] threads: 32, tps: 351.00, reads: 5127.01, writes: 1433.00, response time: 120.98ms (95%), errors: 0.00, reconnects:  0.00
[ 237s] threads: 32, tps: 392.01, reads: 5540.13, writes: 1578.04, response time: 105.32ms (95%), errors: 0.00, reconnects:  0.00
[ 238s] threads: 32, tps: 360.00, reads: 4950.01, writes: 1441.00, response time: 126.34ms (95%), errors: 0.00, reconnects:  0.00
[ 239s] threads: 32, tps: 352.99, reads: 4882.83, writes: 1349.95, response time: 140.51ms (95%), errors: 0.00, reconnects:  0.00
[ 240s] threads: 32, tps: 376.01, reads: 5290.08, writes: 1524.02, response time: 118.79ms (95%), errors: 0.00, reconnects:  0.00
[ 241s] threads: 32, tps: 338.00, reads: 4859.00, writes: 1413.00, response time: 145.69ms (95%), errors: 0.00, reconnects:  0.00
[ 242s] threads: 32, tps: 369.00, reads: 5111.00, writes: 1448.00, response time: 120.04ms (95%), errors: 0.00, reconnects:  0.00
[ 243s] threads: 32, tps: 355.00, reads: 5034.06, writes: 1462.02, response time: 133.38ms (95%), errors: 0.00, reconnects:  0.00
[ 244s] threads: 32, tps: 374.99, reads: 5166.93, writes: 1415.98, response time: 122.10ms (95%), errors: 0.00, reconnects:  0.00
[ 245s] threads: 32, tps: 338.01, reads: 4736.08, writes: 1368.02, response time: 132.30ms (95%), errors: 0.00, reconnects:  0.00
[ 246s] threads: 32, tps: 377.99, reads: 5261.93, writes: 1526.98, response time: 120.76ms (95%), errors: 0.00, reconnects:  0.00
[ 247s] threads: 32, tps: 336.01, reads: 4781.07, writes: 1364.02, response time: 174.56ms (95%), errors: 0.00, reconnects:  0.00
[ 248s] threads: 32, tps: 377.00, reads: 5224.01, writes: 1477.00, response time: 118.57ms (95%), errors: 0.00, reconnects:  0.00
[ 249s] threads: 32, tps: 355.00, reads: 5079.96, writes: 1510.99, response time: 115.11ms (95%), errors: 0.00, reconnects:  0.00
[ 250s] threads: 32, tps: 377.96, reads: 5149.49, writes: 1417.86, response time: 140.38ms (95%), errors: 0.00, reconnects:  0.00
[ 251s] threads: 32, tps: 338.03, reads: 4851.43, writes: 1387.12, response time: 188.52ms (95%), errors: 0.00, reconnects:  0.00
[ 252s] threads: 32, tps: 366.01, reads: 4935.11, writes: 1395.03, response time: 169.62ms (95%), errors: 0.00, reconnects:  0.00
[ 253s] threads: 32, tps: 316.99, reads: 4639.88, writes: 1379.96, response time: 158.86ms (95%), errors: 0.00, reconnects:  0.00
[ 254s] threads: 32, tps: 386.00, reads: 5337.01, writes: 1465.00, response time: 117.48ms (95%), errors: 0.00, reconnects:  0.00
[ 255s] threads: 32, tps: 343.00, reads: 4792.01, writes: 1370.00, response time: 183.79ms (95%), errors: 0.00, reconnects:  0.00
[ 256s] threads: 32, tps: 408.94, reads: 5645.21, writes: 1616.77, response time: 105.10ms (95%), errors: 0.00, reconnects:  0.00
[ 257s] threads: 32, tps: 359.06, reads: 5139.80, writes: 1487.23, response time: 121.70ms (95%), errors: 0.00, reconnects:  0.00
[ 258s] threads: 32, tps: 387.97, reads: 5441.53, writes: 1527.87, response time: 108.94ms (95%), errors: 0.00, reconnects:  0.00
[ 259s] threads: 32, tps: 388.03, reads: 5408.37, writes: 1597.11, response time: 107.49ms (95%), errors: 0.00, reconnects:  0.00
[ 260s] threads: 32, tps: 363.00, reads: 5100.98, writes: 1415.99, response time: 125.93ms (95%), errors: 0.00, reconnects:  0.00
[ 261s] threads: 32, tps: 405.01, reads: 5593.13, writes: 1587.04, response time: 107.29ms (95%), errors: 0.00, reconnects:  0.00
[ 262s] threads: 32, tps: 388.88, reads: 5202.41, writes: 1540.53, response time: 147.71ms (95%), errors: 0.00, reconnects:  0.00
[ 263s] threads: 32, tps: 379.11, reads: 5549.63, writes: 1588.47, response time: 109.20ms (95%), errors: 0.00, reconnects:  0.00
[ 264s] threads: 32, tps: 345.00, reads: 4955.98, writes: 1436.00, response time: 128.21ms (95%), errors: 0.00, reconnects:  0.00
[ 265s] threads: 32, tps: 387.01, reads: 5352.08, writes: 1440.02, response time: 120.69ms (95%), errors: 0.00, reconnects:  0.00
[ 266s] threads: 32, tps: 401.98, reads: 5456.79, writes: 1587.94, response time: 111.58ms (95%), errors: 0.00, reconnects:  0.00
[ 267s] threads: 32, tps: 363.00, reads: 5267.05, writes: 1543.02, response time: 116.74ms (95%), errors: 0.00, reconnects:  0.00
[ 268s] threads: 32, tps: 358.01, reads: 4943.15, writes: 1361.04, response time: 174.82ms (95%), errors: 0.00, reconnects:  0.00
[ 269s] threads: 32, tps: 375.99, reads: 5368.85, writes: 1580.95, response time: 109.43ms (95%), errors: 0.00, reconnects:  0.00
[ 270s] threads: 32, tps: 407.00, reads: 5591.01, writes: 1536.00, response time: 113.16ms (95%), errors: 0.00, reconnects:  0.00
[ 271s] threads: 32, tps: 388.00, reads: 5447.05, writes: 1579.01, response time: 105.19ms (95%), errors: 0.00, reconnects:  0.00
[ 272s] threads: 32, tps: 344.99, reads: 4747.80, writes: 1390.94, response time: 147.80ms (95%), errors: 0.00, reconnects:  0.00
[ 273s] threads: 32, tps: 343.01, reads: 4918.14, writes: 1377.04, response time: 149.09ms (95%), errors: 0.00, reconnects:  0.00
[ 274s] threads: 32, tps: 337.00, reads: 4764.07, writes: 1397.02, response time: 127.67ms (95%), errors: 0.00, reconnects:  0.00
[ 275s] threads: 32, tps: 390.99, reads: 5451.89, writes: 1510.97, response time: 118.33ms (95%), errors: 0.00, reconnects:  0.00
[ 276s] threads: 32, tps: 336.00, reads: 4754.00, writes: 1428.00, response time: 167.95ms (95%), errors: 0.00, reconnects:  0.00
[ 277s] threads: 32, tps: 320.01, reads: 4231.13, writes: 1152.04, response time: 156.50ms (95%), errors: 0.00, reconnects:  0.00
[ 278s] threads: 32, tps: 349.99, reads: 5044.91, writes: 1443.97, response time: 117.34ms (95%), errors: 0.00, reconnects:  0.00
[ 279s] threads: 32, tps: 392.00, reads: 5502.04, writes: 1562.01, response time: 109.34ms (95%), errors: 0.00, reconnects:  0.00
[ 280s] threads: 32, tps: 396.00, reads: 5592.97, writes: 1574.99, response time: 112.89ms (95%), errors: 0.00, reconnects:  0.00
[ 281s] threads: 32, tps: 393.00, reads: 5416.94, writes: 1603.98, response time: 114.87ms (95%), errors: 0.00, reconnects:  0.00
[ 282s] threads: 32, tps: 373.01, reads: 5323.09, writes: 1533.03, response time: 115.25ms (95%), errors: 0.00, reconnects:  0.00
[ 283s] threads: 32, tps: 365.00, reads: 4963.98, writes: 1403.00, response time: 121.01ms (95%), errors: 0.00, reconnects:  0.00
[ 284s] threads: 32, tps: 294.95, reads: 4124.28, writes: 1178.79, response time: 163.58ms (95%), errors: 0.00, reconnects:  0.00
[ 285s] threads: 32, tps: 370.06, reads: 5205.90, writes: 1499.26, response time: 114.77ms (95%), errors: 0.00, reconnects:  0.00
[ 286s] threads: 32, tps: 389.01, reads: 5550.11, writes: 1546.03, response time: 108.03ms (95%), errors: 0.00, reconnects:  0.00
[ 287s] threads: 32, tps: 336.00, reads: 4502.95, writes: 1298.99, response time: 217.13ms (95%), errors: 0.00, reconnects:  0.00
[ 288s] threads: 32, tps: 337.00, reads: 4908.93, writes: 1355.98, response time: 144.00ms (95%), errors: 0.00, reconnects:  0.00
[ 289s] threads: 32, tps: 384.96, reads: 5382.48, writes: 1557.85, response time: 115.87ms (95%), errors: 0.00, reconnects:  0.00
[ 290s] threads: 32, tps: 344.04, reads: 4781.50, writes: 1360.14, response time: 175.24ms (95%), errors: 0.00, reconnects:  0.00
[ 291s] threads: 32, tps: 385.00, reads: 5367.99, writes: 1584.00, response time: 109.76ms (95%), errors: 0.00, reconnects:  0.00
[ 292s] threads: 32, tps: 375.00, reads: 5371.01, writes: 1564.00, response time: 104.07ms (95%), errors: 0.00, reconnects:  0.00
[ 293s] threads: 32, tps: 405.99, reads: 5578.89, writes: 1512.97, response time: 122.29ms (95%), errors: 0.00, reconnects:  0.00
[ 294s] threads: 32, tps: 377.79, reads: 5239.15, writes: 1512.18, response time: 114.73ms (95%), errors: 0.00, reconnects:  0.00
[ 295s] threads: 32, tps: 377.22, reads: 5375.13, writes: 1586.92, response time: 113.37ms (95%), errors: 0.00, reconnects:  0.00
[ 296s] threads: 32, tps: 320.00, reads: 4337.98, writes: 1201.99, response time: 167.85ms (95%), errors: 0.00, reconnects:  0.00
[ 297s] threads: 32, tps: 359.97, reads: 4927.64, writes: 1430.90, response time: 126.00ms (95%), errors: 0.00, reconnects:  0.00
[ 298s] threads: 32, tps: 374.03, reads: 5461.39, writes: 1568.11, response time: 110.98ms (95%), errors: 0.00, reconnects:  0.00
[ 299s] threads: 32, tps: 371.96, reads: 5235.40, writes: 1428.84, response time: 115.25ms (95%), errors: 0.00, reconnects:  0.00
[ 300s] threads: 32, tps: 389.04, reads: 5288.52, writes: 1556.15, response time: 110.52ms (95%), errors: 0.00, reconnects:  0.00
[ 301s] threads: 32, tps: 315.99, reads: 4350.84, writes: 1253.95, response time: 165.51ms (95%), errors: 0.00, reconnects:  0.00
[ 302s] threads: 32, tps: 331.01, reads: 4778.19, writes: 1318.05, response time: 161.20ms (95%), errors: 0.00, reconnects:  0.00
[ 303s] threads: 32, tps: 380.00, reads: 5329.02, writes: 1565.01, response time: 111.08ms (95%), errors: 0.00, reconnects:  0.00
[ 304s] threads: 32, tps: 376.00, reads: 5347.96, writes: 1492.99, response time: 122.58ms (95%), errors: 0.00, reconnects:  0.00
[ 305s] threads: 32, tps: 400.99, reads: 5589.88, writes: 1597.96, response time: 112.02ms (95%), errors: 0.00, reconnects:  0.00
[ 306s] threads: 32, tps: 377.02, reads: 5279.22, writes: 1496.06, response time: 115.49ms (95%), errors: 0.00, reconnects:  0.00
[ 307s] threads: 32, tps: 362.97, reads: 5040.65, writes: 1475.90, response time: 122.62ms (95%), errors: 0.00, reconnects:  0.00
[ 308s] threads: 32, tps: 380.02, reads: 5385.29, writes: 1523.08, response time: 112.69ms (95%), errors: 0.00, reconnects:  0.00
[ 309s] threads: 32, tps: 383.99, reads: 5311.92, writes: 1503.98, response time: 124.35ms (95%), errors: 0.00, reconnects:  0.00
[ 310s] threads: 32, tps: 381.00, reads: 5280.01, writes: 1532.00, response time: 109.43ms (95%), errors: 0.00, reconnects:  0.00
[ 311s] threads: 32, tps: 331.97, reads: 4788.55, writes: 1365.87, response time: 181.60ms (95%), errors: 0.00, reconnects:  0.00
[ 312s] threads: 32, tps: 367.04, reads: 5164.52, writes: 1507.15, response time: 118.61ms (95%), errors: 0.00, reconnects:  0.00
[ 313s] threads: 32, tps: 362.00, reads: 4896.05, writes: 1354.01, response time: 179.54ms (95%), errors: 0.00, reconnects:  0.00
[ 314s] threads: 32, tps: 338.00, reads: 4817.06, writes: 1383.02, response time: 147.31ms (95%), errors: 0.00, reconnects:  0.00
[ 315s] threads: 32, tps: 381.99, reads: 5402.88, writes: 1582.96, response time: 109.27ms (95%), errors: 0.00, reconnects:  0.00
[ 316s] threads: 32, tps: 401.00, reads: 5372.02, writes: 1518.00, response time: 109.86ms (95%), errors: 0.00, reconnects:  0.00
[ 317s] threads: 32, tps: 249.00, reads: 3766.02, writes: 1118.01, response time: 186.11ms (95%), errors: 0.00, reconnects:  0.00
[ 318s] threads: 32, tps: 298.99, reads: 4024.91, writes: 1131.97, response time: 153.11ms (95%), errors: 0.00, reconnects:  0.00
[ 319s] threads: 32, tps: 269.01, reads: 3866.09, writes: 1030.02, response time: 165.80ms (95%), errors: 0.00, reconnects:  0.00
[ 320s] threads: 32, tps: 248.00, reads: 3289.98, writes: 977.99, response time: 177.67ms (95%), errors: 0.00, reconnects:  0.00
[ 321s] threads: 32, tps: 220.00, reads: 3314.98, writes: 969.00, response time: 285.97ms (95%), errors: 0.00, reconnects:  0.00
[ 322s] threads: 32, tps: 246.01, reads: 3318.09, writes: 970.03, response time: 159.19ms (95%), errors: 0.00, reconnects:  0.00
[ 323s] threads: 32, tps: 255.00, reads: 3700.93, writes: 1064.98, response time: 174.93ms (95%), errors: 0.00, reconnects:  0.00
[ 324s] threads: 32, tps: 272.00, reads: 3558.00, writes: 992.00, response time: 200.09ms (95%), errors: 0.00, reconnects:  0.00
[ 325s] threads: 32, tps: 219.00, reads: 3297.02, writes: 935.01, response time: 218.11ms (95%), errors: 0.00, reconnects:  0.00
[ 326s] threads: 32, tps: 268.00, reads: 3771.97, writes: 1100.99, response time: 162.66ms (95%), errors: 0.00, reconnects:  0.00
[ 327s] threads: 32, tps: 179.00, reads: 2508.02, writes: 728.00, response time: 217.91ms (95%), errors: 0.00, reconnects:  0.00
[ 328s] threads: 32, tps: 280.00, reads: 3692.02, writes: 1004.01, response time: 196.65ms (95%), errors: 0.00, reconnects:  0.00
[ 329s] threads: 32, tps: 265.00, reads: 3897.93, writes: 1143.98, response time: 181.22ms (95%), errors: 0.00, reconnects:  0.00
[ 330s] threads: 32, tps: 275.00, reads: 3890.06, writes: 1132.02, response time: 151.93ms (95%), errors: 0.00, reconnects:  0.00
[ 331s] threads: 32, tps: 243.00, reads: 3401.97, writes: 970.99, response time: 179.92ms (95%), errors: 0.00, reconnects:  0.00
[ 332s] threads: 32, tps: 289.01, reads: 3886.08, writes: 1081.02, response time: 178.31ms (95%), errors: 0.00, reconnects:  0.00
[ 333s] threads: 32, tps: 211.00, reads: 3005.97, writes: 795.99, response time: 209.85ms (95%), errors: 0.00, reconnects:  0.00
[ 334s] threads: 32, tps: 211.00, reads: 3061.94, writes: 966.98, response time: 176.19ms (95%), errors: 0.00, reconnects:  0.00
[ 335s] threads: 32, tps: 206.00, reads: 2884.02, writes: 825.01, response time: 244.17ms (95%), errors: 0.00, reconnects:  0.00
[ 336s] threads: 32, tps: 246.00, reads: 3365.99, writes: 936.00, response time: 181.00ms (95%), errors: 0.00, reconnects:  0.00
[ 337s] threads: 32, tps: 225.00, reads: 3228.02, writes: 948.01, response time: 178.15ms (95%), errors: 0.00, reconnects:  0.00
[ 338s] threads: 32, tps: 218.99, reads: 2897.87, writes: 827.96, response time: 378.11ms (95%), errors: 0.00, reconnects:  0.00
[ 339s] threads: 32, tps: 222.01, reads: 3274.11, writes: 932.03, response time: 198.54ms (95%), errors: 0.00, reconnects:  0.00
[ 340s] threads: 32, tps: 237.01, reads: 3306.10, writes: 899.03, response time: 204.21ms (95%), errors: 0.00, reconnects:  0.00
[ 341s] threads: 32, tps: 274.00, reads: 3849.97, writes: 1139.99, response time: 169.16ms (95%), errors: 0.00, reconnects:  0.00
[ 342s] threads: 32, tps: 232.98, reads: 3032.74, writes: 844.93, response time: 199.56ms (95%), errors: 0.00, reconnects:  0.00
[ 343s] threads: 32, tps: 216.02, reads: 3253.26, writes: 959.08, response time: 182.91ms (95%), errors: 0.00, reconnects:  0.00
[ 344s] threads: 32, tps: 242.99, reads: 3401.90, writes: 972.97, response time: 201.17ms (95%), errors: 0.00, reconnects:  0.00
[ 345s] threads: 32, tps: 292.01, reads: 3945.17, writes: 1044.04, response time: 192.86ms (95%), errors: 0.00, reconnects:  0.00
[ 346s] threads: 32, tps: 225.00, reads: 3292.97, writes: 1023.99, response time: 185.67ms (95%), errors: 0.00, reconnects:  0.00
[ 347s] threads: 32, tps: 261.00, reads: 3520.97, writes: 959.99, response time: 190.85ms (95%), errors: 0.00, reconnects:  0.00
[ 348s] threads: 32, tps: 208.00, reads: 3045.01, writes: 914.00, response time: 214.29ms (95%), errors: 0.00, reconnects:  0.00
[ 349s] threads: 32, tps: 208.00, reads: 2902.95, writes: 787.99, response time: 221.40ms (95%), errors: 0.00, reconnects:  0.00
[ 350s] threads: 32, tps: 246.01, reads: 3240.11, writes: 902.03, response time: 203.05ms (95%), errors: 0.00, reconnects:  0.00
[ 351s] threads: 32, tps: 203.00, reads: 2903.94, writes: 811.98, response time: 243.22ms (95%), errors: 0.00, reconnects:  0.00
[ 352s] threads: 32, tps: 249.00, reads: 3637.01, writes: 1124.00, response time: 182.63ms (95%), errors: 0.00, reconnects:  0.00
[ 353s] threads: 32, tps: 258.99, reads: 3625.86, writes: 1034.96, response time: 171.05ms (95%), errors: 0.00, reconnects:  0.00
[ 354s] threads: 32, tps: 259.01, reads: 3626.08, writes: 1036.02, response time: 181.65ms (95%), errors: 0.00, reconnects:  0.00
[ 355s] threads: 32, tps: 258.00, reads: 3611.06, writes: 1019.02, response time: 211.04ms (95%), errors: 0.00, reconnects:  0.00
[ 356s] threads: 32, tps: 239.00, reads: 3334.98, writes: 909.99, response time: 198.13ms (95%), errors: 0.00, reconnects:  0.00
[ 357s] threads: 32, tps: 234.00, reads: 3288.02, writes: 996.01, response time: 217.72ms (95%), errors: 0.00, reconnects:  0.00
[ 358s] threads: 32, tps: 286.00, reads: 3991.97, writes: 1111.99, response time: 185.83ms (95%), errors: 0.00, reconnects:  0.00
[ 359s] threads: 32, tps: 274.00, reads: 3848.04, writes: 1128.01, response time: 148.78ms (95%), errors: 0.00, reconnects:  0.00
[ 360s] threads: 32, tps: 273.00, reads: 3807.99, writes: 1078.00, response time: 183.73ms (95%), errors: 0.00, reconnects:  0.00
[ 361s] threads: 32, tps: 324.00, reads: 4209.97, writes: 1205.99, response time: 154.54ms (95%), errors: 0.00, reconnects:  0.00
[ 362s] threads: 32, tps: 194.00, reads: 3038.02, writes: 856.00, response time: 330.56ms (95%), errors: 0.00, reconnects:  0.00
[ 363s] threads: 32, tps: 260.00, reads: 3580.99, writes: 1020.00, response time: 150.52ms (95%), errors: 0.00, reconnects:  0.00
[ 364s] threads: 32, tps: 305.00, reads: 4041.01, writes: 1144.00, response time: 148.91ms (95%), errors: 0.00, reconnects:  0.00
[ 365s] threads: 32, tps: 292.00, reads: 4388.98, writes: 1252.00, response time: 156.92ms (95%), errors: 0.00, reconnects:  0.00
[ 366s] threads: 32, tps: 237.00, reads: 3240.06, writes: 861.02, response time: 211.49ms (95%), errors: 0.00, reconnects:  0.00
[ 367s] threads: 32, tps: 257.00, reads: 3680.97, writes: 1149.99, response time: 162.17ms (95%), errors: 0.00, reconnects:  0.00
[ 368s] threads: 32, tps: 260.00, reads: 3634.01, writes: 989.00, response time: 184.61ms (95%), errors: 0.00, reconnects:  0.00
[ 369s] threads: 32, tps: 252.99, reads: 3497.93, writes: 1007.98, response time: 173.21ms (95%), errors: 0.00, reconnects:  0.00
[ 370s] threads: 32, tps: 281.00, reads: 3981.03, writes: 1173.01, response time: 142.71ms (95%), errors: 0.00, reconnects:  0.00
[ 371s] threads: 32, tps: 226.00, reads: 3009.06, writes: 811.02, response time: 212.69ms (95%), errors: 0.00, reconnects:  0.00
[ 372s] threads: 32, tps: 215.00, reads: 3167.93, writes: 958.98, response time: 237.53ms (95%), errors: 0.00, reconnects:  0.00
[ 373s] threads: 32, tps: 256.00, reads: 3577.94, writes: 1007.98, response time: 191.48ms (95%), errors: 0.00, reconnects:  0.00
[ 374s] threads: 32, tps: 215.01, reads: 3016.07, writes: 876.02, response time: 269.76ms (95%), errors: 0.00, reconnects:  0.00
[ 375s] threads: 32, tps: 292.01, reads: 3868.07, writes: 1041.02, response time: 181.38ms (95%), errors: 0.00, reconnects:  0.00
[ 376s] threads: 32, tps: 264.00, reads: 3849.99, writes: 1095.00, response time: 175.24ms (95%), errors: 0.00, reconnects:  0.00
[ 377s] threads: 32, tps: 275.99, reads: 3921.90, writes: 1152.97, response time: 152.84ms (95%), errors: 0.00, reconnects:  0.00
[ 378s] threads: 32, tps: 239.00, reads: 3322.03, writes: 940.01, response time: 225.21ms (95%), errors: 0.00, reconnects:  0.00
[ 379s] threads: 32, tps: 292.00, reads: 4030.93, writes: 1122.98, response time: 163.54ms (95%), errors: 0.00, reconnects:  0.00
[ 380s] threads: 32, tps: 240.00, reads: 3416.05, writes: 1041.02, response time: 182.42ms (95%), errors: 0.00, reconnects:  0.00
[ 381s] threads: 32, tps: 234.00, reads: 3309.02, writes: 956.00, response time: 225.95ms (95%), errors: 0.00, reconnects:  0.00
[ 382s] threads: 32, tps: 246.00, reads: 3307.00, writes: 881.00, response time: 197.36ms (95%), errors: 0.00, reconnects:  0.00
[ 383s] threads: 32, tps: 212.00, reads: 3105.00, writes: 947.00, response time: 204.33ms (95%), errors: 0.00, reconnects:  0.00
[ 384s] threads: 32, tps: 248.00, reads: 3472.00, writes: 995.00, response time: 188.75ms (95%), errors: 0.00, reconnects:  0.00
[ 385s] threads: 32, tps: 242.00, reads: 3385.99, writes: 960.00, response time: 200.87ms (95%), errors: 0.00, reconnects:  0.00
[ 386s] threads: 32, tps: 215.00, reads: 2958.04, writes: 775.01, response time: 244.82ms (95%), errors: 0.00, reconnects:  0.00
[ 387s] threads: 32, tps: 292.99, reads: 4129.92, writes: 1229.98, response time: 144.60ms (95%), errors: 0.00, reconnects:  0.00
[ 388s] threads: 32, tps: 227.00, reads: 3163.06, writes: 851.02, response time: 235.48ms (95%), errors: 0.00, reconnects:  0.00
[ 389s] threads: 32, tps: 247.00, reads: 3495.94, writes: 1075.98, response time: 162.61ms (95%), errors: 0.00, reconnects:  0.00
[ 390s] threads: 32, tps: 246.00, reads: 3213.02, writes: 889.00, response time: 212.06ms (95%), errors: 0.00, reconnects:  0.00
[ 391s] threads: 32, tps: 237.00, reads: 3327.04, writes: 972.01, response time: 203.90ms (95%), errors: 0.00, reconnects:  0.00
[ 392s] threads: 32, tps: 267.97, reads: 3836.54, writes: 1106.87, response time: 148.69ms (95%), errors: 0.00, reconnects:  0.00
[ 393s] threads: 32, tps: 277.03, reads: 4005.38, writes: 1136.11, response time: 172.38ms (95%), errors: 0.00, reconnects:  0.00
[ 394s] threads: 32, tps: 229.01, reads: 3122.08, writes: 811.02, response time: 188.75ms (95%), errors: 0.00, reconnects:  0.00
[ 395s] threads: 32, tps: 228.00, reads: 3059.00, writes: 922.00, response time: 207.47ms (95%), errors: 0.00, reconnects:  0.00
[ 396s] threads: 32, tps: 247.97, reads: 3572.62, writes: 975.90, response time: 206.17ms (95%), errors: 0.00, reconnects:  0.00
[ 397s] threads: 32, tps: 251.02, reads: 3640.29, writes: 1097.09, response time: 171.51ms (95%), errors: 0.00, reconnects:  0.00
[ 398s] threads: 32, tps: 217.01, reads: 3001.07, writes: 792.02, response time: 241.04ms (95%), errors: 0.00, reconnects:  0.00
[ 399s] threads: 32, tps: 265.00, reads: 3510.02, writes: 1059.01, response time: 173.63ms (95%), errors: 0.00, reconnects:  0.00
[ 400s] threads: 32, tps: 237.00, reads: 3326.98, writes: 983.99, response time: 193.32ms (95%), errors: 0.00, reconnects:  0.00
[ 401s] threads: 32, tps: 254.00, reads: 3786.97, writes: 1086.99, response time: 159.76ms (95%), errors: 0.00, reconnects:  0.00
[ 402s] threads: 32, tps: 267.00, reads: 3738.01, writes: 1068.00, response time: 170.94ms (95%), errors: 0.00, reconnects:  0.00
[ 403s] threads: 32, tps: 318.99, reads: 4457.89, writes: 1246.97, response time: 159.57ms (95%), errors: 0.00, reconnects:  0.00
[ 404s] threads: 32, tps: 262.01, reads: 3603.10, writes: 970.03, response time: 178.53ms (95%), errors: 0.00, reconnects:  0.00
[ 405s] threads: 32, tps: 234.00, reads: 3311.94, writes: 1017.98, response time: 235.83ms (95%), errors: 0.00, reconnects:  0.00
[ 406s] threads: 32, tps: 306.00, reads: 4304.97, writes: 1168.99, response time: 171.35ms (95%), errors: 0.00, reconnects:  0.00
[ 407s] threads: 32, tps: 265.99, reads: 3739.91, writes: 1143.97, response time: 150.39ms (95%), errors: 0.00, reconnects:  0.00
[ 408s] threads: 32, tps: 350.00, reads: 4769.03, writes: 1353.01, response time: 215.84ms (95%), errors: 0.00, reconnects:  0.00
[ 409s] threads: 32, tps: 339.01, reads: 4838.12, writes: 1355.03, response time: 135.39ms (95%), errors: 0.00, reconnects:  0.00
[ 410s] threads: 32, tps: 345.01, reads: 4735.11, writes: 1336.03, response time: 154.59ms (95%), errors: 0.00, reconnects:  0.00
[ 411s] threads: 32, tps: 321.99, reads: 4623.92, writes: 1352.98, response time: 150.61ms (95%), errors: 0.00, reconnects:  0.00
[ 412s] threads: 32, tps: 335.00, reads: 4708.02, writes: 1368.01, response time: 145.12ms (95%), errors: 0.00, reconnects:  0.00
[ 413s] threads: 32, tps: 307.99, reads: 4115.93, writes: 1174.98, response time: 169.62ms (95%), errors: 0.00, reconnects:  0.00
[ 414s] threads: 32, tps: 351.00, reads: 5039.98, writes: 1353.99, response time: 148.38ms (95%), errors: 0.00, reconnects:  0.00
[ 415s] threads: 32, tps: 323.01, reads: 4584.08, writes: 1390.02, response time: 155.84ms (95%), errors: 0.00, reconnects:  0.00
[ 416s] threads: 32, tps: 257.00, reads: 3605.99, writes: 1034.00, response time: 228.67ms (95%), errors: 0.00, reconnects:  0.00
[ 417s] threads: 32, tps: 385.01, reads: 5295.08, writes: 1458.02, response time: 140.68ms (95%), errors: 0.00, reconnects:  0.00
[ 418s] threads: 32, tps: 329.99, reads: 4685.92, writes: 1310.98, response time: 125.66ms (95%), errors: 0.00, reconnects:  0.00
[ 419s] threads: 32, tps: 386.01, reads: 5300.10, writes: 1523.03, response time: 123.10ms (95%), errors: 0.00, reconnects:  0.00
[ 420s] threads: 32, tps: 389.99, reads: 5430.84, writes: 1569.95, response time: 116.22ms (95%), errors: 0.00, reconnects:  0.00
[ 421s] threads: 32, tps: 305.01, reads: 4431.08, writes: 1312.02, response time: 175.30ms (95%), errors: 0.00, reconnects:  0.00
[ 422s] threads: 32, tps: 262.00, reads: 3666.98, writes: 1041.99, response time: 165.21ms (95%), errors: 0.00, reconnects:  0.00
[ 423s] threads: 32, tps: 327.99, reads: 4472.80, writes: 1233.94, response time: 147.31ms (95%), errors: 0.00, reconnects:  0.00
[ 424s] threads: 32, tps: 395.99, reads: 5570.85, writes: 1598.96, response time: 105.04ms (95%), errors: 0.00, reconnects:  0.00
[ 425s] threads: 32, tps: 389.03, reads: 5283.45, writes: 1532.13, response time: 137.39ms (95%), errors: 0.00, reconnects:  0.00
[ 426s] threads: 32, tps: 375.99, reads: 5397.90, writes: 1499.97, response time: 118.22ms (95%), errors: 0.00, reconnects:  0.00
[ 427s] threads: 32, tps: 288.00, reads: 4155.05, writes: 1260.01, response time: 170.84ms (95%), errors: 0.00, reconnects:  0.00
[ 428s] threads: 32, tps: 298.00, reads: 4107.05, writes: 1097.01, response time: 160.67ms (95%), errors: 0.00, reconnects:  0.00
[ 429s] threads: 32, tps: 368.00, reads: 5186.98, writes: 1503.99, response time: 124.28ms (95%), errors: 0.00, reconnects:  0.00
[ 430s] threads: 32, tps: 331.00, reads: 4588.93, writes: 1340.98, response time: 145.52ms (95%), errors: 0.00, reconnects:  0.00
[ 431s] threads: 32, tps: 381.01, reads: 5345.10, writes: 1496.03, response time: 114.56ms (95%), errors: 0.00, reconnects:  0.00
[ 432s] threads: 32, tps: 371.99, reads: 5249.84, writes: 1532.95, response time: 113.06ms (95%), errors: 0.00, reconnects:  0.00
[ 433s] threads: 32, tps: 313.00, reads: 4346.02, writes: 1182.01, response time: 148.29ms (95%), errors: 0.00, reconnects:  0.00
[ 434s] threads: 32, tps: 325.01, reads: 4556.11, writes: 1350.03, response time: 165.16ms (95%), errors: 0.00, reconnects:  0.00
[ 435s] threads: 32, tps: 404.00, reads: 5644.00, writes: 1593.00, response time: 105.86ms (95%), errors: 0.00, reconnects:  0.00
[ 436s] threads: 32, tps: 302.99, reads: 4305.91, writes: 1285.97, response time: 154.63ms (95%), errors: 0.00, reconnects:  0.00
[ 437s] threads: 32, tps: 311.00, reads: 4311.00, writes: 1154.00, response time: 161.83ms (95%), errors: 0.00, reconnects:  0.00
[ 438s] threads: 32, tps: 398.00, reads: 5538.97, writes: 1580.99, response time: 107.32ms (95%), errors: 0.00, reconnects:  0.00
[ 439s] threads: 32, tps: 323.00, reads: 4598.04, writes: 1391.01, response time: 141.31ms (95%), errors: 0.00, reconnects:  0.00
[ 440s] threads: 32, tps: 359.00, reads: 4912.04, writes: 1333.01, response time: 142.03ms (95%), errors: 0.00, reconnects:  0.00
[ 441s] threads: 32, tps: 379.00, reads: 5195.04, writes: 1540.01, response time: 131.79ms (95%), errors: 0.00, reconnects:  0.00
[ 442s] threads: 32, tps: 262.00, reads: 3757.98, writes: 1032.99, response time: 173.99ms (95%), errors: 0.00, reconnects:  0.00
[ 443s] threads: 32, tps: 289.00, reads: 4123.01, writes: 1184.00, response time: 181.82ms (95%), errors: 0.00, reconnects:  0.00
[ 444s] threads: 32, tps: 324.94, reads: 4482.17, writes: 1281.76, response time: 193.50ms (95%), errors: 0.00, reconnects:  0.00
[ 445s] threads: 32, tps: 294.04, reads: 4237.60, writes: 1216.17, response time: 175.93ms (95%), errors: 0.00, reconnects:  0.00
[ 446s] threads: 32, tps: 312.01, reads: 4177.20, writes: 1182.06, response time: 176.82ms (95%), errors: 0.00, reconnects:  0.00
[ 447s] threads: 32, tps: 353.99, reads: 5000.89, writes: 1422.97, response time: 162.51ms (95%), errors: 0.00, reconnects:  0.00
[ 448s] threads: 32, tps: 299.00, reads: 4281.06, writes: 1209.02, response time: 178.15ms (95%), errors: 0.00, reconnects:  0.00
[ 449s] threads: 32, tps: 290.00, reads: 3897.97, writes: 1134.99, response time: 169.31ms (95%), errors: 0.00, reconnects:  0.00
[ 450s] threads: 32, tps: 387.99, reads: 5597.82, writes: 1582.95, response time: 109.56ms (95%), errors: 0.00, reconnects:  0.00
[ 451s] threads: 32, tps: 348.97, reads: 4864.65, writes: 1398.90, response time: 152.56ms (95%), errors: 0.00, reconnects:  0.00
[ 452s] threads: 32, tps: 347.04, reads: 4869.49, writes: 1360.14, response time: 143.40ms (95%), errors: 0.00, reconnects:  0.00
[ 453s] threads: 32, tps: 402.00, reads: 5592.02, writes: 1605.01, response time: 114.19ms (95%), errors: 0.00, reconnects:  0.00
[ 454s] threads: 32, tps: 351.00, reads: 4770.01, writes: 1410.00, response time: 137.14ms (95%), errors: 0.00, reconnects:  0.00
[ 455s] threads: 32, tps: 331.00, reads: 4602.01, writes: 1320.00, response time: 141.90ms (95%), errors: 0.00, reconnects:  0.00
[ 456s] threads: 32, tps: 375.00, reads: 5331.04, writes: 1504.01, response time: 140.76ms (95%), errors: 0.00, reconnects:  0.00
[ 457s] threads: 32, tps: 265.99, reads: 3915.89, writes: 1169.97, response time: 207.91ms (95%), errors: 0.00, reconnects:  0.00
[ 458s] threads: 32, tps: 250.99, reads: 3513.82, writes: 1005.95, response time: 170.59ms (95%), errors: 0.00, reconnects:  0.00
[ 459s] threads: 32, tps: 300.01, reads: 4049.15, writes: 1149.04, response time: 211.36ms (95%), errors: 0.00, reconnects:  0.00
[ 460s] threads: 32, tps: 320.01, reads: 4609.19, writes: 1278.05, response time: 151.83ms (95%), errors: 0.00, reconnects:  0.00
[ 461s] threads: 32, tps: 219.00, reads: 3078.93, writes: 873.98, response time: 225.95ms (95%), errors: 0.00, reconnects:  0.00
[ 462s] threads: 32, tps: 227.00, reads: 3136.99, writes: 899.00, response time: 238.32ms (95%), errors: 0.00, reconnects:  0.00
[ 463s] threads: 32, tps: 298.01, reads: 4191.11, writes: 1151.03, response time: 156.36ms (95%), errors: 0.00, reconnects:  0.00
[ 464s] threads: 32, tps: 349.99, reads: 4841.89, writes: 1440.97, response time: 122.14ms (95%), errors: 0.00, reconnects:  0.00
[ 465s] threads: 32, tps: 390.01, reads: 5447.08, writes: 1545.02, response time: 112.19ms (95%), errors: 0.00, reconnects:  0.00
[ 466s] threads: 32, tps: 255.00, reads: 3671.98, writes: 1096.99, response time: 190.85ms (95%), errors: 0.00, reconnects:  0.00
[ 467s] threads: 32, tps: 344.00, reads: 4705.03, writes: 1275.01, response time: 131.83ms (95%), errors: 0.00, reconnects:  0.00
[ 468s] threads: 32, tps: 328.00, reads: 4679.00, writes: 1383.00, response time: 166.70ms (95%), errors: 0.00, reconnects:  0.00
[ 469s] threads: 32, tps: 356.00, reads: 4749.98, writes: 1327.99, response time: 169.97ms (95%), errors: 0.00, reconnects:  0.00
[ 470s] threads: 32, tps: 327.98, reads: 4716.75, writes: 1353.93, response time: 137.06ms (95%), errors: 0.00, reconnects:  0.00
[ 471s] threads: 32, tps: 333.01, reads: 4775.21, writes: 1382.06, response time: 210.10ms (95%), errors: 0.00, reconnects:  0.00
[ 472s] threads: 32, tps: 329.00, reads: 4622.05, writes: 1348.02, response time: 156.17ms (95%), errors: 0.00, reconnects:  0.00
[ 473s] threads: 32, tps: 318.00, reads: 4300.99, writes: 1160.00, response time: 131.00ms (95%), errors: 0.00, reconnects:  0.00
[ 474s] threads: 32, tps: 366.99, reads: 5279.91, writes: 1559.97, response time: 121.12ms (95%), errors: 0.00, reconnects:  0.00
[ 475s] threads: 32, tps: 392.01, reads: 5435.17, writes: 1485.05, response time: 106.46ms (95%), errors: 0.00, reconnects:  0.00
[ 476s] threads: 32, tps: 361.99, reads: 5016.81, writes: 1497.94, response time: 139.67ms (95%), errors: 0.00, reconnects:  0.00
[ 477s] threads: 32, tps: 382.01, reads: 5385.15, writes: 1470.04, response time: 118.50ms (95%), errors: 0.00, reconnects:  0.00
[ 478s] threads: 32, tps: 352.00, reads: 5007.95, writes: 1519.99, response time: 113.03ms (95%), errors: 0.00, reconnects:  0.00
[ 479s] threads: 32, tps: 258.96, reads: 3499.48, writes: 1001.85, response time: 177.30ms (95%), errors: 0.00, reconnects:  0.00
[ 480s] threads: 32, tps: 384.07, reads: 5340.93, writes: 1481.26, response time: 157.34ms (95%), errors: 0.00, reconnects:  0.00
[ 481s] threads: 32, tps: 362.99, reads: 5088.92, writes: 1466.98, response time: 134.74ms (95%), errors: 0.00, reconnects:  0.00
[ 482s] threads: 32, tps: 327.00, reads: 4576.06, writes: 1278.02, response time: 203.48ms (95%), errors: 0.00, reconnects:  0.00
[ 483s] threads: 32, tps: 390.93, reads: 5542.94, writes: 1573.70, response time: 111.08ms (95%), errors: 0.00, reconnects:  0.00
[ 484s] threads: 32, tps: 353.06, reads: 4681.85, writes: 1393.25, response time: 196.94ms (95%), errors: 0.00, reconnects:  0.00
[ 485s] threads: 32, tps: 219.95, reads: 3041.27, writes: 883.79, response time: 210.16ms (95%), errors: 0.00, reconnects:  0.00
[ 486s] threads: 32, tps: 209.05, reads: 3195.69, writes: 826.18, response time: 238.24ms (95%), errors: 0.00, reconnects:  0.00
[ 487s] threads: 32, tps: 373.01, reads: 5316.14, writes: 1578.04, response time: 110.19ms (95%), errors: 0.00, reconnects:  0.00
[ 488s] threads: 32, tps: 368.00, reads: 5136.02, writes: 1442.01, response time: 130.57ms (95%), errors: 0.00, reconnects:  0.00
[ 489s] threads: 32, tps: 401.98, reads: 5614.77, writes: 1593.93, response time: 112.83ms (95%), errors: 0.00, reconnects:  0.00
[ 490s] threads: 32, tps: 343.01, reads: 4854.19, writes: 1452.06, response time: 123.06ms (95%), errors: 0.00, reconnects:  0.00
[ 491s] threads: 32, tps: 275.98, reads: 3556.78, writes: 1011.94, response time: 183.51ms (95%), errors: 0.00, reconnects:  0.00
[ 492s] threads: 32, tps: 391.02, reads: 5612.33, writes: 1562.09, response time: 109.99ms (95%), errors: 0.00, reconnects:  0.00
[ 493s] threads: 32, tps: 374.99, reads: 5307.90, writes: 1475.97, response time: 117.30ms (95%), errors: 0.00, reconnects:  0.00
[ 494s] threads: 32, tps: 326.00, reads: 4593.95, writes: 1375.98, response time: 154.17ms (95%), errors: 0.00, reconnects:  0.00
[ 495s] threads: 32, tps: 400.01, reads: 5657.21, writes: 1571.06, response time: 107.26ms (95%), errors: 0.00, reconnects:  0.00
[ 496s] threads: 32, tps: 371.99, reads: 5231.90, writes: 1557.97, response time: 111.72ms (95%), errors: 0.00, reconnects:  0.00
[ 497s] threads: 32, tps: 339.01, reads: 4592.09, writes: 1248.02, response time: 156.92ms (95%), errors: 0.00, reconnects:  0.00
[ 498s] threads: 32, tps: 366.00, reads: 5277.97, writes: 1576.99, response time: 121.52ms (95%), errors: 0.00, reconnects:  0.00
[ 499s] threads: 32, tps: 376.01, reads: 5036.07, writes: 1400.02, response time: 152.15ms (95%), errors: 0.00, reconnects:  0.00
[ 500s] threads: 32, tps: 318.00, reads: 4437.96, writes: 1266.99, response time: 163.83ms (95%), errors: 0.00, reconnects:  0.00
[ 501s] threads: 32, tps: 332.99, reads: 4840.89, writes: 1346.97, response time: 155.47ms (95%), errors: 0.00, reconnects:  0.00
[ 502s] threads: 32, tps: 358.01, reads: 4944.13, writes: 1473.04, response time: 140.55ms (95%), errors: 0.00, reconnects:  0.00
[ 503s] threads: 32, tps: 340.99, reads: 4783.92, writes: 1317.98, response time: 131.87ms (95%), errors: 0.00, reconnects:  0.00
[ 504s] threads: 32, tps: 378.01, reads: 5237.07, writes: 1519.02, response time: 120.94ms (95%), errors: 0.00, reconnects:  0.00
[ 505s] threads: 32, tps: 339.99, reads: 4935.89, writes: 1450.97, response time: 138.09ms (95%), errors: 0.00, reconnects:  0.00
[ 506s] threads: 32, tps: 326.01, reads: 4259.11, writes: 1177.03, response time: 147.75ms (95%), errors: 0.00, reconnects:  0.00
[ 507s] threads: 32, tps: 391.00, reads: 5628.99, writes: 1607.00, response time: 107.36ms (95%), errors: 0.00, reconnects:  0.00
[ 508s] threads: 32, tps: 384.00, reads: 5370.01, writes: 1519.00, response time: 109.24ms (95%), errors: 0.00, reconnects:  0.00
[ 509s] threads: 32, tps: 340.99, reads: 4929.89, writes: 1465.97, response time: 120.72ms (95%), errors: 0.00, reconnects:  0.00
[ 510s] threads: 32, tps: 415.95, reads: 5623.38, writes: 1561.83, response time: 114.77ms (95%), errors: 0.00, reconnects:  0.00
[ 511s] threads: 32, tps: 290.03, reads: 4121.49, writes: 1190.14, response time: 170.99ms (95%), errors: 0.00, reconnects:  0.00
[ 512s] threads: 32, tps: 335.00, reads: 4777.04, writes: 1346.01, response time: 126.46ms (95%), errors: 0.00, reconnects:  0.00
[ 513s] threads: 32, tps: 383.00, reads: 5413.94, writes: 1597.98, response time: 103.32ms (95%), errors: 0.00, reconnects:  0.00
[ 514s] threads: 32, tps: 349.00, reads: 4884.96, writes: 1389.99, response time: 159.38ms (95%), errors: 0.00, reconnects:  0.00
[ 515s] threads: 32, tps: 317.73, reads: 4393.31, writes: 1173.01, response time: 182.85ms (95%), errors: 0.00, reconnects:  0.00
[ 516s] threads: 32, tps: 373.32, reads: 5281.47, writes: 1589.35, response time: 119.36ms (95%), errors: 0.00, reconnects:  0.00
[ 517s] threads: 32, tps: 386.00, reads: 5405.02, writes: 1551.00, response time: 115.39ms (95%), errors: 0.00, reconnects:  0.00
[ 518s] threads: 32, tps: 341.00, reads: 4590.94, writes: 1255.98, response time: 158.62ms (95%), errors: 0.00, reconnects:  0.00
[ 519s] threads: 32, tps: 357.01, reads: 4980.11, writes: 1415.03, response time: 116.39ms (95%), errors: 0.00, reconnects:  0.00
[ 520s] threads: 32, tps: 389.00, reads: 5605.00, writes: 1612.00, response time: 107.68ms (95%), errors: 0.00, reconnects:  0.00
[ 521s] threads: 32, tps: 341.00, reads: 4706.99, writes: 1353.00, response time: 131.75ms (95%), errors: 0.00, reconnects:  0.00
[ 522s] threads: 32, tps: 407.99, reads: 5784.90, writes: 1627.97, response time: 106.49ms (95%), errors: 0.00, reconnects:  0.00
[ 523s] threads: 32, tps: 370.01, reads: 5177.11, writes: 1527.03, response time: 114.56ms (95%), errors: 0.00, reconnects:  0.00
[ 524s] threads: 32, tps: 352.00, reads: 4641.99, writes: 1322.00, response time: 155.93ms (95%), errors: 0.00, reconnects:  0.00
[ 525s] threads: 32, tps: 360.00, reads: 5265.99, writes: 1468.00, response time: 121.67ms (95%), errors: 0.00, reconnects:  0.00
[ 526s] threads: 32, tps: 320.99, reads: 4554.88, writes: 1270.97, response time: 139.63ms (95%), errors: 0.00, reconnects:  0.00
[ 527s] threads: 32, tps: 290.01, reads: 3888.11, writes: 1140.03, response time: 339.38ms (95%), errors: 0.00, reconnects:  0.00
[ 528s] threads: 32, tps: 395.44, reads: 5621.02, writes: 1607.72, response time: 107.97ms (95%), errors: 0.00, reconnects:  0.00
[ 529s] threads: 32, tps: 342.48, reads: 4823.72, writes: 1375.92, response time: 141.52ms (95%), errors: 0.00, reconnects:  0.00
[ 530s] threads: 32, tps: 267.00, reads: 3779.03, writes: 1083.01, response time: 170.53ms (95%), errors: 0.00, reconnects:  0.00
[ 531s] threads: 32, tps: 367.01, reads: 5163.08, writes: 1452.02, response time: 120.51ms (95%), errors: 0.00, reconnects:  0.00
[ 532s] threads: 32, tps: 314.00, reads: 4425.96, writes: 1348.99, response time: 232.33ms (95%), errors: 0.00, reconnects:  0.00
[ 533s] threads: 32, tps: 342.00, reads: 4675.06, writes: 1310.02, response time: 130.69ms (95%), errors: 0.00, reconnects:  0.00
[ 534s] threads: 32, tps: 406.99, reads: 5572.93, writes: 1566.98, response time: 107.29ms (95%), errors: 0.00, reconnects:  0.00
[ 535s] threads: 32, tps: 340.01, reads: 4842.07, writes: 1370.02, response time: 149.76ms (95%), errors: 0.00, reconnects:  0.00
[ 536s] threads: 32, tps: 282.99, reads: 3919.89, writes: 1121.97, response time: 171.92ms (95%), errors: 0.00, reconnects:  0.00
[ 537s] threads: 32, tps: 375.00, reads: 5410.06, writes: 1569.02, response time: 105.64ms (95%), errors: 0.00, reconnects:  0.00
[ 538s] threads: 32, tps: 368.00, reads: 5190.06, writes: 1522.02, response time: 125.93ms (95%), errors: 0.00, reconnects:  0.00
[ 539s] threads: 32, tps: 338.00, reads: 4578.04, writes: 1233.01, response time: 169.82ms (95%), errors: 0.00, reconnects:  0.00
[ 540s] threads: 32, tps: 354.00, reads: 4899.98, writes: 1421.99, response time: 143.23ms (95%), errors: 0.00, reconnects:  0.00
[ 541s] threads: 32, tps: 409.00, reads: 5767.01, writes: 1631.00, response time: 107.58ms (95%), errors: 0.00, reconnects:  0.00
[ 542s] threads: 32, tps: 314.00, reads: 4355.98, writes: 1255.99, response time: 159.90ms (95%), errors: 0.00, reconnects:  0.00
[ 543s] threads: 32, tps: 354.99, reads: 5150.88, writes: 1477.97, response time: 142.80ms (95%), errors: 0.00, reconnects:  0.00
[ 544s] threads: 32, tps: 417.00, reads: 5630.06, writes: 1628.02, response time: 106.14ms (95%), errors: 0.00, reconnects:  0.00
[ 545s] threads: 32, tps: 338.00, reads: 4926.07, writes: 1396.02, response time: 130.42ms (95%), errors: 0.00, reconnects:  0.00
[ 546s] threads: 32, tps: 385.00, reads: 5379.02, writes: 1505.01, response time: 119.61ms (95%), errors: 0.00, reconnects:  0.00
[ 547s] threads: 32, tps: 341.99, reads: 4798.90, writes: 1435.97, response time: 165.46ms (95%), errors: 0.00, reconnects:  0.00
[ 548s] threads: 32, tps: 321.01, reads: 4424.07, writes: 1185.02, response time: 156.78ms (95%), errors: 0.00, reconnects:  0.00
[ 549s] threads: 32, tps: 386.00, reads: 5448.98, writes: 1602.00, response time: 108.26ms (95%), errors: 0.00, reconnects:  0.00
[ 550s] threads: 32, tps: 396.00, reads: 5438.96, writes: 1580.99, response time: 104.79ms (95%), errors: 0.00, reconnects:  0.00
[ 551s] threads: 32, tps: 362.01, reads: 5071.07, writes: 1412.02, response time: 128.40ms (95%), errors: 0.00, reconnects:  0.00
[ 552s] threads: 32, tps: 387.00, reads: 5341.96, writes: 1523.99, response time: 116.32ms (95%), errors: 0.00, reconnects:  0.00
[ 553s] threads: 32, tps: 389.00, reads: 5543.97, writes: 1592.99, response time: 116.85ms (95%), errors: 0.00, reconnects:  0.00
[ 554s] threads: 32, tps: 252.00, reads: 3662.98, writes: 1058.99, response time: 175.82ms (95%), errors: 0.00, reconnects:  0.00
[ 555s] threads: 32, tps: 397.01, reads: 5374.08, writes: 1536.02, response time: 124.58ms (95%), errors: 0.00, reconnects:  0.00
[ 556s] threads: 32, tps: 357.00, reads: 5110.99, writes: 1411.00, response time: 142.37ms (95%), errors: 0.00, reconnects:  0.00
[ 557s] threads: 32, tps: 250.00, reads: 3397.96, writes: 988.99, response time: 309.95ms (95%), errors: 0.00, reconnects:  0.00
[ 558s] threads: 32, tps: 378.01, reads: 5371.11, writes: 1553.03, response time: 118.89ms (95%), errors: 0.00, reconnects:  0.00
[ 559s] threads: 32, tps: 389.00, reads: 5492.99, writes: 1543.00, response time: 114.08ms (95%), errors: 0.00, reconnects:  0.00
[ 560s] threads: 32, tps: 342.00, reads: 4722.99, writes: 1339.00, response time: 131.71ms (95%), errors: 0.00, reconnects:  0.00
[ 561s] threads: 32, tps: 357.99, reads: 5099.91, writes: 1521.97, response time: 126.12ms (95%), errors: 0.00, reconnects:  0.00
[ 562s] threads: 32, tps: 414.99, reads: 5505.87, writes: 1562.96, response time: 110.42ms (95%), errors: 0.00, reconnects:  0.00
[ 563s] threads: 32, tps: 272.01, reads: 4003.16, writes: 1088.04, response time: 165.70ms (95%), errors: 0.00, reconnects:  0.00
[ 564s] threads: 32, tps: 401.96, reads: 5625.48, writes: 1620.85, response time: 107.26ms (95%), errors: 0.00, reconnects:  0.00
[ 565s] threads: 32, tps: 378.03, reads: 5381.39, writes: 1545.11, response time: 114.87ms (95%), errors: 0.00, reconnects:  0.00
[ 566s] threads: 32, tps: 264.99, reads: 3767.91, writes: 1140.97, response time: 170.94ms (95%), errors: 0.00, reconnects:  0.00
[ 567s] threads: 32, tps: 399.01, reads: 5519.10, writes: 1545.03, response time: 159.81ms (95%), errors: 0.00, reconnects:  0.00
[ 568s] threads: 32, tps: 408.00, reads: 5672.05, writes: 1609.02, response time: 109.34ms (95%), errors: 0.00, reconnects:  0.00
[ 569s] threads: 32, tps: 309.99, reads: 4315.93, writes: 1221.98, response time: 162.36ms (95%), errors: 0.00, reconnects:  0.00
[ 570s] threads: 32, tps: 403.01, reads: 5680.12, writes: 1617.03, response time: 104.66ms (95%), errors: 0.00, reconnects:  0.00
[ 571s] threads: 32, tps: 401.99, reads: 5602.89, writes: 1602.97, response time: 109.14ms (95%), errors: 0.00, reconnects:  0.00
[ 572s] threads: 32, tps: 319.00, reads: 4349.06, writes: 1281.02, response time: 202.02ms (95%), errors: 0.00, reconnects:  0.00
[ 573s] threads: 32, tps: 402.01, reads: 5696.10, writes: 1580.03, response time: 102.58ms (95%), errors: 0.00, reconnects:  0.00
[ 574s] threads: 32, tps: 380.00, reads: 5344.94, writes: 1529.98, response time: 114.70ms (95%), errors: 0.00, reconnects:  0.00
[ 575s] threads: 32, tps: 320.00, reads: 4604.00, writes: 1351.00, response time: 137.55ms (95%), errors: 0.00, reconnects:  0.00
[ 576s] threads: 32, tps: 364.00, reads: 4962.98, writes: 1363.99, response time: 169.47ms (95%), errors: 0.00, reconnects:  0.00
[ 577s] threads: 32, tps: 388.00, reads: 5480.02, writes: 1599.01, response time: 114.80ms (95%), errors: 0.00, reconnects:  0.00
[ 578s] threads: 32, tps: 309.00, reads: 4316.05, writes: 1210.01, response time: 192.57ms (95%), errors: 0.00, reconnects:  0.00
[ 579s] threads: 32, tps: 398.00, reads: 5648.01, writes: 1652.00, response time: 102.58ms (95%), errors: 0.00, reconnects:  0.00
[ 580s] threads: 32, tps: 359.00, reads: 5009.00, writes: 1408.00, response time: 129.44ms (95%), errors: 0.00, reconnects:  0.00
[ 581s] threads: 32, tps: 306.00, reads: 4269.93, writes: 1234.98, response time: 198.07ms (95%), errors: 0.00, reconnects:  0.00
[ 582s] threads: 32, tps: 399.01, reads: 5489.09, writes: 1536.02, response time: 117.66ms (95%), errors: 0.00, reconnects:  0.00
[ 583s] threads: 32, tps: 396.00, reads: 5557.00, writes: 1612.00, response time: 103.72ms (95%), errors: 0.00, reconnects:  0.00
[ 584s] threads: 32, tps: 328.00, reads: 4709.00, writes: 1331.00, response time: 147.75ms (95%), errors: 0.00, reconnects:  0.00
[ 585s] threads: 32, tps: 385.99, reads: 5346.92, writes: 1548.98, response time: 121.74ms (95%), errors: 0.00, reconnects:  0.00
[ 586s] threads: 32, tps: 392.95, reads: 5418.35, writes: 1550.81, response time: 109.04ms (95%), errors: 0.00, reconnects:  0.00
[ 587s] threads: 32, tps: 288.00, reads: 4045.05, writes: 1140.01, response time: 292.82ms (95%), errors: 0.00, reconnects:  0.00
[ 588s] threads: 32, tps: 424.04, reads: 5822.59, writes: 1704.17, response time: 104.28ms (95%), errors: 0.00, reconnects:  0.00
[ 589s] threads: 32, tps: 384.99, reads: 5625.91, writes: 1570.97, response time: 105.48ms (95%), errors: 0.00, reconnects:  0.00
[ 590s] threads: 32, tps: 293.01, reads: 4088.08, writes: 1184.02, response time: 175.40ms (95%), errors: 0.00, reconnects:  0.00
[ 591s] threads: 32, tps: 398.87, reads: 5499.15, writes: 1588.47, response time: 109.30ms (95%), errors: 0.00, reconnects:  0.00
[ 592s] threads: 32, tps: 368.13, reads: 5275.86, writes: 1487.52, response time: 111.18ms (95%), errors: 0.00, reconnects:  0.00
[ 593s] threads: 32, tps: 320.00, reads: 4214.94, writes: 1208.98, response time: 149.71ms (95%), errors: 0.00, reconnects:  0.00
[ 594s] threads: 32, tps: 369.99, reads: 5391.92, writes: 1501.98, response time: 128.09ms (95%), errors: 0.00, reconnects:  0.00
[ 595s] threads: 32, tps: 422.01, reads: 5743.16, writes: 1660.05, response time: 104.79ms (95%), errors: 0.00, reconnects:  0.00
[ 596s] threads: 32, tps: 284.00, reads: 4063.01, writes: 1142.00, response time: 211.42ms (95%), errors: 0.00, reconnects:  0.00
[ 597s] threads: 32, tps: 362.99, reads: 4952.92, writes: 1439.98, response time: 148.91ms (95%), errors: 0.00, reconnects:  0.00
[ 598s] threads: 32, tps: 348.00, reads: 5008.07, writes: 1451.02, response time: 129.83ms (95%), errors: 0.00, reconnects:  0.00
[ 599s] threads: 32, tps: 289.00, reads: 4145.93, writes: 1152.98, response time: 202.44ms (95%), errors: 0.00, reconnects:  0.00
[ 600s] threads: 32, tps: 399.01, reads: 5461.11, writes: 1553.03, response time: 133.98ms (95%), errors: 0.00, reconnects:  0.00
OLTP test statistics:
    queries performed:
        read:                            2773638
        write:                           792468
        other:                           396234
        total:                           3962340
    transactions:                        198117 (330.16 per sec.)
    read/write requests:                 3566106 (5942.79 per sec.)
    other operations:                    396234 (660.31 per sec.)
    ignored errors:                      0      (0.00 per sec.)
    reconnects:                          0      (0.00 per sec.)

General statistics:
    total time:                          600.0722s
    total number of events:              198117
    total time taken by event execution: 19200.3205s
    response time:
         min:                                 28.03ms
         avg:                                 96.91ms
         max:                               1212.17ms
         approx.  95 percentile:             157.20ms

Threads fairness:
    events (avg/stddev):           6191.1562/14.19
    execution time (avg/stddev):   600.0100/0.02

[oracle@sjjh admin]$ sysbench --test=/sysbench-0.5/tests/db/oltp.lua --db-driver=oracle --oltp-table-name=sysbench --oltp-table-size=250000 --oltp-tables-count=25 --oracle-db=sjjh --oracle-user=sysbench --oracle-password=sysbench --max-time=600 --max-requests=10000000 --num-threads=32 --report-interval=1 cleanup
sysbench 0.5:  multi-threaded system evaluation benchmark

Dropping table 'sbtest1'...
Dropping table 'sbtest2'...
Dropping table 'sbtest3'...
Dropping table 'sbtest4'...
Dropping table 'sbtest5'...
Dropping table 'sbtest6'...
Dropping table 'sbtest7'...
Dropping table 'sbtest8'...
Dropping table 'sbtest9'...
Dropping table 'sbtest10'...
Dropping table 'sbtest11'...
Dropping table 'sbtest12'...
Dropping table 'sbtest13'...
Dropping table 'sbtest14'...
Dropping table 'sbtest15'...
Dropping table 'sbtest16'...
Dropping table 'sbtest17'...
Dropping table 'sbtest18'...
Dropping table 'sbtest19'...
Dropping table 'sbtest20'...
Dropping table 'sbtest21'...
Dropping table 'sbtest22'...
Dropping table 'sbtest23'...
Dropping table 'sbtest24'...
Dropping table 'sbtest25'...