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

Increase in intial indexing time for plasma non-dgm partitioned

    XMLWordPrintable

Details

    • Untriaged
    • Centos 64-bit
    • 1
    • Yes

    Description

      4712 - http://perf.jenkins.couchbase.com/job/arke-dgm/845/ - 21.8

      4711 - http://perf.jenkins.couchbase.com/job/arke-dgm/842/ - 18.3

      http://cbmonitor.sc.couchbase.com/reports/html/?snapshot=arke_700-4711_create_indexes_691d&snapshot=arke_700-4712_create_indexes_1f41
      CREATE INDEX ag1 ON `bucket-1`(DATE_PART_STR(sold_date, 'year'), customer.state, store, quantity) PARTITION BY HASH(store) WITH {"defer_build": true};
      CREATE INDEX ag2 ON `bucket-1`(DATE_PART_STR(sold_date, 'year'), DATE_PART_STR(sold_date, 'week'), WEEKDAY_STR(sold_date), sales_price) PARTITION BY HASH(sold_date) WITH {"defer_build": true};
      CREATE INDEX ag3 ON `bucket-1`(item.manufacturer_id, DATE_PART_STR(sold_date, 'month'), DATE_PART_STR(sold_date, 'year'), item.brand, sales_price) PARTITION BY HASH(sold_date) WITH {"defer_build": true};
      CREATE INDEX ag4 ON `bucket-1`(DATE_PART_STR(sold_date, 'year'), customer.preferred_flag, customer.birth_country, wholesale_cost, sales_price) PARTITION BY HASH(customer.birth_country) WITH {"defer_build": true};
      CREATE INDEX ag5 ON `bucket-1`(DATE_PART_STR(sold_date, 'year'), DATE_PART_STR(sold_date, 'month'), sales_price, customer.state) PARTITION BY HASH(customer.state) WITH {"defer_build": true};
      CREATE INDEX ag6 ON `bucket-1`(customer.gender, customer.marital_status, customer.education_status, item.id, quantity, list_price, coupon_amt, sales_price) PARTITION BY HASH(item.id) WITH {"defer_build": true};
      CREATE INDEX ag7 ON `bucket-1`(customer.zip, customer.preferred_flag) PARTITION BY HASH(customer.zip) WITH {"defer_build": true};
      CREATE INDEX ag8 ON `bucket-1`(customer.county, DATE_PART_STR(sold_date, 'year'), DATE_PART_STR(sold_date, 'month'), customer.gender, customer.marital_status, customer.education_status, customer.purchase_estimate, customer.credit_rating, customer.dep_count, customer.dep_employed_count, customer.dep_college_count) PARTITION BY HASH(customer.county) WITH {"defer_build": true};
      CREATE INDEX ag9 ON `bucket-1`(item.category, DATE_PART_STR(sold_date, 'day_of_year'), sales_price) PARTITION BY HASH(item.category) WITH {"defer_build": true};
      CREATE INDEX ag10 ON `bucket-1`(customer.zip, DATE_PART_STR(sold_date, 'year'), DATE_PART_STR(sold_date, 'quarter'), sales_price) PARTITION BY HASH(customer.zip) WITH {"defer_build": true};
      BUILD INDEX ON `bucket-1`(ag1, ag2, ag3, ag4, ag5, ag6, ag7, ag8, ag9, ag10);
      http://changelog.build.couchbase.com/?product=couchbase-server&fromVersion=7.0.0&fromBuild=4711&toVersion=7.0.0&toBuild=4714&f_backup=off&f_cbbs=off&f_eventing=off&f_go-couchbase=off&f_goxdcr=off&f_indexing=on&f_kv_engine=off&f_ns_server=off&f_product-metadata=off&f_query=off&f_testrunner=off

      Attachments

        1. cpu_4711.png
          cpu_4711.png
          41 kB
        2. cpu_4712.png
          cpu_4712.png
          41 kB
        3. rss_4711.png
          rss_4711.png
          43 kB
        4. rss_4712.png
          rss_4712.png
          44 kB
        No reviews matched the request. Check your Options in the drop-down menu of this sections header.

        Activity

          People

            korrigan.clark Korrigan Clark (Inactive)
            korrigan.clark Korrigan Clark (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Gerrit Reviews

                There are no open Gerrit changes

                PagerDuty