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

Memory Leak or extensive use for PostgreSQL QAN

    XMLWordPrintable

Details

    • 3
    • Yes
    • Yes
    • Yes
    • No

    Description

      MySQL 8 Memory usage by pmm-agent 

      Percona Distribution for PostgreSQL  memory usage 

      We’re looking at some 10MB of resident memory usage at MySQL  which is balpark correct vs more than 400MB for PostgreSQL which is extreme.  Note also almost 2GB of virtual memory used node is swapping heavily.

      Attachments

        1. image-2020-01-10-10-55-16-402.png
          image-2020-01-10-10-55-16-402.png
          63 kB
        2. image-2020-01-10-11-57-31-816.png
          image-2020-01-10-11-57-31-816.png
          178 kB
        3. image-2020-01-10-11-59-36-127.png
          image-2020-01-10-11-59-36-127.png
          179 kB
        4. pmm-agent.zip
          41 kB
        5. pmm-managed.zip
          79 kB
        6. pprof_client_host.zip
          53 kB
        7. qan-api2.zip
          34 kB
        8. Screenshot from 2020-01-21 19-38-04.png
          Screenshot from 2020-01-21 19-38-04.png
          196 kB
        9. Screenshot from 2020-01-21 21-38-03.png
          Screenshot from 2020-01-21 21-38-03.png
          110 kB
        10. summary_ip-10-178-2-87_2020_01_09_12_15_29_client_host.zip
          102 kB

        Issue Links

          relates to

          Improvement - An improvement or enhancement to an existing feature or task. PMM-5321 The optimization of the Query Analytics parser code for PostgreSQL queries allowed us to reduce the processor and memory resources consumption by 1-5%, and the parsing time of an individual query by 30-40%

          • Medium - Important issues that need attention but do not significantly disrupt the system's core functionality.
          • Done

          Admin & Maintenance Task - For Percona Internal usage only PMM-5285 Add IsTruncated to pmm-agent's QAN messages

          • Medium - Important issues that need attention but do not significantly disrupt the system's core functionality.
          • Done

          Admin & Maintenance Task - For Percona Internal usage only PMM-5279 Limit caches in size

          • Low - Minor issues that have minimal impact on the system's functionality or usability.
          • Done

          Bug - A problem which impairs or prevents the functions of the product. PMM-5283 Inconsistency with lengths of Example and Fingerprints in Query Analytics

          • Medium - Important issues that need attention but do not significantly disrupt the system's core functionality.
          • Done
          mentioned in

          Page Loading...

          Activity

            People

              Unassigned Unassigned
              roma.novikov Roma Novikov
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Time Tracking

                  Estimated:
                  Original Estimate - 0 minutes
                  0m
                  Remaining:
                  Remaining Estimate - 0 minutes
                  0m
                  Logged:
                  Time Spent - 3 days, 4 hours, 45 minutes
                  3d 4h 45m

                  Smart Checklist