[
https://issues.apache.org/jira/browse/CASSANDRA-19947?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17913391#comment-17913391
]
Bernardo Botella Corbi commented on CASSANDRA-19947:
----------------------------------------------------
Awesome [~dnk]! Thanks a lot for putting some love into this as well! So,
following your recommendations and some suggestions by [~smiklosovic] for
optimizations, these are the new reports that I got with only writes and aiming
for 10K/s requests
{code:java}
Trunk baseline
Writes Reads
Deletes Errors
Count Latency (p99) 1min (req/s) | Count Latency (p99) 1min (req/s) |
Count Latency (p99) 1min (req/s) | Count 1min (errors/s)
6659762 0.13 9999.85 | 0 0 0 |
0 0 0 | 0 0
6689761 0.15 9999.86 | 0 0 0 |
0 0 0 | 0 0
6719711 0.15 9999.86 | 0 0 0 |
0 0 0 | 0 0
6749755 0.14 9999.88 | 0 0 0 |
0 0 0 | 0 0
6779761 0.14 9999.89 | 0 0 0 |
0 0 0 | 0 0
6809761 0.18 9999.89 | 0 0 0 |
0 0 0 | 0 0
6839713 0.15 9999.88 | 0 0 0 |
0 0 0 | 0 0
6869761 0.15 9999.88 | 0 0 0 |
0 0 0 | 0 0
6899761 0.15 9999.9 | 0 0 0 |
0 0 0 | 0 0
6929673 0.15 9999.91 | 0 0 0 |
0 0 0 | 0 0
Writes Reads
Deletes Errors
Count Latency (p99) 1min (req/s) | Count Latency (p99) 1min (req/s) |
Count Latency (p99) 1min (req/s) | Count 1min (errors/s)
6929673 0.15 9999.91 | 0 0 0 |
0 0 0 | 0 0
CEP-42: No constraints defined
Writes Reads
Deletes Errors
Count Latency (p99) 1min (req/s) | Count Latency (p99) 1min (req/s) |
Count Latency (p99) 1min (req/s) | Count 1min (errors/s)
6659803 0.14 9999.85 | 0 0 0 |
0 0 0 | 0 0
6689801 0.14 9999.87 | 0 0 0 |
0 0 0 | 0 0
6719779 0.13 9999.87 | 0 0 0 |
0 0 0 | 0 0
6749801 0.13 9999.88 | 0 0 0 |
0 0 0 | 0 0
6779756 0.13 9999.89 | 0 0 0 |
0 0 0 | 0 0
6809801 0.13 9999.89 | 0 0 0 |
0 0 0 | 0 0
6839801 0.13 9999.9 | 0 0 0 |
0 0 0 | 0 0
6869801 0.13 9999.9 | 0 0 0 |
0 0 0 | 0 0
6899777 0.12 9999.89 | 0 0 0 |
0 0 0 | 0 0
6929758 0.12 9999.92 | 0 0 0 |
0 0 0 | 0 0
Writes Reads
Deletes Errors
Count Latency (p99) 1min (req/s) | Count Latency (p99) 1min (req/s) |
Count Latency (p99) 1min (req/s) | Count 1min (errors/s)
6929894 0.12 9999.92 | 0 0 0 |
0 0 0 | 0 0
CEP-42: With one constraint defined
Writes Reads
Deletes Errors
Count Latency (p99) 1min (req/s) | Count Latency (p99) 1min (req/s) |
Count Latency (p99) 1min (req/s) | Count 1min (errors/s)
6326975 0.12 9502.21 | 0 0 0 |
0 0 0 | 332849 497.67
6355449 0.12 9501.75 | 0 0 0 |
0 0 0 | 334375 498.04
6383910 0.12 9501.75 | 0 0 0 |
0 0 0 | 335879 498.04
6412350 0.11 9501.21 | 0 0 0 |
0 0 0 | 337427 498.57
6440864 0.11 9500.74 | 0 0 0 |
0 0 0 | 338911 499.13
6469377 0.11 9500.74 | 0 0 0 |
0 0 0 | 340447 499.13
6497917 0.11 9500.56 | 0 0 0 |
0 0 0 | 341907 499.42
6526448 0.11 9500.56 | 0 0 0 |
0 0 0 | 343376 499.42
6554929 0.11 9501.54 | 0 0 0 |
0 0 0 | 344894 498.41
6583496 0.11 9501.92 | 0 0 0 |
0 0 0 | 346328 498.03
Writes Reads
Deletes Errors
Count Latency (p99) 1min (req/s) | Count Latency (p99) 1min (req/s) |
Count Latency (p99) 1min (req/s) | Count 1min (errors/s)
6583619 0.11 9501.92 | 0 0 0 |
0 0 0 | 346338 498.03
CEP-42: With two constraint defined
Writes Reads
Deletes Errors
Count Latency (p99) 1min (req/s) | Count Latency (p99) 1min (req/s) |
Count Latency (p99) 1min (req/s) | Count 1min (errors/s)
6326428 0.16 9501.34 | 0 0 0 |
0 0 0 | 333464 498.5
6354881 0.16 9501.66 | 0 0 0 |
0 0 0 | 334961 498.14
6383408 0.16 9501.66 | 0 0 0 |
0 0 0 | 336483 498.14
6411785 0.16 9501.32 | 0 0 0 |
0 0 0 | 338056 498.58
6440356 0.17 9500.16 | 0 0 0 |
0 0 0 | 339536 499.67
6468898 0.17 9500.16 | 0 0 0 |
0 0 0 | 340994 499.67
6497342 0.18 9501.16 | 0 0 0 |
0 0 0 | 342500 498.76
6525917 0.16 9501.16 | 0 0 0 |
0 0 0 | 343976 498.76
6554464 0.16 9501.7 | 0 0 0 |
0 0 0 | 345427 498.19
6582967 0.18 9502.21 | 0 0 0 |
0 0 0 | 346890 497.65
Writes Reads
Deletes Errors
Count Latency (p99) 1min (req/s) | Count Latency (p99) 1min (req/s) |
Count Latency (p99) 1min (req/s) | Count 1min (errors/s)
6583124 0.18 9502.21 | 0 0 0 |
0 0 0 | 346896 497.65
{code}
> CEP-42: Constraints Framework
> -----------------------------
>
> Key: CASSANDRA-19947
> URL: https://issues.apache.org/jira/browse/CASSANDRA-19947
> Project: Apache Cassandra
> Issue Type: Improvement
> Components: CQL/Syntax
> Reporter: Bernardo Botella
> Assignee: Bernardo Botella
> Priority: Normal
> Attachments: ci_summary.html
>
> Time Spent: 24.5h
> Remaining Estimate: 0h
>
> Add new Constraints framework as described in CEP-42. This initial Jira
> ticket includes the core constraints length and numeric. Follow up tickets
> will include the rest of the constraints described in the CEP.
>
> [https://cwiki.apache.org/confluence/display/CASSANDRA/CEP-42%3A+Constraints+Framework]
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
