Uploaded image for project: 'Qt Quality Assurance Infrastructure'
  1. Qt Quality Assurance Infrastructure
  2. QTQAINFRA-262

Control BM database growth

    XMLWordPrintable

Details

    • Task
    • Resolution: Out of scope
    • P0: Blocker
    • 2012q4
    • None
    • Performance tracking
    • None

    Description

      As of 13/4 2011, the results table contains 11,327,562 rows. A rough estimate suggests that this table currently grows by around 175,000 rows per day (7 active branches reporting 5 results for 2,000 benchmarks 2-3 times per day).

      Update: As of 12/4 2011, the results table contains 22,594,985 rows. This indicates an average growth rate of 93,119 rows per day since 13/4.

      Unless this growth rate is reduced, the database performance will gradually suffer until either the user responsiveness becomes unacceptable or the disk runs full.

      Another problem is that very long time series are harder to interact with in the user interface (see QTQAINFRA-292).

      Note: Although the following subtasks are intended as mutually exclusive solutions to this problem, they could also be applied in combination.

      Attachments

        Issue Links

          relates to

          Sub-task - The sub-task of the issue QTQAINFRA-218 Avoid performance tracking of redundant data tags

          • P2: Important - Urgent, should be fixed, but will not stop the release.
          • Closed

          Sub-task - The sub-task of the issue QTQAINFRA-61 Remove unstable benchmarks

          • P2: Important - Urgent, should be fixed, but will not stop the release.
          • Closed

          Task - A task that needs to be done. QTQAINFRA-292 Make BM tool time series plot scalable

          • P1: Critical - Urgent and Important, will STOP the release if matched with set FixVersion field. This includes regressions from the last version that are not edge cases; Data loss; Build issues; All but the most unlikely crashes/lockups/hanging; Serious usability issues and embarrassing bugs & Bugs critical to a deliverable. This is the highest possible priority for requirements.
          • Closed
          There are no Sub-Tasks for this issue.
          No reviews matched the request. Check your Options in the drop-down menu of this sections header.

          Activity

            People

              seahumad [BB] Sergio Ahumada (Inactive)
              bdo Jo Asplin (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Time Tracking

                  Estimated:
                  Original Estimate - 3 weeks
                  3w
                  Remaining:
                  Remaining Estimate - 3 weeks
                  3w
                  Logged:
                  Time Spent - Not Specified
                  Not Specified

                  Gerrit Reviews

                    There are no open Gerrit changes