[CASSANDRA-18104] Major Performance degradation of Casandara 4.0.7 against Casandra 3.11.14

• Type: Bug
• Status: Resolved
• Priority: Urgent
• Resolution: Invalid
• Severity: Critical
• Platform: All
• Assignee: Unassigned
• Reporter: Sreedhar J
• Created: 08/Dec/22 16:28
• Updated: 21/Dec/22 07:35
• Resolved: 21/Dec/22 07:35

Description

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