test_results_list_300_8GB_group_clog_v8.txt

text/plain

Filename: test_results_list_300_8GB_group_clog_v8.txt
Type: text/plain
Part: 0
Message: Re: Speed up Clog Access by increasing CLOG buffers
Start of script for 300 8GB 
============== group_clog_v8 =============
================================================
300, 8GB, 256, 256, 1200 Reading - 1
transaction type: multiple scripts
scaling factor: 300
query mode: prepared
number of clients: 256
number of threads: 256
duration: 1200 s
number of transactions actually processed: 135434825
latency average: 2.268 ms
tps = 112860.743738 (including connections establishing)
tps = 112861.829048 (excluding connections establishing)
SQL script 1: <builtin: TPC-B (sort of)>
 - weight = 1 (targets 25.0% of total)
 - 33376619 transactions (24.6% of total, tps = 27813.452292)
 - latency average = 6.866 ms
 - latency stddev = 4.977 ms
SQL script 2: <builtin: select only>
 - weight = 3 (targets 75.0% of total)
 - 98885323 transactions (73.0% of total, tps = 82403.260007)
 - latency average = 0.739 ms
 - latency stddev = 1.681 ms
CHECKPOINT
================================================
300, 8GB, 256, 256, 1200 Reading - 2
transaction type: multiple scripts
scaling factor: 300
query mode: prepared
number of clients: 256
number of threads: 256
duration: 1200 s
number of transactions actually processed: 133946949
latency average: 2.293 ms
tps = 111573.984461 (including connections establishing)
tps = 111575.116415 (excluding connections establishing)
SQL script 1: <builtin: TPC-B (sort of)>
 - weight = 1 (targets 25.0% of total)
 - 32930394 transactions (24.6% of total, tps = 27430.078071)
 - latency average = 6.903 ms
 - latency stddev = 5.022 ms
SQL script 2: <builtin: select only>
 - weight = 3 (targets 75.0% of total)
 - 98074548 transactions (73.2% of total, tps = 81693.298551)
 - latency average = 0.759 ms
 - latency stddev = 1.711 ms
CHECKPOINT
================================================
300, 8GB, 256, 256, 1200 Reading - 3
transaction type: multiple scripts
scaling factor: 300
query mode: prepared
number of clients: 256
number of threads: 256
duration: 1200 s
number of transactions actually processed: 123963990
latency average: 2.478 ms
tps = 103301.868530 (including connections establishing)
tps = 103302.907780 (excluding connections establishing)
SQL script 1: <builtin: TPC-B (sort of)>
 - weight = 1 (targets 25.0% of total)
 - 30533935 transactions (24.6% of total, tps = 25444.587086)
 - latency average = 7.218 ms
 - latency stddev = 5.409 ms
SQL script 2: <builtin: select only>
 - weight = 3 (targets 75.0% of total)
 - 90442530 transactions (73.0% of total, tps = 75367.712378)
 - latency average = 0.901 ms
 - latency stddev = 2.139 ms
CHECKPOINT