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

Adding mariadb with disabled Perfshema shows no error and no data in QAN

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Done
    • Priority: Medium
    • Resolution: Fixed
    • Affects Version/s: 2.4.0
    • Fix Version/s: None
    • Component/s: Documentation
    • Labels:
    • Environment:

      Description

      Update: Adding MariaDb 10.x with query-source=perfschema for monitoring doesn't show any data for the instance on QAN, that's because perf schema is not enabled by default on the MD instances, but looking at the logs for pmm-agent or looking at the status of the agent, we can not figure out if that's the problem.

       

      I have checked pmm-agent.log and tried to look for any specific error but couldn't find any, I am attaching log files from server and client both to this ticket. 

      It seems from the logs that agent is sending 0 buckets for MD instance to QAN server

       The expected Behaviour: 
      mysql_perfschema_agent status should be `Waiting` and error logs should contain information about the disabled perfschema

       

       

       

      TODO:

       

      We need to extend  https://www.percona.com/doc/percona-monitoring-and-management/2.x/manage/index-services-mysql.html  with information about  MariaDB and turning on Perf_schema  for it

        Smart Checklist

          Attachments

            Activity

              People

              Assignee:
              Unassigned
              Reporter:
              puneet.kala Puneet Kala
              Votes:
              0 Vote for this issue
              Watchers:
              2 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 - 1 hour, 50 minutes
                  1h 50m