Inserts
cassandra-stress user profile=blogpost.yaml ops\(insert=1\) > inserts.txt
tail -f inserts.txt
******************** Stress Settings ********************
Command:
Type: user
Count: -1
No Warmup: false
Consistency Level: LOCAL_ONE
Target Uncertainty: 0.020
Minimum Uncertainty Measurements: 30
Maximum Uncertainty Measurements: 200
Command Ratios: {insert=1.0}
Command Clustering Distribution: clustering=gaussian(1..10)
Profile File: blogpost.yaml
Rate:
Auto: true
Min Threads: 4
Max Threads: 1000
Population:
Sequence: 1..1000000
Order: ARBITRARY
Wrap: true
Insert:
Revisits: Uniform: min=1,max=1000000
Visits: Fixed: key=1
Row Population Ratio: Ratio: divisor=1.000000;delegate=Fixed: key=1
Batch Type: not batching
Errors:
Ignore: false
Tries: 10
Log:
No Summary: false
No Settings: false
File: null
Interval Millis: 1000
Level: NORMAL
Mode:
API: JAVA_DRIVER_NATIVE
Connection Style: CQL_PREPARED
CQL Version: CQL3
Protocol Version: V4
Username: null
Password: null
Auth Provide Class: null
Max Pending Per Connection: 128
Connections Per Host: 8
Compression: NONE
Node:
Nodes: [localhost]
Is White List: false
Datacenter: null
Schema:
Keyspace: stresscql
Replication Strategy: org.apache.cassandra.locator.SimpleStrategy
Replication Strategy Pptions: {replication_factor=1}
Table Compression: null
Table Compaction Strategy: null
Table Compaction Strategy Options: {}
Transport:
factory=org.apache.cassandra.thrift.TFramedTransportFactory; truststore=null; truststore-password=null; keystore=null; keystore-password=null; ssl-protocol=TLS; ssl-alg=SunX509; store-type=JKS; ssl-ciphers=TLS_RSA_WITH_AES_128_CBC_SHA,TLS_RSA_WITH_AES_256_CBC_SHA;
Port:
Native Port: 9042
Thrift Port: 9160
JMX Port: 7199
Send To Daemon:
*not set*
Graph:
File: null
Revision: unknown
Title: null
Operation: USER
TokenRange:
Wrap: false
Split Factor: 1
******************** Profile ********************
Keyspace Name: stresscql
Keyspace CQL:
***
CREATE KEYSPACE stresscql WITH replication = {'class': 'SimpleStrategy', 'replication_factor': 1};
***
Table Name: blogposts
Table CQL:
***
CREATE TABLE blogposts (
domain text,
published_date timeuuid,
url text,
author text,
title text,
body text,
PRIMARY KEY(domain, published_date)
) WITH CLUSTERING ORDER BY (published_date DESC)
AND compaction = { 'class':'LeveledCompactionStrategy' }
AND comment='A table to hold blog posts'
***
Extra Schema Definitions: null
Generator Configs:
author: Size: Uniform: min=5,max=20;
domain: Size: Gaussian: min=5,max=100,mean=52.500000,stdev=15.833333;Identity: Uniform: min=1,max=10000000;
title: Size: Gaussian: min=10,max=200,mean=105.000000,stdev=31.666667;
body: Size: Gaussian: min=100,max=5000,mean=2550.000000,stdev=816.666667;
published_date: Clustering: Fixed: key=1000;
url: Size: Uniform: min=30,max=300;
Query Definitions:
singlepost: CQL:select * from blogposts where domain = ? LIMIT 1;Fields:samerow;
timeline: CQL:select url, title, published_date from blogposts where domain = ? LIMIT 10;Fields:samerow;
Token Range Queries:
Insert Settings:
partitions: fixed(1)
select: fixed(1)/1000
batchtype: UNLOGGED
Connected to cluster: Test Cluster, max pending requests per connection 128, max connections per host 8
Datatacenter: datacenter1; Host: localhost/127.0.0.1; Rack: rack1
Created schema. Sleeping 1s for propagation.
Generating batches with [1..1] partitions and [1..1] rows (of [1000..1000] total rows in the partitions)
Sleeping 2s...
Warming up insert with 0 iterations...
Thread count was not specified
WARNING: uncertainty mode (err<) results in uneven workload between thread runs, so should be used for high level analysis only
Running with 4 threadCount
Running [insert] with 4 threads until stderr of mean < 0.02
type total ops, op/s, pk/s, row/s, mean, med, .95, .99, .999, max, time, stderr, errors, gc:
total, 3195, 3195, 3195, 4386, 1.0, 0.6, 3.2, 9.1, 21.0, 22.8, 1.0, 0.00000, 0, 0, 0, 0, 0, 0
total, 7886, 4691, 4691, 6371, 0.7, 0.4, 1.7, 7.9, 18.8, 27.5, 2.0, 0.13214, 0, 0, 0, 0, 0, 0
total, 16942, 9056, 9056, 12308, 0.3, 0.3, 0.6, 1.1, 15.1, 26.4, 3.0, 0.25315, 0, 0, 0, 0, 0, 0
total, 28447, 11505, 11505, 15853, 0.3, 0.2, 0.4, 0.7, 4.1, 22.7, 4.0, 0.23503, 0, 0, 0, 0, 0, 0
total, 38909, 10462, 10462, 14285, 0.3, 0.2, 0.4, 0.6, 3.1, 117.6, 5.0, 0.19435, 0, 1, 108, 108, 0, 1143
total, 50467, 11558, 11558, 15810, 0.3, 0.2, 0.4, 0.6, 3.8, 25.5, 6.0, 0.16345, 0, 0, 0, 0, 0, 0
total, 62289, 11822, 11822, 16058, 0.2, 0.2, 0.4, 0.6, 4.1, 18.1, 7.0, 0.14067, 0, 0, 0, 0, 0, 0
total, 74033, 11744, 11744, 15914, 0.3, 0.2, 0.4, 0.5, 2.8, 23.4, 8.0, 0.12315, 0, 0, 0, 0, 0, 0
total, 84393, 10360, 10360, 14302, 0.3, 0.2, 0.4, 0.7, 1.4, 19.1, 9.0, 0.10874, 0, 0, 0, 0, 0, 0
total, 94139, 9746, 9746, 13373, 0.3, 0.2, 0.4, 0.6, 1.5, 141.0, 10.0, 0.09754, 0, 1, 132, 132, 0, 986
total, 105293, 11154, 11154, 15135, 0.3, 0.2, 0.4, 0.5, 1.0, 23.9, 11.0, 0.08841, 0, 0, 0, 0, 0, 0
total, 115596, 10303, 10303, 13949, 0.3, 0.2, 0.4, 0.7, 1.0, 11.9, 12.0, 0.08087, 0, 0, 0, 0, 0, 0
total, 127165, 11569, 11569, 15740, 0.2, 0.2, 0.4, 0.5, 1.0, 9.3, 13.0, 0.07464, 0, 0, 0, 0, 0, 0
total, 138796, 11631, 11631, 15876, 0.2, 0.2, 0.4, 0.5, 1.0, 10.0, 14.0, 0.06936, 0, 0, 0, 0, 0, 0
total, 149283, 10487, 10487, 14447, 0.3, 0.2, 0.4, 0.8, 7.0, 27.8, 15.0, 0.06459, 0, 0, 0, 0, 0, 0
total, 158544, 9261, 9261, 12577, 0.3, 0.2, 0.4, 0.8, 8.2, 120.6, 16.0, 0.06051, 0, 1, 107, 107, 0, 984
total, 168482, 9938, 9938, 13511, 0.3, 0.2, 0.4, 0.8, 7.6, 38.4, 17.0, 0.05696, 0, 0, 0, 0, 0, 0
total, 179453, 10971, 10971, 15017, 0.3, 0.2, 0.4, 0.6, 3.5, 22.6, 18.0, 0.05375, 0, 0, 0, 0, 0, 0
total, 190360, 10907, 10907, 14817, 0.3, 0.2, 0.4, 0.6, 1.8, 20.5, 19.0, 0.05085, 0, 0, 0, 0, 0, 0
total, 201679, 11319, 11319, 15393, 0.3, 0.2, 0.4, 0.5, 0.9, 2.4, 20.0, 0.04828, 0, 0, 0, 0, 0, 0
total, 212883, 11204, 11204, 15387, 0.3, 0.2, 0.4, 0.5, 0.7, 15.3, 21.0, 0.04598, 0, 0, 0, 0, 0, 0
total, 223320, 10437, 10437, 14267, 0.3, 0.2, 0.4, 0.5, 0.8, 113.4, 22.0, 0.04398, 0, 1, 112, 112, 0, 990
total, 235283, 11963, 11963, 16283, 0.2, 0.2, 0.4, 0.5, 0.7, 8.2, 23.0, 0.04222, 0, 0, 0, 0, 0, 0
total, 247185, 11902, 11902, 16374, 0.2, 0.2, 0.4, 0.4, 0.8, 22.1, 24.0, 0.04068, 0, 0, 0, 0, 0, 0
total, 259288, 12103, 12103, 16679, 0.2, 0.2, 0.4, 0.5, 0.6, 1.0, 25.0, 0.03923, 0, 0, 0, 0, 0, 0
total, 271027, 11739, 11739, 16049, 0.2, 0.2, 0.4, 0.5, 0.8, 19.0, 26.0, 0.03780, 0, 0, 0, 0, 0, 0
total, 281934, 10907, 10907, 15049, 0.2, 0.2, 0.3, 0.4, 0.9, 9.2, 27.0, 0.03637, 0, 1, 107, 107, 0, 970
total, 292601, 10667, 10667, 14521, 0.3, 0.2, 0.4, 0.7, 10.5, 108.9, 28.0, 0.03513, 0, 0, 0, 0, 0, 0
total, 303462, 10861, 10861, 14759, 0.3, 0.2, 0.4, 0.7, 1.2, 20.9, 29.0, 0.03390, 0, 0, 0, 0, 0, 0
total, 314073, 10611, 10611, 14495, 0.3, 0.3, 0.4, 0.7, 2.5, 15.8, 30.0, 0.03278, 0, 0, 0, 0, 0, 0
total, 324272, 10199, 10199, 14014, 0.3, 0.3, 0.4, 0.6, 5.0, 26.2, 31.0, 0.03177, 0, 0, 0, 0, 0, 0
total, 334188, 9916, 9916, 13600, 0.3, 0.3, 0.5, 0.9, 10.2, 25.5, 32.0, 0.03088, 0, 0, 0, 0, 0, 0
total, 344227, 10039, 10039, 13722, 0.3, 0.2, 0.4, 0.6, 2.3, 98.4, 33.0, 0.02993, 0, 1, 95, 95, 0, 1013
total, 355343, 11116, 11116, 15297, 0.3, 0.2, 0.4, 0.6, 1.3, 7.5, 34.0, 0.02904, 0, 0, 0, 0, 0, 0
total, 366176, 10833, 10833, 14830, 0.3, 0.2, 0.4, 0.5, 0.9, 33.8, 35.0, 0.02820, 0, 0, 0, 0, 0, 0
total, 377061, 10885, 10885, 14907, 0.3, 0.3, 0.4, 0.5, 0.7, 13.7, 36.0, 0.02741, 0, 0, 0, 0, 0, 0
total, 387912, 10851, 10851, 14865, 0.3, 0.2, 0.4, 0.5, 1.0, 17.7, 37.0, 0.02666, 0, 0, 0, 0, 0, 0
total, 397439, 9527, 9527, 13113, 0.3, 0.3, 0.4, 0.6, 2.0, 103.9, 38.0, 0.02597, 0, 1, 102, 102, 0, 1002
total, 407727, 10288, 10288, 14107, 0.3, 0.3, 0.4, 0.6, 1.5, 15.9, 39.0, 0.02534, 0, 0, 0, 0, 0, 0
total, 418056, 10329, 10329, 14200, 0.3, 0.3, 0.5, 0.7, 1.5, 16.2, 40.0, 0.02474, 0, 0, 0, 0, 0, 0
total, 428446, 10390, 10390, 14261, 0.3, 0.2, 0.4, 0.6, 1.7, 30.4, 41.0, 0.02414, 0, 0, 0, 0, 0, 0
total, 439428, 10982, 10982, 15183, 0.3, 0.2, 0.4, 0.6, 1.2, 14.7, 42.0, 0.02356, 0, 0, 0, 0, 0, 0
total, 449465, 10037, 10037, 13785, 0.3, 0.2, 0.4, 0.6, 1.1, 83.4, 43.0, 0.02301, 0, 1, 78, 78, 0, 1022
total, 459413, 9948, 9948, 13711, 0.3, 0.2, 0.4, 0.7, 3.9, 25.3, 44.0, 0.02254, 0, 0, 0, 0, 0, 0
total, 469692, 10279, 10279, 14036, 0.3, 0.3, 0.4, 0.6, 1.0, 20.5, 45.0, 0.02207, 0, 0, 0, 0, 0, 0
total, 480258, 10566, 10566, 14489, 0.3, 0.2, 0.4, 0.5, 0.9, 14.7, 46.0, 0.02159, 0, 0, 0, 0, 0, 0
total, 490941, 10683, 10683, 14712, 0.3, 0.2, 0.4, 0.5, 0.8, 1.4, 47.0, 0.02114, 0, 0, 0, 0, 0, 0
total, 501669, 10728, 10728, 14736, 0.3, 0.2, 0.4, 0.5, 1.0, 12.7, 48.0, 0.02069, 0, 0, 0, 0, 0, 0
total, 511374, 9705, 9705, 13221, 0.3, 0.2, 0.4, 0.5, 0.7, 120.5, 49.0, 0.02027, 0, 1, 114, 114, 0, 1007
total, 522025, 10651, 10651, 14730, 0.3, 0.2, 0.4, 0.5, 0.9, 14.2, 50.0, 0.01986, 0, 0, 0, 0, 0, 0
total, 522041, 4202, 4202, 6566, 0.5, 0.3, 1.0, 2.5, 2.5, 2.5, 50.0, 0.02007, 0, 0, 0, 0, 0, 0
Results:
Op rate : 10,440 op/s [insert: 10,440 op/s]
Partition rate : 10,440 pk/s [insert: 10,440 pk/s]
Row rate : 14,289 row/s [insert: 14,289 row/s]
Latency mean : 0.3 ms [insert: 0.3 ms]
Latency median : 0.2 ms [insert: 0.2 ms]
Latency 95th percentile : 0.4 ms [insert: 0.4 ms]
Latency 99th percentile : 0.7 ms [insert: 0.7 ms]
Latency 99.9th percentile : 5.2 ms [insert: 5.2 ms]
Latency max : 141.0 ms [insert: 141.0 ms]
Total partitions : 522,041 [insert: 522,041]
Total errors : 0 [insert: 0]
Total GC count : 9
Total GC memory : 8.904 GiB
Total GC time : 1.0 seconds
Avg GC time : 106.1 ms
StdDev GC time : 13.8 ms
Total operation time : 00:00:50
Sleeping for 15s
Running with 8 threadCount
Running [insert] with 8 threads until stderr of mean < 0.02
type total ops, op/s, pk/s, row/s, mean, med, .95, .99, .999, max, time, stderr, errors, gc:
total, 13548, 13548, 13548, 18434, 0.5, 0.4, 0.8, 2.5, 12.6, 26.0, 1.0, 0.00000, 0, 0, 0, 0, 0, 0
total, 30423, 16875, 16875, 23128, 0.4, 0.3, 0.6, 0.8, 5.9, 74.9, 2.0, 0.09780, 0, 1, 73, 73, 0, 1079
total, 48444, 18021, 18021, 24614, 0.3, 0.3, 0.6, 0.8, 1.4, 23.6, 3.0, 0.07302, 0, 0, 0, 0, 0, 0
total, 65639, 17195, 17195, 23494, 0.4, 0.3, 0.6, 0.9, 4.4, 32.9, 4.0, 0.05526, 0, 0, 0, 0, 0, 0
total, 82627, 16988, 16988, 23285, 0.4, 0.3, 0.6, 0.8, 3.7, 14.1, 5.0, 0.04415, 0, 0, 0, 0, 0, 0
total, 99761, 17134, 17134, 23408, 0.4, 0.3, 0.6, 0.9, 6.0, 69.1, 6.0, 0.03802, 0, 1, 67, 67, 0, 1017
total, 117943, 18182, 18182, 24915, 0.3, 0.3, 0.5, 0.7, 1.5, 20.2, 7.0, 0.03363, 0, 0, 0, 0, 0, 0
total, 134240, 16297, 16297, 22240, 0.4, 0.3, 0.6, 0.9, 8.9, 27.6, 8.0, 0.03006, 0, 0, 0, 0, 0, 0
total, 149970, 15730, 15730, 21480, 0.4, 0.3, 0.6, 0.8, 3.4, 111.8, 9.0, 0.02673, 0, 1, 110, 110, 0, 991
total, 167750, 17780, 17780, 24172, 0.3, 0.3, 0.6, 0.7, 5.2, 13.7, 10.0, 0.02413, 0, 0, 0, 0, 0, 0
total, 185442, 17692, 17692, 24172, 0.3, 0.3, 0.6, 0.8, 3.7, 19.6, 11.0, 0.02203, 0, 0, 0, 0, 0, 0
total, 203483, 18041, 18041, 24673, 0.3, 0.3, 0.6, 0.8, 4.1, 18.5, 12.0, 0.02048, 0, 0, 0, 0, 0, 0
total, 218471, 14988, 14988, 20489, 0.4, 0.3, 0.6, 0.9, 12.0, 110.4, 13.0, 0.01924, 0, 1, 104, 104, 0, 986
total, 235466, 16995, 16995, 23097, 0.4, 0.3, 0.6, 0.9, 1.5, 26.4, 14.0, 0.01790, 0, 0, 0, 0, 0, 0
total, 252149, 16683, 16683, 22747, 0.4, 0.3, 0.6, 0.9, 5.0, 24.3, 15.0, 0.01683, 0, 0, 0, 0, 0, 0
total, 267083, 14934, 14934, 20436, 0.4, 0.3, 0.6, 0.9, 12.3, 106.0, 16.0, 0.01606, 0, 1, 96, 96, 0, 1002
total, 284204, 17121, 17121, 23260, 0.4, 0.3, 0.6, 0.8, 5.0, 21.0, 17.0, 0.01512, 0, 0, 0, 0, 0, 0
total, 301965, 17761, 17761, 24481, 0.3, 0.3, 0.5, 0.7, 4.4, 25.1, 18.0, 0.01451, 0, 0, 0, 0, 0, 0
total, 319584, 17619, 17619, 24018, 0.3, 0.3, 0.5, 0.7, 8.3, 19.2, 19.0, 0.01379, 0, 0, 0, 0, 0, 0
total, 336029, 16445, 16445, 22428, 0.4, 0.3, 0.5, 0.7, 2.9, 109.7, 20.0, 0.01330, 0, 1, 107, 107, 0, 986
total, 353756, 17727, 17727, 24109, 0.3, 0.3, 0.5, 0.7, 4.1, 25.0, 21.0, 0.01272, 0, 0, 0, 0, 0, 0
total, 370484, 16728, 16728, 22969, 0.3, 0.3, 0.6, 0.9, 5.7, 23.0, 22.0, 0.01220, 0, 0, 0, 0, 0, 0
total, 386160, 15676, 15676, 21567, 0.4, 0.3, 0.5, 0.8, 4.8, 97.0, 23.0, 0.01167, 0, 1, 89, 89, 0, 1008
total, 403144, 16984, 16984, 23121, 0.3, 0.3, 0.6, 0.8, 5.0, 20.3, 24.0, 0.01122, 0, 0, 0, 0, 0, 0
total, 419058, 15914, 15914, 21867, 0.4, 0.3, 0.6, 0.9, 8.1, 18.2, 25.0, 0.01117, 0, 0, 0, 0, 0, 0
total, 436406, 17348, 17348, 23839, 0.3, 0.3, 0.5, 0.7, 1.9, 13.9, 26.0, 0.01074, 0, 0, 0, 0, 0, 0
total, 448020, 11614, 11614, 15867, 0.5, 0.3, 0.6, 0.8, 6.7, 281.3, 27.0, 0.01076, 0, 1, 112, 112, 0, 988
total, 463957, 15937, 15937, 21814, 0.4, 0.3, 0.6, 0.7, 8.1, 113.7, 28.0, 0.01042, 0, 0, 0, 0, 0, 0
total, 480977, 17020, 17020, 23191, 0.3, 0.3, 0.6, 0.8, 1.6, 17.2, 29.0, 0.01007, 0, 0, 0, 0, 0, 0
total, 497891, 16914, 16914, 23082, 0.4, 0.3, 0.6, 0.9, 7.4, 23.8, 30.0, 0.00974, 0, 0, 0, 0, 0, 0
total, 497929, 5080, 5080, 6550, 0.8, 0.3, 3.6, 3.8, 3.8, 3.8, 30.0, 0.01703, 0, 0, 0, 0, 0, 0
Results:
Op rate : 16,593 op/s [insert: 16,593 op/s]
Partition rate : 16,593 pk/s [insert: 16,593 pk/s]
Row rate : 22,676 row/s [insert: 22,676 row/s]
Latency mean : 0.4 ms [insert: 0.4 ms]
Latency median : 0.3 ms [insert: 0.3 ms]
Latency 95th percentile : 0.6 ms [insert: 0.6 ms]
Latency 99th percentile : 0.8 ms [insert: 0.8 ms]
Latency 99.9th percentile : 6.2 ms [insert: 6.2 ms]
Latency max : 281.3 ms [insert: 281.3 ms]
Total partitions : 497,929 [insert: 497,929]
Total errors : 0 [insert: 0]
Total GC count : 8
Total GC memory : 7.868 GiB
Total GC time : 0.8 seconds
Avg GC time : 94.8 ms
StdDev GC time : 16.0 ms
Total operation time : 00:00:30
Improvement over 4 threadCount: 59%
Sleeping for 15s
Running with 16 threadCount
Running [insert] with 16 threads until stderr of mean < 0.02
type total ops, op/s, pk/s, row/s, mean, med, .95, .99, .999, max, time, stderr, errors, gc:
total, 24413, 24413, 24413, 33411, 0.5, 0.5, 0.9, 1.8, 9.5, 32.5, 1.0, 0.00000, 0, 0, 0, 0, 0, 0
total, 48611, 24198, 24198, 33247, 0.5, 0.4, 0.9, 1.4, 9.9, 27.4, 2.0, 0.00360, 0, 0, 0, 0, 0, 0
total, 74085, 25474, 25474, 34606, 0.6, 0.4, 0.9, 1.7, 13.7, 73.5, 3.0, 0.02315, 0, 1, 64, 64, 0, 1054
total, 97075, 22990, 22990, 31530, 0.6, 0.5, 0.9, 1.4, 12.7, 69.0, 4.0, 0.01982, 0, 0, 0, 0, 0, 0
total, 118453, 21378, 21378, 29164, 0.6, 0.5, 0.9, 1.3, 23.7, 118.9, 5.0, 0.01875, 0, 1, 115, 115, 0, 974
total, 142730, 24277, 24277, 32970, 0.5, 0.5, 0.9, 1.4, 10.4, 21.2, 6.0, 0.01622, 0, 1, 71, 71, 0, 4248
total, 166120, 23390, 23390, 32160, 0.6, 0.5, 1.0, 1.7, 16.6, 43.5, 7.0, 0.01431, 0, 0, 0, 0, 0, 0
total, 189333, 23213, 23213, 31583, 0.6, 0.4, 0.9, 1.4, 10.8, 89.4, 8.0, 0.01256, 0, 1, 80, 80, 0, 1002
total, 213779, 24446, 24446, 33431, 0.5, 0.4, 0.9, 1.3, 19.7, 44.5, 9.0, 0.01130, 0, 0, 0, 0, 0, 0
total, 236173, 22394, 22394, 30575, 0.6, 0.5, 1.0, 1.6, 14.4, 29.7, 10.0, 0.01310, 0, 0, 0, 0, 0, 0
total, 257238, 21065, 21065, 28794, 0.6, 0.5, 0.9, 1.6, 29.5, 118.8, 11.0, 0.01254, 0, 1, 112, 112, 0, 973
total, 281443, 24205, 24205, 33076, 0.5, 0.4, 0.9, 1.5, 19.3, 33.8, 12.0, 0.01150, 0, 0, 0, 0, 0, 0
total, 303384, 21941, 21941, 29963, 0.6, 0.5, 1.0, 1.5, 14.3, 82.2, 13.0, 0.01107, 0, 1, 80, 80, 0, 980
total, 325752, 22368, 22368, 30561, 0.6, 0.5, 1.0, 1.6, 11.0, 67.9, 14.0, 0.01056, 0, 0, 0, 0, 0, 0
total, 350963, 25211, 25211, 34648, 0.5, 0.4, 0.9, 1.3, 12.6, 37.1, 15.0, 0.01062, 0, 0, 0, 0, 0, 0
total, 370547, 19584, 19584, 26764, 0.7, 0.5, 1.0, 2.0, 21.6, 111.2, 16.0, 0.01220, 0, 1, 109, 109, 0, 994
total, 393792, 23245, 23245, 31919, 0.5, 0.5, 0.9, 1.4, 9.0, 32.6, 17.0, 0.01157, 0, 0, 0, 0, 0, 0
total, 416060, 22268, 22268, 30356, 0.5, 0.5, 1.0, 1.5, 16.4, 29.6, 18.0, 0.01164, 0, 0, 0, 0, 0, 0
total, 436557, 20497, 20497, 28126, 0.6, 0.5, 0.9, 1.4, 20.9, 109.3, 19.0, 0.01147, 0, 1, 94, 94, 0, 975
total, 459800, 23243, 23243, 31832, 0.5, 0.5, 1.0, 1.4, 6.3, 31.6, 20.0, 0.01094, 0, 0, 0, 0, 0, 0
total, 482872, 23072, 23072, 31473, 0.5, 0.5, 1.0, 1.5, 11.6, 36.5, 21.0, 0.01049, 0, 0, 0, 0, 0, 0
total, 504265, 21393, 21393, 29433, 0.6, 0.4, 0.9, 1.4, 14.1, 106.2, 22.0, 0.01004, 0, 1, 104, 104, 0, 996
total, 526161, 21896, 21896, 30013, 0.6, 0.4, 0.9, 1.5, 18.8, 56.8, 23.0, 0.00982, 0, 0, 0, 0, 0, 0
total, 548384, 22223, 22223, 30339, 0.6, 0.5, 1.0, 1.5, 9.6, 46.6, 24.0, 0.00961, 0, 0, 0, 0, 0, 0
total, 568665, 20281, 20281, 27765, 0.6, 0.5, 1.0, 1.6, 17.6, 113.6, 25.0, 0.00952, 0, 1, 109, 109, 0, 968
total, 590268, 21603, 21603, 29419, 0.6, 0.5, 1.0, 1.5, 14.3, 37.7, 26.0, 0.00965, 0, 0, 0, 0, 0, 0
total, 611223, 20955, 20955, 28747, 0.6, 0.5, 1.0, 1.4, 18.5, 33.3, 27.0, 0.01002, 0, 1, 93, 93, 0, 1000
total, 633294, 22071, 22071, 30239, 0.6, 0.4, 0.9, 1.3, 15.8, 102.8, 28.0, 0.00969, 0, 0, 0, 0, 0, 0
total, 653979, 20685, 20685, 28305, 0.6, 0.5, 1.0, 1.8, 11.3, 31.7, 29.0, 0.01016, 0, 0, 0, 0, 0, 0
total, 675742, 21763, 21763, 29763, 0.5, 0.5, 0.9, 1.3, 10.0, 23.3, 30.0, 0.01012, 0, 1, 99, 99, 0, 983
total, 675758, 304, 304, 704, 107.2, 108.9, 109.6, 112.2, 112.2, 112.2, 30.1, 0.03493, 0, 0, 0, 0, 0, 0
Results:
Op rate : 22,486 op/s [insert: 22,486 op/s]
Partition rate : 22,486 pk/s [insert: 22,486 pk/s]
Row rate : 30,754 row/s [insert: 30,754 row/s]
Latency mean : 0.6 ms [insert: 0.6 ms]
Latency median : 0.5 ms [insert: 0.5 ms]
Latency 95th percentile : 0.9 ms [insert: 0.9 ms]
Latency 99th percentile : 1.5 ms [insert: 1.5 ms]
Latency 99.9th percentile : 15.7 ms [insert: 15.7 ms]
Latency max : 118.9 ms [insert: 118.9 ms]
Total partitions : 675,758 [insert: 675,758]
Total errors : 0 [insert: 0]
Total GC count : 12
Total GC memory : 14.791 GiB
Total GC time : 1.1 seconds
Avg GC time : 94.2 ms
StdDev GC time : 16.2 ms
Total operation time : 00:00:30
Improvement over 8 threadCount: 36%
Sleeping for 15s
Running with 24 threadCount
Running [insert] with 24 threads until stderr of mean < 0.02
type total ops, op/s, pk/s, row/s, mean, med, .95, .99, .999, max, time, stderr, errors, gc:
total, 29403, 29403, 29403, 40305, 0.6, 0.5, 1.2, 2.1, 15.3, 26.9, 1.0, 0.00000, 0, 0, 0, 0, 0, 0
total, 58259, 28856, 28856, 39533, 0.7, 0.6, 1.4, 2.3, 17.0, 45.4, 2.0, 0.00005, 0, 1, 42, 42, 0, 1069
total, 87429, 29170, 29170, 40152, 0.7, 0.6, 1.3, 2.2, 7.5, 23.2, 3.0, 0.00205, 0, 0, 0, 0, 0, 0
total, 114629, 27200, 27200, 37241, 0.8, 0.6, 1.3, 2.2, 25.9, 87.0, 4.0, 0.00316, 0, 1, 79, 79, 0, 997
total, 143499, 28870, 28870, 39541, 0.7, 0.5, 1.2, 2.2, 17.9, 44.3, 5.0, 0.00266, 0, 0, 0, 0, 0, 0
total, 169698, 26199, 26199, 35718, 0.7, 0.6, 1.3, 2.7, 9.0, 20.7, 6.0, 0.01800, 0, 1, 120, 120, 0, 965
total, 197869, 28171, 28171, 38301, 0.8, 0.5, 1.3, 2.3, 21.4, 123.9, 7.0, 0.01859, 0, 0, 0, 0, 0, 0
total, 228013, 30144, 30144, 41363, 0.6, 0.5, 1.2, 2.0, 13.8, 38.2, 8.0, 0.01724, 0, 0, 0, 0, 0, 0
total, 252819, 24806, 24806, 33848, 0.8, 0.6, 1.4, 2.3, 27.0, 82.4, 9.0, 0.01901, 0, 1, 72, 72, 0, 974
total, 280499, 27680, 27680, 37902, 0.7, 0.6, 1.3, 2.1, 16.9, 38.4, 10.0, 0.01742, 0, 0, 0, 0, 0, 0
total, 304205, 23706, 23706, 32403, 0.8, 0.6, 1.4, 3.1, 14.0, 126.6, 11.0, 0.01761, 0, 1, 123, 123, 0, 999
total, 330439, 26234, 26234, 35784, 0.7, 0.6, 1.3, 2.2, 14.4, 27.1, 12.0, 0.01767, 0, 0, 0, 0, 0, 0
total, 357272, 26833, 26833, 36816, 0.7, 0.6, 1.3, 2.1, 7.8, 36.2, 13.0, 0.01669, 0, 0, 0, 0, 0, 0
total, 379895, 22623, 22623, 31092, 0.9, 0.6, 1.6, 4.9, 105.1, 110.5, 14.0, 0.01779, 0, 1, 93, 93, 0, 976
total, 405142, 25247, 25247, 34686, 0.8, 0.6, 1.4, 2.6, 19.9, 74.1, 15.0, 0.01698, 0, 0, 0, 0, 0, 0
total, 428360, 23218, 23218, 31976, 0.8, 0.6, 1.4, 2.5, 115.9, 117.4, 16.0, 0.01671, 0, 2, 114, 194, 17, 3800
total, 454045, 25685, 25685, 35254, 0.7, 0.6, 1.4, 2.3, 16.5, 31.8, 17.0, 0.01629, 0, 0, 0, 0, 0, 0
total, 479309, 25264, 25264, 34689, 0.7, 0.6, 1.4, 2.6, 15.0, 36.4, 18.0, 0.01600, 0, 0, 0, 0, 0, 0
total, 499792, 20483, 20483, 27915, 0.8, 0.6, 1.5, 2.6, 65.2, 72.1, 19.0, 0.01927, 0, 1, 59, 59, 0, 983
total, 511858, 12066, 12066, 16612, 1.8, 0.6, 1.5, 2.5, 659.0, 666.4, 20.0, 0.02303, 0, 0, 0, 0, 0, 0
total, 538256, 26398, 26398, 36188, 0.7, 0.6, 1.3, 2.2, 11.9, 27.9, 21.0, 0.02207, 0, 0, 0, 0, 0, 0
total, 559429, 21173, 21173, 28971, 0.8, 0.5, 1.4, 2.6, 102.4, 103.8, 22.0, 0.02252, 0, 1, 100, 100, 0, 994
total, 584952, 25523, 25523, 34891, 0.6, 0.5, 1.3, 2.0, 19.0, 21.1, 23.0, 0.02185, 0, 0, 0, 0, 0, 0
total, 607849, 22897, 22897, 31503, 0.7, 0.5, 1.3, 2.3, 69.7, 91.2, 24.0, 0.02140, 0, 1, 68, 68, 0, 975
total, 632584, 24735, 24735, 33824, 0.7, 0.6, 1.4, 2.4, 19.0, 25.0, 25.0, 0.02095, 0, 0, 0, 0, 0, 0
total, 656601, 24017, 24017, 32972, 0.7, 0.6, 1.3, 2.8, 18.8, 22.9, 26.0, 0.02070, 0, 0, 0, 0, 0, 0
total, 678404, 21803, 21803, 29978, 0.8, 0.5, 1.3, 2.4, 95.6, 105.1, 27.0, 0.02047, 0, 1, 94, 94, 0, 1001
total, 702718, 24314, 24314, 33324, 0.7, 0.5, 1.3, 2.2, 30.2, 74.2, 28.0, 0.01984, 0, 0, 0, 0, 0, 0
total, 726297, 23579, 23579, 32180, 0.7, 0.6, 1.4, 3.0, 12.8, 25.4, 29.0, 0.01971, 0, 0, 0, 0, 0, 0
total, 750301, 24004, 24004, 32713, 0.7, 0.5, 1.3, 2.1, 18.5, 70.9, 30.0, 0.01920, 0, 1, 67, 67, 0, 971
total, 750345, 1907, 1907, 2600, 14.0, 9.9, 34.1, 37.5, 37.5, 37.5, 30.0, 0.04133, 0, 0, 0, 0, 0, 0
Results:
Op rate : 24,992 op/s [insert: 24,992 op/s]
Partition rate : 24,992 pk/s [insert: 24,992 pk/s]
Row rate : 34,232 row/s [insert: 34,232 row/s]
Latency mean : 0.7 ms [insert: 0.7 ms]
Latency median : 0.6 ms [insert: 0.6 ms]
Latency 95th percentile : 1.3 ms [insert: 1.3 ms]
Latency 99th percentile : 2.4 ms [insert: 2.4 ms]
Latency 99.9th percentile : 20.7 ms [insert: 20.7 ms]
Latency max : 666.4 ms [insert: 666.4 ms]
Total partitions : 750,345 [insert: 750,345]
Total errors : 0 [insert: 0]
Total GC count : 13
Total GC memory : 14.361 GiB
Total GC time : 1.1 seconds
Avg GC time : 85.5 ms
StdDev GC time : 23.6 ms
Total operation time : 00:00:30
Improvement over 16 threadCount: 11%
Sleeping for 15s
Running with 36 threadCount
Running [insert] with 36 threads until stderr of mean < 0.02
type total ops, op/s, pk/s, row/s, mean, med, .95, .99, .999, max, time, stderr, errors, gc:
total, 28900, 28900, 28900, 39446, 0.9, 0.7, 1.9, 4.2, 54.0, 91.6, 1.0, 0.00000, 0, 1, 52, 52, 0, 1099
total, 63308, 34408, 34408, 47135, 0.8, 0.7, 1.7, 2.9, 13.4, 22.6, 2.0, 0.03705, 0, 0, 0, 0, 0, 0
total, 91456, 28148, 28148, 38437, 1.0, 0.7, 1.8, 3.2, 137.0, 139.6, 3.0, 0.02584, 0, 1, 133, 133, 0, 975
total, 123317, 31861, 31861, 43645, 0.8, 0.7, 1.7, 2.8, 16.7, 28.4, 4.0, 0.01959, 0, 0, 0, 0, 0, 0
total, 150535, 27218, 27218, 37193, 1.0, 0.7, 1.9, 4.6, 105.6, 108.7, 5.0, 0.02145, 0, 1, 104, 104, 0, 967
total, 178324, 27789, 27789, 37957, 0.9, 0.7, 2.1, 3.9, 42.4, 47.5, 6.0, 0.02455, 0, 0, 0, 0, 0, 0
total, 208694, 30370, 30370, 41479, 0.8, 0.7, 1.8, 3.3, 14.9, 36.3, 7.0, 0.02122, 0, 0, 0, 0, 0, 0
total, 235466, 26772, 26772, 36534, 1.0, 0.6, 1.9, 4.1, 108.6, 111.1, 8.0, 0.01997, 0, 1, 107, 107, 0, 992
total, 261119, 25653, 25653, 35255, 1.0, 0.6, 1.9, 4.3, 92.3, 199.6, 9.0, 0.01779, 0, 0, 0, 0, 0, 0
total, 284856, 23737, 23737, 32326, 1.0, 0.6, 1.8, 3.5, 117.4, 119.9, 10.0, 0.02206, 0, 1, 115, 115, 0, 966
total, 312612, 27756, 27756, 37999, 0.8, 0.7, 1.7, 2.9, 7.2, 81.0, 11.0, 0.02032, 0, 0, 0, 0, 0, 0
total, 338597, 25985, 25985, 35480, 1.0, 0.7, 2.0, 3.9, 76.2, 82.9, 12.0, 0.02020, 0, 1, 73, 73, 0, 999
total, 366226, 27629, 27629, 38064, 0.8, 0.6, 1.9, 3.6, 14.4, 24.5, 13.0, 0.01963, 0, 0, 0, 0, 0, 0
total, 394204, 27978, 27978, 38345, 0.8, 0.6, 1.8, 3.8, 15.9, 37.0, 14.0, 0.01867, 0, 0, 0, 0, 0, 0
total, 419896, 25692, 25692, 34993, 1.0, 0.6, 2.1, 4.3, 93.8, 95.3, 15.0, 0.01821, 0, 1, 91, 91, 0, 970
total, 446133, 26237, 26237, 35855, 0.8, 0.6, 2.0, 3.5, 14.7, 18.4, 16.0, 0.01879, 0, 0, 0, 0, 0, 0
total, 467310, 21177, 21177, 28808, 1.1, 0.6, 2.2, 5.2, 80.3, 88.0, 17.0, 0.02255, 0, 1, 72, 72, 0, 995
total, 492529, 25219, 25219, 34483, 0.8, 0.6, 2.0, 3.5, 11.6, 28.2, 18.0, 0.02259, 0, 0, 0, 0, 0, 0
total, 514571, 22042, 22042, 30184, 1.0, 0.6, 2.0, 4.2, 69.7, 76.7, 19.0, 0.02381, 0, 0, 0, 0, 0, 0
total, 535526, 20955, 20955, 28759, 1.0, 0.6, 2.1, 4.3, 104.7, 106.8, 20.0, 0.02481, 0, 2, 102, 173, 16, 4681
total, 559897, 24371, 24371, 33194, 0.8, 0.6, 1.8, 3.1, 10.7, 75.7, 21.0, 0.02415, 0, 0, 0, 0, 0, 0
total, 584228, 24331, 24331, 33126, 0.9, 0.6, 2.2, 4.8, 19.2, 23.4, 22.0, 0.02404, 0, 0, 0, 0, 0, 0
total, 606010, 21782, 21782, 29875, 1.0, 0.6, 2.1, 4.2, 82.0, 87.6, 23.0, 0.02423, 0, 1, 80, 80, 0, 999
total, 631527, 25517, 25517, 34988, 0.8, 0.6, 1.9, 3.2, 26.7, 33.8, 24.0, 0.02347, 0, 0, 0, 0, 0, 0
total, 654050, 22523, 22523, 30696, 0.9, 0.5, 1.8, 3.1, 126.0, 127.3, 25.0, 0.02292, 0, 1, 124, 124, 0, 985
total, 678771, 24721, 24721, 33636, 0.8, 0.6, 1.9, 3.7, 19.8, 24.4, 26.0, 0.02252, 0, 0, 0, 0, 0, 0
total, 703233, 24462, 24462, 33585, 0.8, 0.6, 1.8, 3.3, 16.9, 37.9, 27.0, 0.02203, 0, 0, 0, 0, 0, 0
total, 723078, 19845, 19845, 27160, 1.1, 0.5, 1.9, 5.2, 128.0, 147.8, 28.0, 0.02220, 0, 1, 113, 113, 0, 968
total, 746458, 23380, 23380, 32171, 0.8, 0.6, 1.9, 3.1, 22.9, 47.2, 29.0, 0.02188, 0, 0, 0, 0, 0, 0
total, 769917, 23459, 23459, 32175, 0.8, 0.6, 1.9, 3.4, 16.4, 23.5, 30.0, 0.02169, 0, 0, 0, 0, 0, 0
total, 790699, 20782, 20782, 28421, 0.9, 0.5, 2.1, 4.3, 86.9, 95.5, 31.0, 0.02180, 0, 1, 85, 85, 0, 1009
total, 814073, 23374, 23374, 32080, 0.8, 0.5, 2.0, 3.9, 13.9, 28.6, 32.0, 0.02153, 0, 0, 0, 0, 0, 0
total, 836974, 22901, 22901, 31203, 0.8, 0.6, 2.1, 4.2, 13.2, 17.1, 33.0, 0.02148, 0, 1, 123, 123, 0, 975
total, 856024, 19050, 19050, 25860, 1.0, 0.5, 2.2, 4.7, 129.3, 138.7, 34.0, 0.02173, 0, 0, 0, 0, 0, 0
total, 878616, 22592, 22592, 30832, 0.8, 0.6, 2.0, 3.3, 21.2, 25.7, 35.0, 0.02160, 0, 0, 0, 0, 0, 0
total, 898938, 20322, 20322, 27887, 1.0, 0.5, 2.2, 4.1, 90.9, 94.2, 36.0, 0.02159, 0, 1, 89, 89, 0, 1010
total, 921463, 22525, 22525, 30765, 0.8, 0.5, 2.0, 3.8, 25.9, 51.8, 37.0, 0.02131, 0, 0, 0, 0, 0, 0
total, 943926, 22463, 22463, 30713, 0.9, 0.6, 2.1, 4.1, 27.2, 84.4, 38.0, 0.02092, 0, 0, 0, 0, 0, 0
total, 963707, 19781, 19781, 27069, 1.0, 0.5, 2.0, 3.9, 104.0, 107.6, 39.0, 0.02093, 0, 1, 102, 102, 0, 980
total, 985660, 21953, 21953, 30213, 0.8, 0.5, 2.0, 3.9, 22.0, 24.4, 40.0, 0.02081, 0, 0, 0, 0, 0, 0
total, 1006169, 20509, 20509, 28101, 0.8, 0.5, 2.3, 5.4, 14.5, 22.5, 41.0, 0.02102, 0, 0, 0, 0, 0, 0
total, 1025219, 19050, 19050, 26104, 1.0, 0.6, 2.1, 4.1, 80.3, 84.3, 42.0, 0.02122, 0, 1, 79, 79, 0, 993
total, 1046523, 21304, 21304, 29168, 0.8, 0.6, 2.1, 3.6, 8.0, 20.6, 43.0, 0.02118, 0, 0, 0, 0, 0, 0
total, 1068809, 22286, 22286, 30283, 0.8, 0.5, 2.0, 3.2, 12.8, 20.3, 44.0, 0.02098, 0, 0, 0, 0, 0, 0
total, 1087472, 18663, 18663, 25469, 1.0, 0.6, 2.1, 3.8, 103.8, 107.3, 45.0, 0.02108, 0, 1, 94, 94, 0, 988
total, 1109154, 21682, 21682, 29783, 0.8, 0.6, 2.1, 3.8, 17.6, 19.4, 46.0, 0.02092, 0, 0, 0, 0, 0, 0
total, 1131375, 22221, 22221, 30270, 0.7, 0.5, 2.0, 3.6, 11.5, 15.3, 47.0, 0.02072, 0, 0, 0, 0, 0, 0
total, 1150069, 18694, 18694, 25654, 1.0, 0.5, 2.2, 5.0, 92.6, 97.4, 48.0, 0.02077, 0, 1, 86, 86, 0, 988
total, 1170331, 20262, 20262, 27468, 0.9, 0.6, 2.1, 4.0, 27.9, 29.7, 49.0, 0.02080, 0, 0, 0, 0, 0, 0
total, 1192627, 22296, 22296, 30600, 0.7, 0.5, 2.0, 3.3, 14.0, 22.0, 50.0, 0.02054, 0, 0, 0, 0, 0, 0
total, 1211537, 18910, 18910, 26069, 1.0, 0.5, 2.1, 4.2, 88.0, 91.2, 51.0, 0.02051, 0, 1, 86, 86, 0, 997
total, 1233083, 21546, 21546, 29525, 0.8, 0.5, 2.0, 3.4, 14.4, 21.6, 52.0, 0.02032, 0, 0, 0, 0, 0, 0
total, 1254707, 21624, 21624, 29629, 0.7, 0.5, 2.1, 3.9, 17.1, 24.0, 53.0, 0.02013, 0, 0, 0, 0, 0, 0
total, 1273682, 18975, 18975, 26159, 0.9, 0.5, 2.1, 4.2, 103.1, 107.2, 54.0, 0.02001, 0, 1, 101, 101, 0, 984
total, 1292777, 19095, 19095, 26064, 0.8, 0.5, 2.3, 5.1, 10.4, 31.4, 55.0, 0.02013, 0, 0, 0, 0, 0, 0
total, 1313638, 20861, 20861, 28454, 0.8, 0.5, 2.0, 4.0, 14.2, 29.2, 56.0, 0.02000, 0, 0, 0, 0, 0, 0
total, 1313775, 6570, 6570, 8489, 1.6, 0.5, 9.3, 14.3, 16.8, 16.8, 56.0, 0.02011, 0, 0, 0, 0, 0, 0
Results:
Op rate : 23,452 op/s [insert: 23,452 op/s]
Partition rate : 23,452 pk/s [insert: 23,452 pk/s]
Row rate : 32,077 row/s [insert: 32,077 row/s]
Latency mean : 0.9 ms [insert: 0.9 ms]
Latency median : 0.6 ms [insert: 0.6 ms]
Latency 95th percentile : 2.0 ms [insert: 2.0 ms]
Latency 99th percentile : 3.8 ms [insert: 3.8 ms]
Latency 99.9th percentile : 27.9 ms [insert: 27.9 ms]
Latency max : 199.6 ms [insert: 199.6 ms]
Total partitions : 1,313,775 [insert: 1,313,775]
Total errors : 0 [insert: 0]
Total GC count : 22
Total GC memory : 23.946 GiB
Total GC time : 2.1 seconds
Avg GC time : 94.6 ms
StdDev GC time : 19.5 ms
Total operation time : 00:00:56
Improvement over 24 threadCount: -6%
Sleeping for 15s
Running with 54 threadCount
Running [insert] with 54 threads until stderr of mean < 0.02
type total ops, op/s, pk/s, row/s, mean, med, .95, .99, .999, max, time, stderr, errors, gc:
total, 17871, 17871, 17871, 24405, 1.9, 0.5, 2.6, 6.8, 451.7, 460.3, 1.0, 0.00000, 0, 0, 0, 0, 0, 0
total, 50628, 32757, 32757, 45045, 1.0, 0.7, 2.9, 6.4, 16.8, 32.1, 2.0, 0.01017, 0, 0, 0, 0, 0, 0
total, 78092, 27464, 27464, 37498, 1.3, 0.7, 3.2, 7.3, 114.8, 121.1, 3.0, 0.02073, 0, 1, 102, 102, 0, 1026
total, 106502, 28410, 28410, 38753, 1.3, 0.7, 3.5, 7.4, 62.4, 66.5, 4.0, 0.02267, 0, 0, 0, 0, 0, 0
total, 130572, 24070, 24070, 32967, 1.3, 0.6, 3.3, 9.1, 103.7, 111.8, 5.0, 0.03438, 0, 2, 101, 163, 20, 5351
total, 156751, 26179, 26179, 35784, 1.0, 0.6, 3.3, 7.2, 42.8, 48.2, 6.0, 0.03446, 0, 0, 0, 0, 0, 0
total, 177878, 21127, 21127, 28894, 1.6, 0.6, 3.4, 11.2, 147.8, 150.6, 7.0, 0.03947, 0, 1, 93, 93, 0, 995
total, 201408, 23530, 23530, 32222, 1.6, 0.7, 3.1, 6.6, 142.0, 147.6, 8.0, 0.03582, 0, 0, 0, 0, 0, 0
total, 230165, 28757, 28757, 39286, 1.0, 0.7, 3.0, 5.6, 20.1, 22.0, 9.0, 0.03185, 0, 0, 0, 0, 0, 0
total, 254699, 24534, 24534, 33606, 1.2, 0.6, 3.2, 7.2, 101.1, 105.6, 10.0, 0.02957, 0, 1, 94, 94, 0, 974
total, 282136, 27437, 27437, 37417, 1.0, 0.6, 3.0, 6.1, 31.4, 35.1, 11.0, 0.02710, 0, 0, 0, 0, 0, 0
total, 306897, 24761, 24761, 33709, 1.3, 0.7, 3.2, 6.8, 93.7, 98.8, 12.0, 0.02547, 0, 1, 90, 90, 0, 989
total, 330401, 23504, 23504, 32055, 1.2, 0.6, 3.5, 8.6, 54.9, 59.5, 13.0, 0.02601, 0, 0, 0, 0, 0, 0
total, 348534, 18133, 18133, 24707, 1.6, 0.6, 3.5, 10.3, 178.9, 186.6, 14.0, 0.02922, 0, 0, 0, 0, 0, 0
total, 371614, 23080, 23080, 31590, 1.6, 0.7, 3.4, 9.0, 125.0, 138.7, 15.0, 0.02756, 0, 1, 108, 108, 0, 987
total, 397863, 26249, 26249, 35973, 1.0, 0.6, 3.0, 7.2, 29.8, 33.3, 16.0, 0.02597, 0, 0, 0, 0, 0, 0
total, 423329, 25466, 25466, 34723, 1.1, 0.6, 3.2, 6.9, 30.8, 34.3, 17.0, 0.02481, 0, 0, 0, 0, 0, 0
total, 446334, 23005, 23005, 31738, 1.2, 0.7, 3.2, 6.9, 85.9, 91.8, 18.0, 0.02401, 0, 1, 83, 83, 0, 994
total, 465964, 19630, 19630, 27007, 1.8, 0.7, 4.0, 27.4, 112.3, 167.5, 19.0, 0.02417, 0, 0, 0, 0, 0, 0
total, 491123, 25159, 25159, 34496, 1.0, 0.6, 3.1, 6.7, 21.4, 52.0, 20.0, 0.02308, 0, 1, 125, 125, 0, 975
total, 514199, 23076, 23076, 31440, 1.3, 0.6, 3.4, 7.4, 128.3, 133.8, 21.0, 0.02209, 0, 0, 0, 0, 0, 0
total, 540143, 25944, 25944, 35582, 0.9, 0.6, 3.0, 5.4, 17.4, 22.9, 22.0, 0.02117, 0, 0, 0, 0, 0, 0
total, 561391, 21248, 21248, 29116, 1.3, 0.6, 3.4, 7.7, 90.3, 95.0, 23.0, 0.02129, 0, 1, 88, 88, 0, 987
total, 583786, 22395, 22395, 30719, 1.0, 0.6, 3.5, 8.0, 42.6, 50.8, 24.0, 0.02124, 0, 0, 0, 0, 0, 0
total, 606037, 22251, 22251, 30463, 1.0, 0.6, 3.3, 7.5, 39.8, 46.1, 25.0, 0.02124, 0, 0, 0, 0, 0, 0
total, 624713, 18676, 18676, 25726, 1.7, 0.6, 3.5, 10.4, 152.8, 155.5, 26.0, 0.02162, 0, 1, 76, 76, 0, 989
total, 648631, 23918, 23918, 32721, 0.9, 0.6, 3.3, 5.8, 20.1, 24.0, 27.0, 0.02112, 0, 0, 0, 0, 0, 0
total, 672621, 23990, 23990, 32703, 0.9, 0.5, 3.3, 7.0, 18.8, 26.2, 28.0, 0.02063, 0, 0, 0, 0, 0, 0
total, 693519, 20898, 20898, 28503, 1.2, 0.6, 3.5, 8.3, 112.7, 124.4, 29.0, 0.02032, 0, 1, 110, 110, 0, 986
total, 716170, 22651, 22651, 30847, 1.1, 0.6, 3.5, 7.1, 19.2, 23.2, 30.0, 0.02019, 0, 0, 0, 0, 0, 0
total, 733732, 17562, 17562, 24112, 1.7, 0.6, 3.7, 21.2, 162.0, 175.4, 31.0, 0.02060, 0, 0, 0, 0, 0, 0
total, 750283, 16551, 16551, 22600, 2.0, 0.6, 3.4, 17.2, 155.1, 168.0, 32.0, 0.02149, 0, 1, 64, 64, 0, 996
total, 773159, 22876, 22876, 31285, 1.0, 0.6, 3.4, 5.8, 20.5, 26.7, 33.0, 0.02111, 0, 0, 0, 0, 0, 0
total, 796907, 23748, 23748, 32641, 1.0, 0.6, 3.1, 5.1, 11.5, 28.3, 34.0, 0.02058, 0, 0, 0, 0, 0, 0
total, 816869, 19962, 19962, 27329, 1.2, 0.5, 3.6, 8.6, 94.0, 114.0, 35.0, 0.02041, 0, 1, 102, 102, 0, 989
total, 839506, 22637, 22637, 31053, 1.0, 0.6, 3.3, 6.3, 23.5, 96.1, 36.0, 0.01988, 0, 0, 0, 0, 0, 0
total, 839620, 6580, 6580, 9351, 1.9, 0.8, 10.6, 12.2, 15.2, 15.2, 36.0, 0.03628, 0, 0, 0, 0, 0, 0
Results:
Op rate : 23,312 op/s [insert: 23,312 op/s]
Partition rate : 23,312 pk/s [insert: 23,312 pk/s]
Row rate : 31,898 row/s [insert: 31,898 row/s]
Latency mean : 1.2 ms [insert: 1.2 ms]
Latency median : 0.6 ms [insert: 0.6 ms]
Latency 95th percentile : 3.3 ms [insert: 3.3 ms]
Latency 99th percentile : 7.4 ms [insert: 7.4 ms]
Latency 99.9th percentile : 95.1 ms [insert: 95.1 ms]
Latency max : 460.3 ms [insert: 460.3 ms]
Total partitions : 839,620 [insert: 839,620]
Total errors : 0 [insert: 0]
Total GC count : 14
Total GC memory : 16.835 GiB
Total GC time : 1.3 seconds
Avg GC time : 92.7 ms
StdDev GC time : 16.9 ms
Total operation time : 00:00:36
Improvement over 36 threadCount: -1%
Sleeping for 15s
Running with 81 threadCount
Running [insert] with 81 threads until stderr of mean < 0.02
type total ops, op/s, pk/s, row/s, mean, med, .95, .99, .999, max, time, stderr, errors, gc:
total, 27777, 27777, 27777, 38196, 1.2, 0.5, 4.2, 16.3, 31.6, 48.4, 1.0, 0.00000, 0, 0, 0, 0, 0, 0
total, 58258, 30481, 30481, 41678, 1.3, 0.7, 4.0, 11.4, 31.7, 39.3, 2.0, 0.02747, 0, 0, 0, 0, 0, 0
total, 87016, 28758, 28758, 39441, 1.5, 0.7, 4.6, 10.7, 104.1, 115.3, 3.0, 0.02538, 0, 1, 102, 102, 0, 995
total, 118866, 31850, 31850, 43397, 1.2, 0.7, 4.4, 9.6, 24.1, 34.6, 4.0, 0.02191, 0, 0, 0, 0, 0, 0
total, 143522, 24656, 24656, 33669, 1.6, 0.6, 5.3, 14.8, 121.2, 128.1, 5.0, 0.02658, 0, 1, 118, 118, 0, 960
total, 171440, 27918, 27918, 38264, 1.2, 0.6, 4.9, 10.2, 21.3, 29.4, 6.0, 0.02478, 0, 0, 0, 0, 0, 0
total, 190449, 19009, 19009, 25977, 2.0, 0.6, 5.6, 18.3, 138.0, 182.3, 7.0, 0.03965, 0, 1, 104, 104, 0, 1005
total, 216334, 25885, 25885, 35254, 1.9, 0.7, 5.4, 24.4, 141.3, 162.1, 8.0, 0.03485, 0, 0, 0, 0, 0, 0
total, 239783, 23449, 23449, 32031, 1.7, 0.8, 5.8, 15.7, 65.6, 80.6, 9.0, 0.03493, 0, 0, 0, 0, 0, 0
total, 265422, 25639, 25639, 35042, 1.5, 0.7, 5.0, 14.1, 77.3, 89.2, 10.0, 0.03175, 0, 2, 69, 134, 2, 3777
total, 291144, 25722, 25722, 35108, 1.3, 0.6, 5.1, 11.7, 30.0, 34.9, 11.0, 0.03006, 0, 0, 0, 0, 0, 0
total, 315529, 24385, 24385, 33350, 1.5, 0.7, 5.3, 12.6, 89.3, 107.0, 12.0, 0.02803, 0, 1, 81, 81, 0, 992
total, 340538, 25009, 25009, 34134, 1.2, 0.6, 4.9, 11.4, 24.9, 40.8, 13.0, 0.02701, 0, 0, 0, 0, 0, 0
total, 357216, 16678, 16678, 22739, 2.5, 0.6, 5.3, 14.8, 288.4, 301.2, 14.0, 0.02791, 0, 0, 0, 0, 0, 0
total, 375869, 18653, 18653, 25376, 2.7, 0.6, 6.9, 32.2, 211.7, 223.0, 15.0, 0.02815, 0, 1, 116, 116, 0, 999
total, 403553, 27684, 27684, 37884, 1.2, 0.6, 4.8, 9.9, 19.8, 29.7, 16.0, 0.02639, 0, 0, 0, 0, 0, 0
total, 428581, 25028, 25028, 34233, 1.2, 0.6, 5.2, 9.7, 23.9, 36.3, 17.0, 0.02527, 0, 0, 0, 0, 0, 0
total, 448837, 20256, 20256, 27594, 1.6, 0.6, 6.4, 18.6, 88.2, 103.0, 18.0, 0.02630, 0, 1, 84, 84, 0, 983
total, 473047, 24210, 24210, 33166, 1.3, 0.6, 5.8, 11.2, 30.0, 86.1, 19.0, 0.02504, 0, 0, 0, 0, 0, 0
total, 498350, 25303, 25303, 34693, 1.1, 0.5, 5.1, 9.8, 23.8, 31.5, 20.0, 0.02396, 0, 0, 0, 0, 0, 0
total, 519841, 21491, 21491, 29227, 1.8, 0.7, 5.9, 14.1, 112.3, 122.3, 21.0, 0.02353, 0, 1, 110, 110, 0, 974
total, 541460, 21619, 21619, 29368, 1.5, 0.7, 5.9, 15.3, 35.2, 53.3, 22.0, 0.02386, 0, 0, 0, 0, 0, 0
total, 563851, 22391, 22391, 30634, 1.5, 0.7, 6.4, 12.9, 47.2, 53.9, 23.0, 0.02356, 0, 1, 92, 92, 0, 988
total, 585942, 22091, 22091, 30052, 1.5, 0.6, 5.6, 14.1, 94.4, 105.9, 24.0, 0.02294, 0, 0, 0, 0, 0, 0
total, 610110, 24168, 24168, 33117, 1.2, 0.6, 5.2, 10.7, 20.1, 30.3, 25.0, 0.02225, 0, 0, 0, 0, 0, 0
total, 627279, 17169, 17169, 23371, 2.5, 0.6, 6.7, 64.9, 106.7, 112.7, 26.0, 0.02412, 0, 1, 83, 83, 0, 998
total, 648667, 21388, 21388, 29370, 1.3, 0.6, 5.6, 12.5, 31.1, 49.4, 27.0, 0.02396, 0, 0, 0, 0, 0, 0
total, 672424, 23757, 23757, 32394, 1.2, 0.6, 5.2, 10.3, 18.8, 26.0, 28.0, 0.02332, 0, 0, 0, 0, 0, 0
total, 694775, 22351, 22351, 30517, 1.4, 0.6, 5.0, 10.8, 95.5, 102.1, 29.0, 0.02263, 0, 1, 93, 93, 0, 984
total, 716396, 21621, 21621, 29587, 1.3, 0.6, 5.5, 11.6, 35.5, 50.4, 30.0, 0.02239, 0, 0, 0, 0, 0, 0
total, 738119, 21723, 21723, 29705, 1.2, 0.6, 5.6, 12.2, 24.1, 35.4, 31.0, 0.02219, 0, 0, 0, 0, 0, 0
total, 751515, 13396, 13396, 18344, 3.9, 0.7, 5.8, 97.5, 343.4, 349.4, 32.0, 0.02256, 0, 1, 69, 69, 0, 1002
total, 772815, 21300, 21300, 29293, 1.4, 0.6, 5.5, 11.3, 43.3, 51.0, 33.0, 0.02228, 0, 0, 0, 0, 0, 0
total, 797558, 24743, 24743, 33744, 1.2, 0.6, 4.8, 9.5, 21.4, 28.8, 34.0, 0.02163, 0, 0, 0, 0, 0, 0
total, 817774, 20216, 20216, 27627, 1.6, 0.6, 5.7, 12.1, 109.9, 122.0, 35.0, 0.02129, 0, 1, 104, 104, 0, 982
total, 829873, 12099, 12099, 16571, 2.5, 0.5, 5.4, 10.1, 509.9, 510.9, 36.0, 0.02073, 0, 0, 0, 0, 0, 0
total, 851796, 21923, 21923, 29970, 1.2, 0.6, 5.2, 12.2, 18.5, 22.7, 37.0, 0.02051, 0, 0, 0, 0, 0, 0
total, 872360, 20564, 20564, 28263, 1.6, 0.6, 5.6, 17.6, 86.6, 92.9, 38.0, 0.02022, 0, 1, 82, 82, 0, 995
total, 894417, 22057, 22057, 30385, 1.3, 0.6, 5.4, 11.6, 23.6, 29.1, 39.0, 0.01992, 0, 0, 0, 0, 0, 0
total, 894554, 11578, 11578, 16396, 2.1, 0.7, 8.8, 10.9, 12.9, 12.9, 39.0, 0.17684, 0, 0, 0, 0, 0, 0
Results:
Op rate : 22,930 op/s [insert: 22,930 op/s]
Partition rate : 22,930 pk/s [insert: 22,930 pk/s]
Row rate : 31,348 row/s [insert: 31,348 row/s]
Latency mean : 1.5 ms [insert: 1.5 ms]
Latency median : 0.6 ms [insert: 0.6 ms]
Latency 95th percentile : 5.3 ms [insert: 5.3 ms]
Latency 99th percentile : 12.7 ms [insert: 12.7 ms]
Latency 99.9th percentile : 97.6 ms [insert: 97.6 ms]
Latency max : 510.9 ms [insert: 510.9 ms]
Total partitions : 894,554 [insert: 894,554]
Total errors : 0 [insert: 0]
Total GC count : 15
Total GC memory : 16.245 GiB
Total GC time : 1.4 seconds
Avg GC time : 91.5 ms
StdDev GC time : 16.6 ms
Total operation time : 00:00:39
Improvement over 54 threadCount: -2%
Sleeping for 15s
id, type total ops, op/s, pk/s, row/s, mean, med, .95, .99, .999, max, time, stderr, errors, gc:
4 threadCount, insert, 522041, 10440, 10440, 14289, 0.3, 0.2, 0.4, 0.7, 5.2, 141.0, 50.0, 0.02007, 0, 9, 955, 955, 14, 9117
4 threadCount, total, 522041, 10440, 10440, 14289, 0.3, 0.2, 0.4, 0.7, 5.2, 141.0, 50.0, 0.02007, 0, 9, 955, 955, 14, 9117
8 threadCount, insert, 497929, 16593, 16593, 22676, 0.4, 0.3, 0.6, 0.8, 6.2, 281.3, 30.0, 0.01703, 0, 8, 758, 758, 16, 8057
8 threadCount, total, 497929, 16593, 16593, 22676, 0.4, 0.3, 0.6, 0.8, 6.2, 281.3, 30.0, 0.01703, 0, 8, 758, 758, 16, 8057
16 threadCount, insert, 675758, 22486, 22486, 30754, 0.6, 0.5, 0.9, 1.5, 15.7, 118.9, 30.1, 0.03493, 0, 12, 1130, 1130, 16, 15146
16 threadCount, total, 675758, 22486, 22486, 30754, 0.6, 0.5, 0.9, 1.5, 15.7, 118.9, 30.1, 0.03493, 0, 12, 1130, 1130, 16, 15146
24 threadCount, insert, 750345, 24992, 24992, 34232, 0.7, 0.6, 1.3, 2.4, 20.7, 666.4, 30.0, 0.04133, 0, 13, 1031, 1111, 24, 14705
24 threadCount, total, 750345, 24992, 24992, 34232, 0.7, 0.6, 1.3, 2.4, 20.7, 666.4, 30.0, 0.04133, 0, 13, 1031, 1111, 24, 14705
36 threadCount, insert, 1313775, 23452, 23452, 32077, 0.9, 0.6, 2.0, 3.8, 27.9, 199.6, 56.0, 0.02011, 0, 22, 2011, 2082, 20, 24520
36 threadCount, total, 1313775, 23452, 23452, 32077, 0.9, 0.6, 2.0, 3.8, 27.9, 199.6, 56.0, 0.02011, 0, 22, 2011, 2082, 20, 24520
54 threadCount, insert, 839620, 23312, 23312, 31898, 1.2, 0.6, 3.3, 7.4, 95.1, 460.3, 36.0, 0.03628, 0, 14, 1236, 1298, 17, 17239
54 threadCount, total, 839620, 23312, 23312, 31898, 1.2, 0.6, 3.3, 7.4, 95.1, 460.3, 36.0, 0.03628, 0, 14, 1236, 1298, 17, 17239
81 threadCount, insert, 894554, 22930, 22930, 31348, 1.5, 0.6, 5.3, 12.7, 97.6, 510.9, 39.0, 0.17684, 0, 15, 1307, 1372, 17, 16635
81 threadCount, total, 894554, 22930, 22930, 31348, 1.5, 0.6, 5.3, 12.7, 97.6, 510.9, 39.0, 0.17684, 0, 15, 1307, 1372, 17, 16635
END