[
https://issues.apache.org/jira/browse/CASSANDRA-20293?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17924275#comment-17924275
]
Francisco Guerrero commented on CASSANDRA-20293:
------------------------------------------------
*3.0 Validations*
*Before patch (SHA 7c147ef80e63d99cee576f4c7ee345c8a8c1aa7e)*
{code:bash}
Results:
op rate : 38903 [WRITE:38903]
partition rate : 38903 [WRITE:38903]
row rate : 38903 [WRITE:38903]
latency mean : 2.6 [WRITE:2.6]
latency median : 0.9 [WRITE:0.9]
latency 95th percentile : 3.7 [WRITE:3.7]
latency 99th percentile : 19.9 [WRITE:19.9]
latency 99.9th percentile : 148.0 [WRITE:148.0]
latency max : 500.5 [WRITE:500.5]
Total partitions : 1000000 [WRITE:1000000]
Total errors : 0 [WRITE:0]
total gc count : 57
total gc mb : 21758
total gc time (s) : 1
avg gc time(ms) : 15
stdev gc time(ms) : 5
Total operation time : 00:00:25
END
> bin/nodetool tablestats system_auth.roles
Keyspace: system_auth
Read Count: 1000080
Read Latency: 0.05325400667946564 ms.
Write Count: 2
Write Latency: 0.3065 ms.
Pending Flushes: 0
Table: roles
SSTable count: 0
Space used (live): 0
Space used (total): 0
Space used by snapshots (total): 0
Off heap memory used (total): 0
SSTable Compression Ratio: 0.0
Number of partitions (estimate): 1
Memtable cell count: 2
Memtable data size: 278
Memtable off heap memory used: 0
Memtable switch count: 0
Speculate retries: 0
Local read count: 1000080
Local read latency: 0.059 ms
Local write count: 2
Local write latency: NaN ms
Pending flushes: 0
Bloom filter false positives: 0
Bloom filter false ratio: 0.00000
Bloom filter space used: 0
Bloom filter off heap memory used: 0
Index summary off heap memory used: 0
Compression metadata off heap memory used: 0
Compacted partition minimum bytes: 0
Compacted partition maximum bytes: 0
Compacted partition mean bytes: 0
Average live cells per slice (last five minutes): 1.0
Maximum live cells per slice (last five minutes): 1
Average tombstones per slice (last five minutes): 1.0
Maximum tombstones per slice (last five minutes): 1
----------------
{code}
*With Patch (SHA 3514d87e6a46ccea76901e0f71ecdd36b5586780)*
{code:bash}
Results:
op rate : 53229 [WRITE:53229]
partition rate : 53229 [WRITE:53229]
row rate : 53229 [WRITE:53229]
latency mean : 1.9 [WRITE:1.9]
latency median : 0.8 [WRITE:0.8]
latency 95th percentile : 3.0 [WRITE:3.0]
latency 99th percentile : 15.7 [WRITE:15.7]
latency 99.9th percentile : 126.1 [WRITE:126.1]
latency max : 330.3 [WRITE:330.3]
Total partitions : 1000000 [WRITE:1000000]
Total errors : 0 [WRITE:0]
total gc count : 38
total gc mb : 12785
total gc time (s) : 1
avg gc time(ms) : 21
stdev gc time(ms) : 16
Total operation time : 00:00:18
END
> bin/nodetool tablestats system_auth.roles
Keyspace: system_auth
Read Count: 65
Read Latency: 0.1976153846153846 ms.
Write Count: 2
Write Latency: 0.26 ms.
Pending Flushes: 0
Table: roles
SSTable count: 0
Space used (live): 0
Space used (total): 0
Space used by snapshots (total): 0
Off heap memory used (total): 0
SSTable Compression Ratio: 0.0
Number of partitions (estimate): 1
Memtable cell count: 2
Memtable data size: 278
Memtable off heap memory used: 0
Memtable switch count: 0
Speculate retries: 0
Local read count: 65
Local read latency: 0.237 ms
Local write count: 2
Local write latency: 0.304 ms
Pending flushes: 0
Bloom filter false positives: 0
Bloom filter false ratio: 0.00000
Bloom filter space used: 0
Bloom filter off heap memory used: 0
Index summary off heap memory used: 0
Compression metadata off heap memory used: 0
Compacted partition minimum bytes: 0
Compacted partition maximum bytes: 0
Compacted partition mean bytes: 0
Average live cells per slice (last five minutes): 1.0
Maximum live cells per slice (last five minutes): 1
Average tombstones per slice (last five minutes): 1.0
Maximum tombstones per slice (last five minutes): 1
----------------
{code}
*Before CASSANDRA-20090 (SHA f41c2e29d240a7f0cafe6455722d287edc80b1be)*
{code:bash}
Results:
op rate : 55626 [WRITE:55626]
partition rate : 55626 [WRITE:55626]
row rate : 55626 [WRITE:55626]
latency mean : 1.8 [WRITE:1.8]
latency median : 0.7 [WRITE:0.7]
latency 95th percentile : 3.0 [WRITE:3.0]
latency 99th percentile : 13.2 [WRITE:13.2]
latency 99.9th percentile : 125.4 [WRITE:125.4]
latency max : 337.5 [WRITE:337.5]
Total partitions : 1000000 [WRITE:1000000]
Total errors : 0 [WRITE:0]
total gc count : 37
total gc mb : 12231
total gc time (s) : 1
avg gc time(ms) : 19
stdev gc time(ms) : 7
Total operation time : 00:00:17
END
> bin/nodetool tablestats system_auth.roles
Keyspace: system_auth
Read Count: 61
Read Latency: 0.2330655737704918 ms.
Write Count: 2
Write Latency: 0.342 ms.
Pending Flushes: 0
Table: roles
SSTable count: 0
Space used (live): 0
Space used (total): 0
Space used by snapshots (total): 0
Off heap memory used (total): 0
SSTable Compression Ratio: 0.0
Number of partitions (estimate): 1
Memtable cell count: 2
Memtable data size: 278
Memtable off heap memory used: 0
Memtable switch count: 0
Speculate retries: 0
Local read count: 61
Local read latency: 0.269 ms
Local write count: 2
Local write latency: 0.106 ms
Pending flushes: 0
Bloom filter false positives: 0
Bloom filter false ratio: 0.00000
Bloom filter space used: 0
Bloom filter off heap memory used: 0
Index summary off heap memory used: 0
Compression metadata off heap memory used: 0
Compacted partition minimum bytes: 0
Compacted partition maximum bytes: 0
Compacted partition mean bytes: 0
Average live cells per slice (last five minutes): 1.0
Maximum live cells per slice (last five minutes): 1
Average tombstones per slice (last five minutes): 1.0
Maximum tombstones per slice (last five minutes): 1
----------------
{code}
> Minimise expensive reads during authz flow in 3.0 & 3.11
> ---------------------------------------------------------
>
> Key: CASSANDRA-20293
> URL: https://issues.apache.org/jira/browse/CASSANDRA-20293
> Project: Apache Cassandra
> Issue Type: Improvement
> Components: Feature/Authorization
> Reporter: Michael Semb Wever
> Assignee: Sam Tunnicliffe
> Priority: Urgent
> Fix For: 3.0.x, 3.11.x
>
>
> -CASSANDRA-20090- regressed authorisation performance in 3.0.31 and 3.11.18
> releases.
> Every call to auth is (via the isSuper call) going to disk.
> This is not an issue for 4.0 and newer due to improvements to the caching of
> role metadata in CASSANDRA-14497
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
