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

Control BM database growth

XMLWordPrintable

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

      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.

        1.
        		 Auto-prune BM database to enforce age-dependent snapshot density Sub-task Closed Jo Asplin (Inactive)

        0%
        Original Estimate - 1 week
        Remaining Estimate - 1 week
        2.
        		 Store only significant changes in the BM database Sub-task Closed Jo Asplin (Inactive)

        0%
        Original Estimate - 2 weeks
        Remaining Estimate - 2 weeks
        3.
        		 Auto-delete all results older than a certain age from the BM database Sub-task Closed Jo Asplin (Inactive)  
        No reviews matched the request. Check your Options in the drop-down menu of this sections header.

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

              Created:
              Updated:
              Resolved:

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

                  There are no open Gerrit changes