Uploaded image for project: 'Percona Monitoring and Management'
  1. Percona Monitoring and Management
  2. PMM-10147

Limit amount of connections for one DB from pmm-agent

Details

    • Improvement
    • Status: Done
    • Medium
    • Resolution: Done
    • None
    • 2.30.0
    • None
    • None
    • 3
    • Yes
    • Yes
    • Yes
    • [obsolete] Server Features

    Description

      User story:

      For PG we want to execute some checks on all DBs in each instance. Some our customers have hundreds DBs in one instance. With current implementation check may be started simultaneously for all DBs which may create spike load on DBMS. We should limit amount of concurrent jobs and a amount of opened connections for DBMS instance.

      UI/UX:

       

      Acceptance criteria:

       

      Out of scope:

       

      Suggested implementation:

      1) Use one runner for jobs and actions

      2) Use semaphore to limit total amount of jobs/actions

      3) Use semaphore to limit amount of connections per DBMS instance

      How to test:

      Just check that action and jobs works. For example create some backup with PMM, open QAN and invoke explain for some query there, etc...

      Details:

      Attachments

        Issue Links

          Activity

            People

              catalina.adam Catalina Adam
              artem.gavrilov Artem Gavrilov
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Smart Checklist