root@REDPOLL:/home/hammerdb/HammerDB-4.6
BUILD HAMMERDB SCHEMA
+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-
HammerDB CLI v4.6
Copyright (C) 2003-2022 Steve Shaw
Type "help" for a list of commands
Initialized SQLite on-disk database /home/hammerdb/HammerDB-4.6/TMP/hammer.DB using existing tables (229,376 KB)
SETTING CONFIGURATION
Database set to MariaDB
Benchmark set to TPC-C for MariaDB
Value redpoll for connection:maria_host is the same as existing value redpoll, no change made
Value 3306 for connection:maria_port is the same as existing value 3306, no change made
Value /tmp/mariadb.sock for connection:maria_socket is the same as existing value /tmp/mariadb.sock, no change made
Value 20 for tpcc:maria_count_ware is the same as existing value 20, no change made
Value 4 for tpcc:maria_num_vu is the same as existing value 4, no change made
Value root for tpcc:maria_user is the same as existing value root, no change made
Value maria for tpcc:maria_pass is the same as existing value maria, no change made
Value tpcc for tpcc:maria_dbase is the same as existing value tpcc, no change made
Value innodb for tpcc:maria_storage_engine is the same as existing value innodb, no change made
Value false for tpcc:maria_partition is the same as existing value false, no change made
SCHEMA BUILD STARTED
Script cleared
Building 20 Warehouses with 5 Virtual Users, 4 active + 1 Monitor VU(dict value maria_num_vu is set to 4)
Ready to create a 20 Warehouse MariaDB TPROC-C schema
in host REDPOLL:3306 under user ROOT in database TPCC with storage engine INNODB?
Enter yes or no: replied yes
Vuser 1 created - WAIT IDLE
Vuser 2 created - WAIT IDLE
Vuser 3 created - WAIT IDLE
Vuser 4 created - WAIT IDLE
Vuser 5 created - WAIT IDLE
Vuser 1:RUNNING
Vuser 1:Monitor Thread
Vuser 1:CREATING TPCC SCHEMA
Vuser 1:Ssl_cipher
Vuser 1:CREATING DATABASE tpcc
Vuser 1:CREATING TPCC TABLES
Vuser 1:Loading Item
Vuser 2:RUNNING
Vuser 2:Worker Thread
Vuser 2:Waiting for Monitor Thread...
Vuser 2:Ssl_cipher
Vuser 2:Loading 5 Warehouses start:1 end:5
Vuser 2:Start:Wed Dec 14 13:47:59 +0000 2022
Vuser 2:Loading Warehouse
Vuser 2:Loading Stock Wid=1
Vuser 3:RUNNING
Vuser 3:Worker Thread
Vuser 3:Waiting for Monitor Thread...
Vuser 3:Ssl_cipher
Vuser 3:Loading 5 Warehouses start:6 end:10
Vuser 5:Loading Warehouse
Vuser 5:Loading Stock Wid=16
...
Vuser 2:FINISHED SUCCESS
Vuser 3:...2000
Vuser 3:...3000
Vuser 3:Orders Done
Vuser 3:End:Wed Dec 14 13:51:05 +0000 2022
Vuser 3:FINISHED SUCCESS
Vuser 1:Workers: 0 Active 4 Done
Vuser 1:CREATING TPCC STORED PROCEDURES
Vuser 1:GATHERING SCHEMA STATISTICS
Vuser 1:TPCC SCHEMA COMPLETE
Vuser 1:FINISHED SUCCESS
ALL VIRTUAL USERS COMPLETE
SCHEMA BUILD COMPLETED
+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-
RUN HAMMERDB TEST
+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-
HammerDB CLI v4.6
Copyright (C) 2003-2022 Steve Shaw
Type "help" for a list of commands
Initialized SQLite on-disk database /home/hammerdb/HammerDB-4.6/TMP/hammer.DB using existing tables (372,736 KB)
SETTING CONFIGURATION
Database set to MariaDB
Benchmark set to TPC-C for MariaDB
Value redpoll for connection:maria_host is the same as existing value redpoll, no change made
Value 3306 for connection:maria_port is the same as existing value 3306, no change made
Value /tmp/mariadb.sock for connection:maria_socket is the same as existing value /tmp/mariadb.sock, no change made
Value root for tpcc:maria_user is the same as existing value root, no change made
Value maria for tpcc:maria_pass is the same as existing value maria, no change made
Value tpcc for tpcc:maria_dbase is the same as existing value tpcc, no change made
Value timed for tpcc:maria_driver is the same as existing value timed, no change made
Value 2 for tpcc:maria_rampup is the same as existing value 2, no change made
Value 5 for tpcc:maria_duration is the same as existing value 5, no change made
Value true for tpcc:maria_allwarehouse is the same as existing value true, no change made
Value true for tpcc:maria_timeprofile is the same as existing value true, no change made
Script loaded, Type "print script" to view
TEST STARTED
Vuser 1 created MONITOR - WAIT IDLE
Vuser 2 created - WAIT IDLE
Vuser 3 created - WAIT IDLE
Vuser 4 created - WAIT IDLE
Vuser 5 created - WAIT IDLE
5 Virtual Users Created with Monitor VU
Transaction Counter Started
Transaction Counter thread running with threadid:tid0x7fec51ffb700
0 MariaDB tpm
Vuser 1:RUNNING
Vuser 1:Initializing xtprof time profiler
Vuser 1:Ssl_cipher
Vuser 1:Beginning rampup time of 2 minutes
Vuser 2:RUNNING
Vuser 2:Initializing xtprof time profiler
Vuser 3:RUNNING
Vuser 2:Ssl_cipher
Vuser 3:Initializing xtprof time profiler
Vuser 2:VU 2 : Assigning WID=1 based on VU count 4, Warehouses = 20 (1 out of 5)
Vuser 3:Ssl_cipher
Vuser 2:VU 2 : Assigning WID=5 based on VU count 4, Warehouses = 20 (2 out of 5)
Vuser 3:VU 3 : Assigning WID=2 based on VU count 4, Warehouses = 20 (1 out of 5)
Vuser 2:VU 2 : Assigning WID=9 based on VU count 4, Warehouses = 20 (3 out of 5)
Vuser 3:VU 3 : Assigning WID=6 based on VU count 4, Warehouses = 20 (2 out of 5)
Vuser 2:VU 2 : Assigning WID=13 based on VU count 4, Warehouses = 20 (4 out of 5)
Vuser 3:VU 3 : Assigning WID=10 based on VU count 4, Warehouses = 20 (3 out of 5)
Vuser 2:VU 2 : Assigning WID=17 based on VU count 4, Warehouses = 20 (5 out of 5)
Vuser 3:VU 3 : Assigning WID=14 based on VU count 4, Warehouses = 20 (4 out of 5)
Vuser 2:Processing 10000000 transactions with output suppressed...
Vuser 3:VU 3 : Assigning WID=18 based on VU count 4, Warehouses = 20 (5 out of 5)
Vuser 3:Processing 10000000 transactions with output suppressed...
Vuser 4:RUNNING
Vuser 4:Initializing xtprof time profiler
Vuser 4:Ssl_cipher
Vuser 4:VU 4 : Assigning WID=3 based on VU count 4, Warehouses = 20 (1 out of 5)
Vuser 4:VU 4 : Assigning WID=7 based on VU count 4, Warehouses = 20 (2 out of 5)
Vuser 4:VU 4 : Assigning WID=11 based on VU count 4, Warehouses = 20 (3 out of 5)
Vuser 4:VU 4 : Assigning WID=15 based on VU count 4, Warehouses = 20 (4 out of 5)
Vuser 4:VU 4 : Assigning WID=19 based on VU count 4, Warehouses = 20 (5 out of 5)
Vuser 4:Processing 10000000 transactions with output suppressed...
Vuser 5:RUNNING
Vuser 5:Initializing xtprof time profiler
Vuser 5:Ssl_cipher
Vuser 5:VU 5 : Assigning WID=4 based on VU count 4, Warehouses = 20 (1 out of 5)
Vuser 5:VU 5 : Assigning WID=8 based on VU count 4, Warehouses = 20 (2 out of 5)
Vuser 5:VU 5 : Assigning WID=12 based on VU count 4, Warehouses = 20 (3 out of 5)
Vuser 5:VU 5 : Assigning WID=16 based on VU count 4, Warehouses = 20 (4 out of 5)
Vuser 5:VU 5 : Assigning WID=20 based on VU count 4, Warehouses = 20 (5 out of 5)
Vuser 5:Processing 10000000 transactions with output suppressed...
54690 MariaDB tpm
86406 MariaDB tpm
63144 MariaDB tpm
55824 MariaDB tpm
90012 MariaDB tpm
Vuser 1:Rampup 1 minutes complete ...
90228 MariaDB tpm
93984 MariaDB tpm
79008 MariaDB tpm
67278 MariaDB tpm
62952 MariaDB tpm
93834 MariaDB tpm
107478 MariaDB tpm
Vuser 1:Rampup 2 minutes complete ...
Vuser 1:Rampup complete, Taking start Transaction Count.
Vuser 1:Timing test period of 5 in minutes
104154 MariaDB tpm
95004 MariaDB tpm
82794 MariaDB tpm
83328 MariaDB tpm
74424 MariaDB tpm
43962 MariaDB tpm
Vuser 1:1 ...,
105270 MariaDB tpm
37362 MariaDB tpm
12816 MariaDB tpm
5304 MariaDB tpm
10470 MariaDB tpm
6084 MariaDB tpm
Vuser 1:2 ...,
5730 MariaDB tpm
6048 MariaDB tpm
6768 MariaDB tpm
9438 MariaDB tpm
11280 MariaDB tpm
10428 MariaDB tpm
Vuser 1:3 ...,
17022 MariaDB tpm
14310 MariaDB tpm
19374 MariaDB tpm
22326 MariaDB tpm
16698 MariaDB tpm
20100 MariaDB tpm
21000 MariaDB tpm
Vuser 1:4 ...,
10902 MariaDB tpm
14898 MariaDB tpm
60228 MariaDB tpm
37632 MariaDB tpm
50778 MariaDB tpm
34044 MariaDB tpm
Vuser 1:5 ...,
Vuser 1:Test complete, Taking end Transaction Count.
Vuser 1:4 Active Virtual Users configured
Vuser 1:TEST RESULT : System achieved 15199 NOPM from 35354 MariaDB TPM
Vuser 1:Gathering timing data from Active Virtual Users...
48096 MariaDB tpm
Vuser 5:FINISHED SUCCESS
Vuser 2:FINISHED SUCCESS
Vuser 3:FINISHED SUCCESS
Vuser 4:FINISHED SUCCESS
Vuser 1:Calculating timings...
8226 MariaDB tpm
Vuser 1:Writing timing data to /home/hammerdb/HammerDB-4.6/TMP/hdbxtprofile.log
0 MariaDB tpm
0 MariaDB tpm
0 MariaDB tpm
0 MariaDB tpm
0 MariaDB tpm
0 MariaDB tpm
0 MariaDB tpm
0 MariaDB tpm
0 MariaDB tpm
Vuser 1:FINISHED SUCCESS
ALL VIRTUAL USERS COMPLETE
0 MariaDB tpm
vudestroy success
Transaction Counter thread running with threadid:tid0x7fec51ffb700
Stopping Transaction Counter
TEST COMPLETE
+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-
DROP HAMMERDB SCHEMA
HammerDB CLI v4.6
Copyright (C) 2003-2022 Steve Shaw
Type "help" for a list of commands
Initialized SQLite on-disk database /home/hammerdb/HammerDB-4.6/TMP/hammer.DB using existing tables (397,312 KB)
SETTING CONFIGURATION
Database set to MariaDB
Benchmark set to TPC-C for MariaDB
Value redpoll for connection:maria_host is the same as existing value redpoll, no change made
Value 3306 for connection:maria_port is the same as existing value 3306, no change made
Value /tmp/mariadb.sock for connection:maria_socket is the same as existing value /tmp/mariadb.sock, no change made
Value root for tpcc:maria_user is the same as existing value root, no change made
Value maria for tpcc:maria_pass is the same as existing value maria, no change made
Value tpcc for tpcc:maria_dbase is the same as existing value tpcc, no change made
DROP SCHEMA STARTED
Script cleared
Deleting schema with 1 Virtual User
Do you want to delete the TPCC TPROC-C schema
in host REDPOLL:3306 under user ROOT?
Enter yes or no: replied yes
Vuser 1 created - WAIT IDLE
Vuser 1:RUNNING
Vuser 1:Ssl_cipher
DROP SCHEMA COMPLETED
+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-
HAMMERDB RESULT
HammerDB CLI v4.6
Copyright (C) 2003-2022 Steve Shaw
Type "help" for a list of commands
Initialized SQLite on-disk database /home/hammerdb/HammerDB-4.6/TMP/hammer.DB using existing tables (397,312 KB)
TRANSACTION RESPONSE TIMES
{
"DELIVERY": {
"elapsed_ms": "439561.0",
"calls": "3320",
"min_ms": "4.383",
"avg_ms": "59.972",
"max_ms": "77608.65",
"total_ms": "199106.945",
"p99_ms": "307.374",
"p95_ms": "10.461",
"p50_ms": "5.74",
"sd": "1684200.807",
"ratio_pct": "45.476"
},
"NEWORD": {
"elapsed_ms": "439561.0",
"calls": "33945",
"min_ms": "1.227",
"avg_ms": "5.016",
"max_ms": "17419.641",
"total_ms": "170261.191",
"p99_ms": "8.509",
"p95_ms": "4.596",
"p50_ms": "2.503",
"sd": "105049.036",
"ratio_pct": "38.888"
},
"PAYMENT": {
"elapsed_ms": "439561.0",
"calls": "33696",
"min_ms": "0.602",
"avg_ms": "1.512",
"max_ms": "2687.342",
"total_ms": "50964.941",
"p99_ms": "3.443",
"p95_ms": "1.773",
"p50_ms": "1.004",
"sd": "23559.832",
"ratio_pct": "11.64"
},
"OSTAT": {
"elapsed_ms": "439561.0",
"calls": "3393",
"min_ms": "0.454",
"avg_ms": "3.023",
"max_ms": "1321.03",
"total_ms": "10255.874",
"p99_ms": "3.218",
"p95_ms": "1.519",
"p50_ms": "0.868",
"sd": "44465.804",
"ratio_pct": "2.342"
},
"SLEV": {
"elapsed_ms": "439561.0",
"calls": "3310",
"min_ms": "0.82",
"avg_ms": "1.352",
"max_ms": "184.051",
"total_ms": "4476.381",
"p99_ms": "3.524",
"p95_ms": "1.995",
"p50_ms": "1.135",
"sd": "3229.144",
"ratio_pct": "1.022"
}
}
TRANSACTION COUNT
{"MariaDB tpm": {
"0": "2022-12-14 14:00:23",
"54690": "2022-12-14 13:51:19",
"86406": "2022-12-14 13:51:29",
"63144": "2022-12-14 13:51:39",
"55824": "2022-12-14 13:51:49",
"90012": "2022-12-14 13:51:59",
"90228": "2022-12-14 13:52:10",
"93984": "2022-12-14 13:52:19",
"79008": "2022-12-14 13:52:29",
"67278": "2022-12-14 13:52:39",
"62952": "2022-12-14 13:52:49",
"93834": "2022-12-14 13:52:59",
"107478": "2022-12-14 13:53:09",
"104154": "2022-12-14 13:53:19",
"95004": "2022-12-14 13:53:29",
"82794": "2022-12-14 13:53:39",
"83328": "2022-12-14 13:53:49",
"74424": "2022-12-14 13:53:59",
"43962": "2022-12-14 13:54:09",
"105270": "2022-12-14 13:54:19",
"37362": "2022-12-14 13:54:29",
"12816": "2022-12-14 13:54:39",
"5304": "2022-12-14 13:54:49",
"10470": "2022-12-14 13:54:59",
"6084": "2022-12-14 13:55:09",
"5730": "2022-12-14 13:55:19",
"6048": "2022-12-14 13:55:29",
"6768": "2022-12-14 13:55:39",
"9438": "2022-12-14 13:55:49",
"11280": "2022-12-14 13:56:00",
"10428": "2022-12-14 13:56:10",
"17022": "2022-12-14 13:56:22",
"14310": "2022-12-14 13:56:30",
"19374": "2022-12-14 13:56:40",
"22326": "2022-12-14 13:56:50",
"16698": "2022-12-14 13:57:00",
"20100": "2022-12-14 13:57:10",
"21000": "2022-12-14 13:57:20",
"10902": "2022-12-14 13:57:30",
"14898": "2022-12-14 13:57:40",
"60228": "2022-12-14 13:57:50",
"37632": "2022-12-14 13:58:00",
"50778": "2022-12-14 13:58:10",
"34044": "2022-12-14 13:58:20",
"48096": "2022-12-14 13:58:32",
"8226": "2022-12-14 13:58:45"
}}
HAMMERDB RESULT
[
"6399D4CD5EFC03E233239383",
"2022-12-14 13:51:09",
"4 Active Virtual Users configured",
"TEST RESULT : System achieved 15199 NOPM from 35354 MariaDB TPM"
]