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

Slow secondary index performance when using VNodes

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Duplicate
    • Fix Version/s: None
    • Component/s: Secondary Indexes
    • Labels:
      None

      Description

      When having a big number of vnodes (such as 256/node advised by http://www.datastax.com/dev/blog/upgrading-an-existing-cluster-to-vnodes), using secondary indices becomes really slow because Cassandra has to search for the index in all the nodes.

      This results in very slow queries (in the order of 1-2s).

      For an exemple, see this tracing with a 3 physical nodes cluster with 256 vnodes on each.
      The keyspace has a RF=3.

      https://gist.github.com/16f510fc349584966a56

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              steeve Steeve Morin
            • Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: