Uploaded image for project: 'Couchbase Server'
  1. Couchbase Server
  2. MB-24079

[Plasma RQG Performance] Queries running with secondary indexes are slower as compared to forestdb settings

    XMLWordPrintable

Details

    • Untriaged
    • No

    Description

      Job run:
      cen006-n1ql-vset01-01-rqg-aggregate-methods-simple-table-gsi-tests

      Run 1:forestdb indexer storage mode settings: this job takes 20 mins to complete.
      Run 2:Plasma indexer storage mode settings: this job takes 8 hour 25 mins to complete.

      The parameters ,queries run and secondary indexes created,VM configurations,cluster used are same for both runs.
      Also results are same and as expected for both runs.

      Exact test which runs:

      ./testrunner.py -i <ini file> -p gsi_type=<plasma or forestdb> -t rqg.test_rqg.RQGTests.test_rqg_concurrent_with_secondary,test_file_path=b/resources/rqg/simple_table_db/query_tests_using_templates/query_50000_aggregate_functions.txt.zip,database=simple_table_db,reset_database=True,concurreny_count=5,index_quota_percent=30,password=password,use_mysql=True,replicas=0,run_query_with_secondary=True,run_explain_with_hints=True,total_queries=2000,record_failure=True,check_covering_index=True,failure_record_path=/tmp
      

      Attaching logs for both runs.
      The cluster is left intact for debugging:
      http://172.23.107.165:8091/

      Attachments

        1. logs-forestdb.zip
          65.72 MB
        2. logs-plasma.zip
          40.27 MB
        No reviews matched the request. Check your Options in the drop-down menu of this sections header.

        Activity

          People

            Prerna.Manaktala Prerna Manaktala (Inactive)
            Prerna.Manaktala Prerna Manaktala (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            7 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Gerrit Reviews

                There are no open Gerrit changes

                PagerDuty