Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- [sekikn@mobile ycsb-0.10.0-RC1]$ grep -v ^# jdbc-binding/conf/db.properties | grep '[^ ]'
- jdbc.driver=org.postgresql.Driver
- db.url=jdbc:postgresql://localhost/foo
- db.user=sekikn
- db.passwd=
- [sekikn@mobile ycsb-0.10.0-RC1]$ for i in {a..f}; do
- > echo "==== Workload ${i} ===="
- > psql foo -c "truncate table usertable"
- > bin/ycsb load jdbc -P workloads/workload${i} -P jdbc-binding/conf/db.properties -cp ~/postgresql-9.4.1208.jar 2>/dev/null
- > bin/ycsb run jdbc -P workloads/workload${i} -P jdbc-binding/conf/db.properties -cp ~/postgresql-9.4.1208.jar -p db.batchsize=100 2>/dev/null
- > echo
- > done
- ==== Workload a ====
- TRUNCATE TABLE
- Adding shard node URL: jdbc:postgresql://localhost/foo
- Using shards: 1, batchSize:-1, fetchSize: -1
- [OVERALL], RunTime(ms), 789.0
- [OVERALL], Throughput(ops/sec), 1267.427122940431
- [TOTAL_GCS_PS_Scavenge], Count, 1.0
- [TOTAL_GC_TIME_PS_Scavenge], Time(ms), 4.0
- [TOTAL_GC_TIME_%_PS_Scavenge], Time(%), 0.5069708491761723
- [TOTAL_GCS_PS_MarkSweep], Count, 0.0
- [TOTAL_GC_TIME_PS_MarkSweep], Time(ms), 0.0
- [TOTAL_GC_TIME_%_PS_MarkSweep], Time(%), 0.0
- [TOTAL_GCs], Count, 1.0
- [TOTAL_GC_TIME], Time(ms), 4.0
- [TOTAL_GC_TIME_%], Time(%), 0.5069708491761723
- [CLEANUP], Operations, 1.0
- [CLEANUP], AverageLatency(us), 735.0
- [CLEANUP], MinLatency(us), 735.0
- [CLEANUP], MaxLatency(us), 735.0
- [CLEANUP], 95thPercentileLatency(us), 735.0
- [CLEANUP], 99thPercentileLatency(us), 735.0
- [INSERT], Operations, 1000.0
- [INSERT], AverageLatency(us), 512.613
- [INSERT], MinLatency(us), 249.0
- [INSERT], MaxLatency(us), 22735.0
- [INSERT], 95thPercentileLatency(us), 1058.0
- [INSERT], 99thPercentileLatency(us), 2277.0
- [INSERT], Return=OK, 1000
- Adding shard node URL: jdbc:postgresql://localhost/foo
- Using shards: 1, batchSize:100, fetchSize: -1
- [OVERALL], RunTime(ms), 896.0
- [OVERALL], Throughput(ops/sec), 1116.0714285714287
- [TOTAL_GCS_PS_Scavenge], Count, 0.0
- [TOTAL_GC_TIME_PS_Scavenge], Time(ms), 0.0
- [TOTAL_GC_TIME_%_PS_Scavenge], Time(%), 0.0
- [TOTAL_GCS_PS_MarkSweep], Count, 0.0
- [TOTAL_GC_TIME_PS_MarkSweep], Time(ms), 0.0
- [TOTAL_GC_TIME_%_PS_MarkSweep], Time(%), 0.0
- [TOTAL_GCs], Count, 0.0
- [TOTAL_GC_TIME], Time(ms), 0.0
- [TOTAL_GC_TIME_%], Time(%), 0.0
- [READ], Operations, 472.0
- [READ], AverageLatency(us), 605.3940677966102
- [READ], MinLatency(us), 334.0
- [READ], MaxLatency(us), 64863.0
- [READ], 95thPercentileLatency(us), 689.0
- [READ], 99thPercentileLatency(us), 1217.0
- [READ], Return=OK, 472
- [CLEANUP], Operations, 1.0
- [CLEANUP], AverageLatency(us), 1259.0
- [CLEANUP], MinLatency(us), 1259.0
- [CLEANUP], MaxLatency(us), 1259.0
- [CLEANUP], 95thPercentileLatency(us), 1259.0
- [CLEANUP], 99thPercentileLatency(us), 1259.0
- [UPDATE], Operations, 528.0
- [UPDATE], AverageLatency(us), 746.373106060606
- [UPDATE], MinLatency(us), 491.0
- [UPDATE], MaxLatency(us), 4583.0
- [UPDATE], 95thPercentileLatency(us), 1040.0
- [UPDATE], 99thPercentileLatency(us), 1283.0
- [UPDATE], Return=OK, 528
- ==== Workload b ====
- TRUNCATE TABLE
- Adding shard node URL: jdbc:postgresql://localhost/foo
- Using shards: 1, batchSize:-1, fetchSize: -1
- [OVERALL], RunTime(ms), 749.0
- [OVERALL], Throughput(ops/sec), 1335.1134846461948
- [TOTAL_GCS_PS_Scavenge], Count, 1.0
- [TOTAL_GC_TIME_PS_Scavenge], Time(ms), 5.0
- [TOTAL_GC_TIME_%_PS_Scavenge], Time(%), 0.6675567423230975
- [TOTAL_GCS_PS_MarkSweep], Count, 0.0
- [TOTAL_GC_TIME_PS_MarkSweep], Time(ms), 0.0
- [TOTAL_GC_TIME_%_PS_MarkSweep], Time(%), 0.0
- [TOTAL_GCs], Count, 1.0
- [TOTAL_GC_TIME], Time(ms), 5.0
- [TOTAL_GC_TIME_%], Time(%), 0.6675567423230975
- [CLEANUP], Operations, 1.0
- [CLEANUP], AverageLatency(us), 1182.0
- [CLEANUP], MinLatency(us), 1182.0
- [CLEANUP], MaxLatency(us), 1182.0
- [CLEANUP], 95thPercentileLatency(us), 1182.0
- [CLEANUP], 99thPercentileLatency(us), 1182.0
- [INSERT], Operations, 1000.0
- [INSERT], AverageLatency(us), 522.159
- [INSERT], MinLatency(us), 233.0
- [INSERT], MaxLatency(us), 28591.0
- [INSERT], 95thPercentileLatency(us), 1200.0
- [INSERT], 99thPercentileLatency(us), 2427.0
- [INSERT], Return=OK, 1000
- Adding shard node URL: jdbc:postgresql://localhost/foo
- Using shards: 1, batchSize:100, fetchSize: -1
- [OVERALL], RunTime(ms), 707.0
- [OVERALL], Throughput(ops/sec), 1414.4271570014143
- [TOTAL_GCS_PS_Scavenge], Count, 0.0
- [TOTAL_GC_TIME_PS_Scavenge], Time(ms), 0.0
- [TOTAL_GC_TIME_%_PS_Scavenge], Time(%), 0.0
- [TOTAL_GCS_PS_MarkSweep], Count, 0.0
- [TOTAL_GC_TIME_PS_MarkSweep], Time(ms), 0.0
- [TOTAL_GC_TIME_%_PS_MarkSweep], Time(%), 0.0
- [TOTAL_GCs], Count, 0.0
- [TOTAL_GC_TIME], Time(ms), 0.0
- [TOTAL_GC_TIME_%], Time(%), 0.0
- [READ], Operations, 941.0
- [READ], AverageLatency(us), 455.92136025504783
- [READ], MinLatency(us), 301.0
- [READ], MaxLatency(us), 30991.0
- [READ], 95thPercentileLatency(us), 642.0
- [READ], 99thPercentileLatency(us), 1002.0
- [READ], Return=OK, 941
- [CLEANUP], Operations, 1.0
- [CLEANUP], AverageLatency(us), 1255.0
- [CLEANUP], MinLatency(us), 1255.0
- [CLEANUP], MaxLatency(us), 1255.0
- [CLEANUP], 95thPercentileLatency(us), 1255.0
- [CLEANUP], 99thPercentileLatency(us), 1255.0
- [UPDATE], Operations, 59.0
- [UPDATE], AverageLatency(us), 1081.1694915254238
- [UPDATE], MinLatency(us), 768.0
- [UPDATE], MaxLatency(us), 6987.0
- [UPDATE], 95thPercentileLatency(us), 1363.0
- [UPDATE], 99thPercentileLatency(us), 1691.0
- [UPDATE], Return=OK, 59
- ==== Workload c ====
- TRUNCATE TABLE
- Adding shard node URL: jdbc:postgresql://localhost/foo
- Using shards: 1, batchSize:-1, fetchSize: -1
- [OVERALL], RunTime(ms), 743.0
- [OVERALL], Throughput(ops/sec), 1345.8950201884254
- [TOTAL_GCS_PS_Scavenge], Count, 1.0
- [TOTAL_GC_TIME_PS_Scavenge], Time(ms), 4.0
- [TOTAL_GC_TIME_%_PS_Scavenge], Time(%), 0.5383580080753702
- [TOTAL_GCS_PS_MarkSweep], Count, 0.0
- [TOTAL_GC_TIME_PS_MarkSweep], Time(ms), 0.0
- [TOTAL_GC_TIME_%_PS_MarkSweep], Time(%), 0.0
- [TOTAL_GCs], Count, 1.0
- [TOTAL_GC_TIME], Time(ms), 4.0
- [TOTAL_GC_TIME_%], Time(%), 0.5383580080753702
- [CLEANUP], Operations, 1.0
- [CLEANUP], AverageLatency(us), 915.0
- [CLEANUP], MinLatency(us), 915.0
- [CLEANUP], MaxLatency(us), 915.0
- [CLEANUP], 95thPercentileLatency(us), 915.0
- [CLEANUP], 99thPercentileLatency(us), 915.0
- [INSERT], Operations, 1000.0
- [INSERT], AverageLatency(us), 511.959
- [INSERT], MinLatency(us), 270.0
- [INSERT], MaxLatency(us), 22287.0
- [INSERT], 95thPercentileLatency(us), 1189.0
- [INSERT], 99thPercentileLatency(us), 2391.0
- [INSERT], Return=OK, 1000
- Adding shard node URL: jdbc:postgresql://localhost/foo
- Using shards: 1, batchSize:100, fetchSize: -1
- [OVERALL], RunTime(ms), 679.0
- [OVERALL], Throughput(ops/sec), 1472.7540500736377
- [TOTAL_GCS_PS_Scavenge], Count, 0.0
- [TOTAL_GC_TIME_PS_Scavenge], Time(ms), 0.0
- [TOTAL_GC_TIME_%_PS_Scavenge], Time(%), 0.0
- [TOTAL_GCS_PS_MarkSweep], Count, 0.0
- [TOTAL_GC_TIME_PS_MarkSweep], Time(ms), 0.0
- [TOTAL_GC_TIME_%_PS_MarkSweep], Time(%), 0.0
- [TOTAL_GCs], Count, 0.0
- [TOTAL_GC_TIME], Time(ms), 0.0
- [TOTAL_GC_TIME_%], Time(%), 0.0
- [READ], Operations, 1000.0
- [READ], AverageLatency(us), 459.845
- [READ], MinLatency(us), 324.0
- [READ], MaxLatency(us), 31935.0
- [READ], 95thPercentileLatency(us), 655.0
- [READ], 99thPercentileLatency(us), 867.0
- [READ], Return=OK, 1000
- [CLEANUP], Operations, 1.0
- [CLEANUP], AverageLatency(us), 1190.0
- [CLEANUP], MinLatency(us), 1190.0
- [CLEANUP], MaxLatency(us), 1190.0
- [CLEANUP], 95thPercentileLatency(us), 1190.0
- [CLEANUP], 99thPercentileLatency(us), 1190.0
- ==== Workload d ====
- TRUNCATE TABLE
- Adding shard node URL: jdbc:postgresql://localhost/foo
- Using shards: 1, batchSize:-1, fetchSize: -1
- [OVERALL], RunTime(ms), 734.0
- [OVERALL], Throughput(ops/sec), 1362.3978201634877
- [TOTAL_GCS_PS_Scavenge], Count, 1.0
- [TOTAL_GC_TIME_PS_Scavenge], Time(ms), 5.0
- [TOTAL_GC_TIME_%_PS_Scavenge], Time(%), 0.6811989100817438
- [TOTAL_GCS_PS_MarkSweep], Count, 0.0
- [TOTAL_GC_TIME_PS_MarkSweep], Time(ms), 0.0
- [TOTAL_GC_TIME_%_PS_MarkSweep], Time(%), 0.0
- [TOTAL_GCs], Count, 1.0
- [TOTAL_GC_TIME], Time(ms), 5.0
- [TOTAL_GC_TIME_%], Time(%), 0.6811989100817438
- [CLEANUP], Operations, 1.0
- [CLEANUP], AverageLatency(us), 889.0
- [CLEANUP], MinLatency(us), 889.0
- [CLEANUP], MaxLatency(us), 889.0
- [CLEANUP], 95thPercentileLatency(us), 889.0
- [CLEANUP], 99thPercentileLatency(us), 889.0
- [INSERT], Operations, 1000.0
- [INSERT], AverageLatency(us), 508.842
- [INSERT], MinLatency(us), 277.0
- [INSERT], MaxLatency(us), 22431.0
- [INSERT], 95thPercentileLatency(us), 1086.0
- [INSERT], 99thPercentileLatency(us), 2711.0
- [INSERT], Return=OK, 1000
- Adding shard node URL: jdbc:postgresql://localhost/foo
- Using shards: 1, batchSize:100, fetchSize: -1
- [OVERALL], RunTime(ms), 696.0
- [OVERALL], Throughput(ops/sec), 1436.7816091954023
- [TOTAL_GCS_PS_Scavenge], Count, 0.0
- [TOTAL_GC_TIME_PS_Scavenge], Time(ms), 0.0
- [TOTAL_GC_TIME_%_PS_Scavenge], Time(%), 0.0
- [TOTAL_GCS_PS_MarkSweep], Count, 0.0
- [TOTAL_GC_TIME_PS_MarkSweep], Time(ms), 0.0
- [TOTAL_GC_TIME_%_PS_MarkSweep], Time(%), 0.0
- [TOTAL_GCs], Count, 0.0
- [TOTAL_GC_TIME], Time(ms), 0.0
- [TOTAL_GC_TIME_%], Time(%), 0.0
- [READ], Operations, 496.0
- [READ], AverageLatency(us), 546.5685483870968
- [READ], MinLatency(us), 312.0
- [READ], MaxLatency(us), 44991.0
- [READ], 95thPercentileLatency(us), 732.0
- [READ], 99thPercentileLatency(us), 940.0
- [READ], Return=OK, 496
- [READ], Return=NOT_FOUND, 447
- [CLEANUP], Operations, 1.0
- [CLEANUP], AverageLatency(us), 13940.0
- [CLEANUP], MinLatency(us), 13936.0
- [CLEANUP], MaxLatency(us), 13943.0
- [CLEANUP], 95thPercentileLatency(us), 13943.0
- [CLEANUP], 99thPercentileLatency(us), 13943.0
- [INSERT], Operations, 0.0
- [INSERT], AverageLatency(us), NaN
- [INSERT], MinLatency(us), 9.223372036854776E18
- [INSERT], MaxLatency(us), 0.0
- [INSERT], 95thPercentileLatency(us), 0.0
- [INSERT], 99thPercentileLatency(us), 0.0
- [INSERT], Return=BATCHED_OK, 57
- [READ-FAILED], Operations, 447.0
- [READ-FAILED], AverageLatency(us), 406.99328859060404
- [READ-FAILED], MinLatency(us), 297.0
- [READ-FAILED], MaxLatency(us), 1062.0
- [READ-FAILED], 95thPercentileLatency(us), 558.0
- [READ-FAILED], 99thPercentileLatency(us), 764.0
- [INSERT-FAILED], Operations, 57.0
- [INSERT-FAILED], AverageLatency(us), 404.6842105263158
- [INSERT-FAILED], MinLatency(us), 99.0
- [INSERT-FAILED], MaxLatency(us), 2541.0
- [INSERT-FAILED], 95thPercentileLatency(us), 713.0
- [INSERT-FAILED], 99thPercentileLatency(us), 824.0
- ==== Workload e ====
- TRUNCATE TABLE
- Adding shard node URL: jdbc:postgresql://localhost/foo
- Using shards: 1, batchSize:-1, fetchSize: -1
- [OVERALL], RunTime(ms), 757.0
- [OVERALL], Throughput(ops/sec), 1321.003963011889
- [TOTAL_GCS_PS_Scavenge], Count, 1.0
- [TOTAL_GC_TIME_PS_Scavenge], Time(ms), 4.0
- [TOTAL_GC_TIME_%_PS_Scavenge], Time(%), 0.5284015852047557
- [TOTAL_GCS_PS_MarkSweep], Count, 0.0
- [TOTAL_GC_TIME_PS_MarkSweep], Time(ms), 0.0
- [TOTAL_GC_TIME_%_PS_MarkSweep], Time(%), 0.0
- [TOTAL_GCs], Count, 1.0
- [TOTAL_GC_TIME], Time(ms), 4.0
- [TOTAL_GC_TIME_%], Time(%), 0.5284015852047557
- [CLEANUP], Operations, 1.0
- [CLEANUP], AverageLatency(us), 905.0
- [CLEANUP], MinLatency(us), 905.0
- [CLEANUP], MaxLatency(us), 905.0
- [CLEANUP], 95thPercentileLatency(us), 905.0
- [CLEANUP], 99thPercentileLatency(us), 905.0
- [INSERT], Operations, 1000.0
- [INSERT], AverageLatency(us), 525.105
- [INSERT], MinLatency(us), 259.0
- [INSERT], MaxLatency(us), 21631.0
- [INSERT], 95thPercentileLatency(us), 1218.0
- [INSERT], 99thPercentileLatency(us), 2727.0
- [INSERT], Return=OK, 1000
- Adding shard node URL: jdbc:postgresql://localhost/foo
- Using shards: 1, batchSize:100, fetchSize: -1
- [OVERALL], RunTime(ms), 1280.0
- [OVERALL], Throughput(ops/sec), 781.25
- [TOTAL_GCS_PS_Scavenge], Count, 4.0
- [TOTAL_GC_TIME_PS_Scavenge], Time(ms), 12.0
- [TOTAL_GC_TIME_%_PS_Scavenge], Time(%), 0.9375
- [TOTAL_GCS_PS_MarkSweep], Count, 0.0
- [TOTAL_GC_TIME_PS_MarkSweep], Time(ms), 0.0
- [TOTAL_GC_TIME_%_PS_MarkSweep], Time(%), 0.0
- [TOTAL_GCs], Count, 4.0
- [TOTAL_GC_TIME], Time(ms), 12.0
- [TOTAL_GC_TIME_%], Time(%), 0.9375
- [CLEANUP], Operations, 1.0
- [CLEANUP], AverageLatency(us), 14540.0
- [CLEANUP], MinLatency(us), 14536.0
- [CLEANUP], MaxLatency(us), 14543.0
- [CLEANUP], 95thPercentileLatency(us), 14543.0
- [CLEANUP], 99thPercentileLatency(us), 14543.0
- [INSERT], Operations, 0.0
- [INSERT], AverageLatency(us), NaN
- [INSERT], MinLatency(us), 9.223372036854776E18
- [INSERT], MaxLatency(us), 0.0
- [INSERT], 95thPercentileLatency(us), 0.0
- [INSERT], 99thPercentileLatency(us), 0.0
- [INSERT], Return=BATCHED_OK, 57
- [SCAN], Operations, 943.0
- [SCAN], AverageLatency(us), 1074.219512195122
- [SCAN], MinLatency(us), 428.0
- [SCAN], MaxLatency(us), 46495.0
- [SCAN], 95thPercentileLatency(us), 1588.0
- [SCAN], 99thPercentileLatency(us), 2371.0
- [SCAN], Return=OK, 943
- [INSERT-FAILED], Operations, 57.0
- [INSERT-FAILED], AverageLatency(us), 430.10526315789474
- [INSERT-FAILED], MinLatency(us), 111.0
- [INSERT-FAILED], MaxLatency(us), 2397.0
- [INSERT-FAILED], 95thPercentileLatency(us), 976.0
- [INSERT-FAILED], 99thPercentileLatency(us), 1229.0
- ==== Workload f ====
- TRUNCATE TABLE
- Adding shard node URL: jdbc:postgresql://localhost/foo
- Using shards: 1, batchSize:-1, fetchSize: -1
- [OVERALL], RunTime(ms), 763.0
- [OVERALL], Throughput(ops/sec), 1310.615989515072
- [TOTAL_GCS_PS_Scavenge], Count, 1.0
- [TOTAL_GC_TIME_PS_Scavenge], Time(ms), 4.0
- [TOTAL_GC_TIME_%_PS_Scavenge], Time(%), 0.5242463958060288
- [TOTAL_GCS_PS_MarkSweep], Count, 0.0
- [TOTAL_GC_TIME_PS_MarkSweep], Time(ms), 0.0
- [TOTAL_GC_TIME_%_PS_MarkSweep], Time(%), 0.0
- [TOTAL_GCs], Count, 1.0
- [TOTAL_GC_TIME], Time(ms), 4.0
- [TOTAL_GC_TIME_%], Time(%), 0.5242463958060288
- [CLEANUP], Operations, 1.0
- [CLEANUP], AverageLatency(us), 844.0
- [CLEANUP], MinLatency(us), 844.0
- [CLEANUP], MaxLatency(us), 844.0
- [CLEANUP], 95thPercentileLatency(us), 844.0
- [CLEANUP], 99thPercentileLatency(us), 844.0
- [INSERT], Operations, 1000.0
- [INSERT], AverageLatency(us), 523.683
- [INSERT], MinLatency(us), 250.0
- [INSERT], MaxLatency(us), 21119.0
- [INSERT], 95thPercentileLatency(us), 1253.0
- [INSERT], 99thPercentileLatency(us), 2999.0
- [INSERT], Return=OK, 1000
- Adding shard node URL: jdbc:postgresql://localhost/foo
- Using shards: 1, batchSize:100, fetchSize: -1
- [OVERALL], RunTime(ms), 1074.0
- [OVERALL], Throughput(ops/sec), 931.0986964618249
- [TOTAL_GCS_PS_Scavenge], Count, 0.0
- [TOTAL_GC_TIME_PS_Scavenge], Time(ms), 0.0
- [TOTAL_GC_TIME_%_PS_Scavenge], Time(%), 0.0
- [TOTAL_GCS_PS_MarkSweep], Count, 0.0
- [TOTAL_GC_TIME_PS_MarkSweep], Time(ms), 0.0
- [TOTAL_GC_TIME_%_PS_MarkSweep], Time(%), 0.0
- [TOTAL_GCs], Count, 0.0
- [TOTAL_GC_TIME], Time(ms), 0.0
- [TOTAL_GC_TIME_%], Time(%), 0.0
- [READ], Operations, 1000.0
- [READ], AverageLatency(us), 470.886
- [READ], MinLatency(us), 324.0
- [READ], MaxLatency(us), 33823.0
- [READ], 95thPercentileLatency(us), 690.0
- [READ], 99thPercentileLatency(us), 1040.0
- [READ], Return=OK, 1000
- [READ-MODIFY-WRITE], Operations, 504.0
- [READ-MODIFY-WRITE], AverageLatency(us), 1342.3035714285713
- [READ-MODIFY-WRITE], MinLatency(us), 854.0
- [READ-MODIFY-WRITE], MaxLatency(us), 75583.0
- [READ-MODIFY-WRITE], 95thPercentileLatency(us), 1815.0
- [READ-MODIFY-WRITE], 99thPercentileLatency(us), 2733.0
- [CLEANUP], Operations, 1.0
- [CLEANUP], AverageLatency(us), 1243.0
- [CLEANUP], MinLatency(us), 1243.0
- [CLEANUP], MaxLatency(us), 1243.0
- [CLEANUP], 95thPercentileLatency(us), 1243.0
- [CLEANUP], 99thPercentileLatency(us), 1243.0
- [UPDATE], Operations, 504.0
- [UPDATE], AverageLatency(us), 741.9047619047619
- [UPDATE], MinLatency(us), 494.0
- [UPDATE], MaxLatency(us), 6611.0
- [UPDATE], 95thPercentileLatency(us), 1087.0
- [UPDATE], 99thPercentileLatency(us), 1607.0
- [UPDATE], Return=OK, 504
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement