[
https://issues.apache.org/jira/browse/CASSANDRA-18104?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17646765#comment-17646765
]
Brandon Williams commented on CASSANDRA-18104:
----------------------------------------------
Both machines are running:
{noformat}
openjdk version "1.8.0_342"
OpenJDK Runtime Environment (build 1.8.0_342-8u342-b07-0ubuntu1~20.04-b07)
OpenJDK 64-Bit Server VM (build 25.342-b07, mixed mode)
{noformat}
No configuration changes.
> Major Performance degradation of Casandara 4.0.7 against Casandra 3.11.14
> ----------------------------------------------------------------------------
>
> Key: CASSANDRA-18104
> URL: https://issues.apache.org/jira/browse/CASSANDRA-18104
> Project: Cassandra
> Issue Type: Bug
> Reporter: Sreedhar J
> Priority: Urgent
> Attachments: 3.11.14.txt, 4.0.7.txt,
> cassandra-4x-test-1.0-jar-with-dependencies.jar, mailboxes_snapshot.zip,
> query30.txt, screenshot-1.png, screenshot-2.png
>
>
> Our application uses Casandra 3.11.x and has lot of security vulnerabilities
> which are addressed in 4.0.x. So we have upgraded the Casandra to 4.0.7
> and our performance tests have shown aorund 20% degradation compare to
> 3.11.x
> We are now able to reproduce the same performance degradation using the
> standalone queries. Here are the steps.
> 1. Expand Cassandra 3.11.14 tarball and 4.0.7 tarball to different folders
> 2. Import the attached data from the snapshot (mailboxes_snapshot.zip) into
> each Cassandra instance, see schema.cql for CQL for creating the required
> table and indexes before import
> 3. With CQLSH run the following query several times with TRACING ON and
> PAGING OFF against both versions of Cassandra: select * from
> mailbox.mailboxes where mbx_id= 6c57da2e-7ddd-4984-be62-105415e6b48a;
> 4. Compare results
> IWe ran the target query 30 times. Here's the average times to run the query:
> 3.11.14 - 19400.77
> 4.0.7 - 34906.03
--
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
