[
https://issues.apache.org/jira/browse/CASSANDRA-19947?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17913106#comment-17913106
]
Bernardo Botella Corbi commented on CASSANDRA-19947:
----------------------------------------------------
Posting here the tests I've done with easy-cass-stress tool:
{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)
1663998 0.12 2500.41 | 1665787 0.14 2499.51 |
0 0 0 | 0 0
1671477 0.12 2500.59 | 1673283 0.14 2499.34 |
0 0 0 | 0 0
1679110 0.12 2500.59 | 1680651 0.13 2499.34 |
0 0 0 | 0 0
1686547 0.13 2502.07 | 1688239 0.13 2497.86 |
0 0 0 | 0 0
1693991 0.13 2500.44 | 1695769 0.12 2499.5 |
0 0 0 | 0 0
1701493 0.13 2500.44 | 1703293 0.12 2499.5 |
0 0 0 | 0 0
1709031 0.14 2500.69 | 1710732 0.12 2499.25 |
0 0 0 | 0 0
1716474 0.14 2500.69 | 1718312 0.12 2499.25 |
0 0 0 | 0 0
1723924 0.14 2499.07 | 1725838 0.12 2500.88 |
0 0 0 | 0 0
1731399 0.14 2498.85 | 1733361 0.12 2501.1 |
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)
1731465 0.14 2498.85 | 1733428 0.12 2501.1 |
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)
1664175 0.11 2501.38 | 1665604 0.11 2498.55 |
0 0 0 | 0 0
1671812 0.11 2503.2 | 1672967 0.11 2496.73 |
0 0 0 | 0 0
1679241 0.11 2503.2 | 1680587 0.11 2496.73 |
0 0 0 | 0 0
1686762 0.11 2501.11 | 1688020 0.11 2498.83 |
0 0 0 | 0 0
1694378 0.11 2503.74 | 1695426 0.11 2496.21 |
0 0 0 | 0 0
1701935 0.11 2503.74 | 1702893 0.11 2496.21 |
0 0 0 | 0 0
1709376 0.11 2503.18 | 1710403 0.11 2496.77 |
0 0 0 | 0 0
1716934 0.11 2503.18 | 1717894 0.11 2496.77 |
0 0 0 | 0 0
1724284 0.11 2503.15 | 1725496 0.11 2496.8 |
0 0 0 | 0 0
1731753 0.11 2501.22 | 1733008 0.11 2498.74 |
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)
1731753 0.11 2501.22 | 1733008 0.11 2498.74 |
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)
1581266 0.11 2369.94 | 1665593 0.11 2504.69 |
0 0 0 | 82960 125.3
1588345 0.11 2370.91 | 1673105 0.11 2503.93 |
0 0 0 | 83323 125.08
1595434 0.11 2370.91 | 1680608 0.11 2503.93 |
0 0 0 | 83730 125.08
1602631 0.11 2370.35 | 1688081 0.11 2503.86 |
0 0 0 | 84106 125.72
1609711 0.11 2370.57 | 1695624 0.11 2503.84 |
0 0 0 | 84481 125.53
1616729 0.11 2370.57 | 1703193 0.11 2503.84 |
0 0 0 | 84849 125.53
1623952 0.11 2370.01 | 1710683 0.11 2505.08 |
0 0 0 | 85184 124.85
1631081 0.11 2370.01 | 1718104 0.11 2505.08 |
0 0 0 | 85588 124.85
1638167 0.11 2371.51 | 1725603 0.11 2503.03 |
0 0 0 | 86006 125.4
1645330 0.11 2371.81 | 1733045 0.11 2502.31 |
0 0 0 | 86381 125.87
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)
1645330 0.11 2371.81 | 1733045 0.11 2502.31 |
0 0 0 | 86381 125.87
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)
1582617 0.11 2377.71 | 1664222 0.13 2497.82 |
0 0 0 | 82793 124.43
1589799 0.11 2377.91 | 1671698 0.14 2497.79 |
0 0 0 | 83157 124.22
1596844 0.11 2377.91 | 1679233 0.14 2497.79 |
0 0 0 | 83553 124.22
1604144 0.11 2377.41 | 1686615 0.14 2498.22 |
0 0 0 | 83895 124.31
1611253 0.11 2378.93 | 1694107 0.14 2496.94 |
0 0 0 | 84271 124.07
1618334 0.11 2378.93 | 1701648 0.14 2496.94 |
0 0 0 | 84668 124.07
1625510 0.12 2377.83 | 1709104 0.13 2497.85 |
0 0 0 | 85034 124.25
1632662 0.12 2377.83 | 1716536 0.13 2497.85 |
0 0 0 | 85432 124.25
1639780 0.12 2378.26 | 1724066 0.13 2496.73 |
0 0 0 | 85808 124.97
1646925 0.11 2378.67 | 1731540 0.14 2496.67 |
0 0 0 | 86172 124.62
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)
1646989 0.11 2378.67 | 1731595 0.14 2496.67 |
0 0 0 | 86174 124.62
{code}
There is a small impact (around 5%) on the req/sec when adding constraints. But
other than that, I think the overhead added should not be a blocker.
> 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: 19.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: commits-unsubscr...@cassandra.apache.org
For additional commands, e-mail: commits-h...@cassandra.apache.org
