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

Make index_interval configurable per column family

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Resolved
    • Normal
    • Resolution: Fixed
    • 2.0 beta 1
    • None
    • None
    • Cassandra 1.0.7/unix

    Description

      After various experiments with mixing OLTP a OLAP workload running on single cassandra cluster i discovered that lot of memory is wasted on holding index samples for CF which are rarely accessed or index is not much used for CF access because slices over keys are used.

      There is per column family setting for configuring bloom filters - bloom_filter_fp_chance. Please add setting index_interval configurable per CF as well. If this setting is not set or it is zero, default from cassandra.yaml will be used.

      Attachments

        1. cass-interval1.txt
          50 kB
          Radim Kolar
        2. cass-interval2.txt
          59 kB
          Radim Kolar
        3. cass-interval3.txt
          310 kB
          Radim Kolar
        4. cass-interval4.txt
          55 kB
          Radim Kolar
        5. cass-interval5.txt
          310 kB
          Radim Kolar
        6. cass-interval6.txt
          303 kB
          Radim Kolar

        Issue Links

          Activity

            People

              hsn Radim Kolar
              hsn Radim Kolar
              Radim Kolar
              Jonathan Ellis
              Votes:
              2 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: