Uploaded image for project: 'Jira Software Server and Data Center'
  1. Jira Software Server and Data Center
  2. JSWSERVER-16471

Add option to do local Lexorank rebalancing

    XMLWordPrintable

Details

    • 3
    • 15
    • We collect Jira feedback from various sources, and we evaluate what we've collected when planning our product roadmap. To understand how this piece of feedback will be reviewed, see our Implementation of New Features Policy.

    Description

      Problem Definition

      Currently when the number of characters on the lengthiest rank field on the AO_60DB71_LEXORANK table exceeds:

      That will lead to the following:

      • Lexorank rebalance job will balance whole space for RANK and that means touching all issues.
      • For large instance this might take significant time (days).

      In some cases, those long RANK values are localised in small area and there is no need to rebalance whole space.
      For example, there is a problem only around space hz :

      1|zzzzzz: 
      1|w00000:                     
      1|hzzzzz:                             
      1|hzzzzy:zzzzzzzzzzzzzzzzzzzzzzzzzzzzy
      1|hzzzzy:zzzzzzzzzzzzzzzzzzzzzzzzzzzzw
      1|hzzzzy:zzzzzzzzzzzzzzzzzzzzzzzzzzzzr
      1|i00000:
      

      In majority cases there are problem with a couple of thousands rows only, while whole table has millions rows.

      Suggested Solution

      Add option for Lexorank rebalancing task for localize those areas and rebalance only them.
      That will significantly reduce length of rebalancing (from days to minutes). As a consequence it reduce load for Jira.

      Workaround

      None

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              ayakovlev@atlassian.com Andriy Yakovlev [Atlassian]
              Votes:
              29 Vote for this issue
              Watchers:
              30 Start watching this issue

              Dates

                Created:
                Updated: