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

MySQL Instances Overview: Many monitored instances (~250+) gives 'too long query' error

Details

    • Bug
    • Status: Done
    • High
    • Resolution: Fixed
    • 2.12.0
    • 2.12.0
    • Grafana Dashboards
    • Yes
    • Platform Sprint 30 (2.12+b1)
    • Yes
    • Yes

    Description

      During the Performance testing with VM for 2.12.0, We came across issue with Reports showing the error for Query being too long. 

       

      This is the error visible in MySQL Instances Overview Dashboard, see screenshot for details, the error message is available in the text file as an attachment to this report. 

      This issue could be possible also on other Dashboards, so the fix should cover all scenarios and DB's. 

       

      STR: 

      1) Added around 251 DB services to be monitored across 26 Hosts instances.

      2) MySQL Instances were added for PS 8.0 (both query source perfschema & slowlog)

      3) Wait for some time and Navigate to MySQL Instances Overview Dashboard

      4) See Errors in Reports.

      Expected Result: This should work as expected without any errors in Queries.

      This behaviour has been checked in PMM 2.11.1 and seems to be working fine without any such too long query errors on the same dashboard. 

       

       

       

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              puneet.kala Puneet Kala
              Votes:
              0 Vote for this issue
              Watchers:
              7 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - Not Specified
                  Not Specified
                  Logged:
                  Time Spent - 6 hours, 30 minutes
                  6h 30m

                  Smart Checklist