Uploaded image for project: 'Cassandra'
  1. Cassandra
  2. CASSANDRA-19345

Not using min/max column name meta data from CASSANDRA-8180 when the LIMIT clause is used

    XMLWordPrintableJSON

Details

    • Degradation - Performance Bug/Regression
    • Normal
    • Normal
    • User Report
    • All
    • None

    Description

      CREATE TABLE tracking_details (
          tracker_public_id text,
          updated_at timeuuid,
          details text,
          PRIMARY KEY (tracker_public_id, updated_at)
      ) WITH CLUSTERING ORDER BY (updated_at DESC)
      INSERT INTO tracking_details  (tracker_public_id, updated_at, details) VALUES('trk_e0544f077f7f4140bf1b961493fa99fe', now(), '{"details":[{...1-3KB }]}');
      nodetool flush trackingdata tracking_details
      INSERT INTO tracking_details  (tracker_public_id, updated_at, details) VALUES('trk_e0544f077f7f4140bf1b961493fa99fe', now(), '{"details":[{...1-3KB }]}');
      
      INSERT INTO tracking_details  (tracker_public_id, updated_at, details) VALUES('trk_e0544f077f7f4140bf1b961493fa99fe', now(), '{"details":[{...1-3KB }]}');
      nodetool flush trackingdata tracking_details
      Compaction is disabled- 
       {'class': 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy', 'enabled': 'false', 'max_threshold': '32', 'min_threshold': '4'}
      show version
      [cqlsh 6.0.0 | Cassandra 4.0.5 | CQL spec 3.4.5 | Native protocol v5]

      Each node is reading from both sstables - Merged data from memtables and 2 sstables. 
      I thought this was fixed - https://issues.apache.org/jira/browse/CASSANDRA-8180_
      But somehow  C* doesn't optimizes the read path

      Dev Cluster Info - 3 Nodes, RF is 3 and CL is LOCAL_QUORUM

      Tracing attached

      Attachments

        1. Jira-Ticket.pdf
          410 kB
          Avneesh Pandey

        Issue Links

          Activity

            People

              Unassigned Unassigned
              avisim14 Avneesh Pandey
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated: