Uploaded image for project: 'Red Hat Advanced Cluster Management'
  1. Red Hat Advanced Cluster Management
  2. ACM-3111

Optimize delete query when removing stale data from managed clusters.

XMLWordPrintable

    • No

      Description of problem:

      Currently we create query to delete stale cluster data per cluster. This process should be optimized with a single database query to reduce transactions.

      As we saw in scale environment in larger envs we need to reduce number of db conn, so we need to adjust logic in indexer to delete stale clusters in bulk rather than separately.  After reviewing the implementation realized that deletes are sequential so this bug only blocks 1 database connection.

      Version-Release number of selected component (if applicable):

      How reproducible:

      Steps to Reproduce:

      1. delete or disable managed cluster
      2. go to indexer logs
      3. deletes data on individual basis

      Actual results:

      Expected results:

      Additional info:

              Unassigned Unassigned
              acoba@redhat.com Anxhela Coba
              Xiang Yin Xiang Yin
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

                Created:
                Updated:
                Resolved: