[
https://issues.apache.org/jira/browse/CASSANDRA-20293?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17924243#comment-17924243
]
Francisco Guerrero commented on CASSANDRA-20293:
------------------------------------------------
*3.11 Validation:*
*Before patch: (SHA 82e2c7d991397aa273dc4f24a8a6e430f5c79e94)*
{code:bash}
Results:
Op rate : 34,996 op/s [WRITE: 34,996 op/s]
Partition rate : 34,996 pk/s [WRITE: 34,996 pk/s]
Row rate : 34,996 row/s [WRITE: 34,996 row/s]
Latency mean : 2.8 ms [WRITE: 2.8 ms]
Latency median : 1.0 ms [WRITE: 1.0 ms]
Latency 95th percentile : 4.2 ms [WRITE: 4.2 ms]
Latency 99th percentile : 49.9 ms [WRITE: 49.9 ms]
Latency 99.9th percentile : 204.1 ms [WRITE: 204.1 ms]
Latency max : 507.5 ms [WRITE: 507.5 ms]
Total partitions : 1,000,000 [WRITE: 1,000,000]
Total errors : 0 [WRITE: 0]
Total GC count : 48
Total GC memory : 16.802 GiB
Total GC time : 0.8 seconds
Avg GC time : 15.8 ms
StdDev GC time : 4.5 ms
Total operation time : 00:00:28
> bin/nodetool tablestats system_auth.roles
Total number of tables: 38
----------------
Keyspace : system_auth
Read Count: 1000083
Read Latency: 0.05152537939351034 ms
Write Count: 9
Write Latency: 0.10155555555555555 ms
Pending Flushes: 0
Table: roles
SSTable count: 1
Space used (live): 5153
Space used (total): 5153
Space used by snapshots (total): 0
Off heap memory used (total): 37
SSTable Compression Ratio: 1.0851063829787233
Number of partitions (estimate): 2
Memtable cell count: 1
Memtable data size: 139
Memtable off heap memory used: 0
Memtable switch count: 0
Speculative retries: 0
Local read count: 1000066
Local read latency: 0.054 ms
Local write count: 1
Local write latency: NaN ms
Pending flushes: 0
Percent repaired: 0.0
Bloom filter false positives: 0
Bloom filter false ratio: 0.00000
Bloom filter space used: 16
Bloom filter off heap memory used: 8
Index summary off heap memory used: 21
Compression metadata off heap memory used: 8
Compacted partition minimum bytes: 87
Compacted partition maximum bytes: 103
Compacted partition mean bytes: 103
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
Dropped Mutations: 0
----------------
{code}
*With patch (SHA 89f9cae57a4129ffbc61da19267b0f109685a67f)*
{code:bash}
Results:
Op rate : 54,132 op/s [WRITE: 54,132 op/s]
Partition rate : 54,132 pk/s [WRITE: 54,132 pk/s]
Row rate : 54,132 row/s [WRITE: 54,132 row/s]
Latency mean : 1.8 ms [WRITE: 1.8 ms]
Latency median : 0.7 ms [WRITE: 0.7 ms]
Latency 95th percentile : 3.2 ms [WRITE: 3.2 ms]
Latency 99th percentile : 22.3 ms [WRITE: 22.3 ms]
Latency 99.9th percentile : 132.3 ms [WRITE: 132.3 ms]
Latency max : 423.4 ms [WRITE: 423.4 ms]
Total partitions : 1,000,000 [WRITE: 1,000,000]
Total errors : 0 [WRITE: 0]
Total GC count : 30
Total GC memory : 9.633 GiB
Total GC time : 0.5 seconds
Avg GC time : 17.7 ms
StdDev GC time : 6.5 ms
Total operation time : 00:00:18
> bin/nodetool tablestats system_auth.roles
Total number of tables: 38
----------------
Keyspace : system_auth
Read Count: 65
Read Latency: 0.1866769230769231 ms
Write Count: 14
Write Latency: 0.20242857142857143 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: -1.0
Number of partitions (estimate): 1
Memtable cell count: 2
Memtable data size: 278
Memtable off heap memory used: 0
Memtable switch count: 0
Speculative retries: 0
Local read count: 53
Local read latency: 0.229 ms
Local write count: 2
Local write latency: NaN ms
Pending flushes: 0
Percent repaired: 100.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
Dropped Mutations: 0
----------------
{code}
Before CASSANDRA-20090 (SHA b18a7064fda7585dac856cf63984196b7ea9300d)
{code:bash}
Results:
Op rate : 51,043 op/s [WRITE: 51,043 op/s]
Partition rate : 51,043 pk/s [WRITE: 51,043 pk/s]
Row rate : 51,043 row/s [WRITE: 51,043 row/s]
Latency mean : 1.9 ms [WRITE: 1.9 ms]
Latency median : 0.7 ms [WRITE: 0.7 ms]
Latency 95th percentile : 3.0 ms [WRITE: 3.0 ms]
Latency 99th percentile : 23.2 ms [WRITE: 23.2 ms]
Latency 99.9th percentile : 136.8 ms [WRITE: 136.8 ms]
Latency max : 479.2 ms [WRITE: 479.2 ms]
Total partitions : 1,000,000 [WRITE: 1,000,000]
Total errors : 0 [WRITE: 0]
Total GC count : 31
Total GC memory : 9.624 GiB
Total GC time : 0.6 seconds
Avg GC time : 18.2 ms
StdDev GC time : 7.2 ms
Total operation time : 00:00:19
> bin/nodetool tablestats system_auth.roles
Total number of tables: 38
----------------
Keyspace : system_auth
Read Count: 69
Read Latency: 0.17018840579710143 ms
Write Count: 14
Write Latency: 0.11914285714285713 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: -1.0
Number of partitions (estimate): 1
Memtable cell count: 2
Memtable data size: 278
Memtable off heap memory used: 0
Memtable switch count: 0
Speculative retries: 0
Local read count: 57
Local read latency: 0.186 ms
Local write count: 2
Local write latency: NaN ms
Pending flushes: 0
Percent repaired: 100.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
Dropped Mutations: 0
----------------
{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]
