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

MySQL Exporter with PostgreSQL Queries in QAN

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Open
    • Priority: Medium
    • Resolution: Unresolved
    • Affects Version/s: 2.2.0
    • Fix Version/s: None
    • Component/s: PMM Client
    • Labels:

      Description

       

      Hello,

      I am seeing an issue where I've set up PMM2 via docker, configured the pmm-admin version 2 client and added MySQL metrics and QAN slow logging.  I see queries that belong in PostgreSQL in QAN and don't understand why given the set up.

      Can you help me understand why I would be seeing PostgreSQL queries running on a MySQL server with this setup?

      docker ps -a
      
      CONTAINER ID        IMAGE                  COMMAND                CREATED             STATUS              PORTS                                      NAMES
      a76fe14a3a22        percona/pmm-server:2   "/opt/entrypoint.sh"   3 days ago          Up 3 days           0.0.0.0:80->80/tcp, 0.0.0.0:443->443/tcp   pmm-server
      dd3dff8b5d93        percona/pmm-server:2   "/bin/true"            3 days ago          Created                                                        pmm-data
      

      The clients running are as follows:

      pmm-admin list
      Service type  Service name         Address and port  Service ID
      MySQL         chi1-402-mysql       10.128.56.166:17503 /service_id/4d91d36a-0e54-4604-aeb9-022129006295
      MySQL         chi1-303-mysql       10.128.56.166:17404 /service_id/50045767-883b-48c9-9b35-f9eaa3d9d837
      MySQL         chi1-100-mysql       10.128.56.166:17201 /service_id/d52814e2-055a-4abf-a7a6-cb2364b68775
      MySQL         chi1-503-mysql       10.128.56.166:17604 /service_id/f61a5868-3745-4ab7-a3a3-7564df16b16dAgent type                  Status     Agent ID                                        Service ID
      pmm-agent                   connected  /agent_id/ca5c7af8-afbf-4f05-9430-53632d88178e
      node_exporter               running    /agent_id/d98befe9-9f6d-4668-a3e2-7007526747ec
      mysqld_exporter             running    /agent_id/0e2d6bc1-4758-4a7c-a0be-427a9a9f03aa  /service_id/4d91d36a-0e54-4604-aeb9-022129006295
      mysqld_exporter             running    /agent_id/38726f47-ef28-4457-af1e-f9b4cd77e704  /service_id/50045767-883b-48c9-9b35-f9eaa3d9d837
      mysqld_exporter             running    /agent_id/a32f12c7-6004-46a9-8e81-53c6c6e8d5f7  /service_id/d52814e2-055a-4abf-a7a6-cb2364b68775
      mysqld_exporter             running    /agent_id/fdddfffb-08c2-4947-8682-358b1c1cd913  /service_id/f61a5868-3745-4ab7-a3a3-7564df16b16d
      qan-mysql-slowlog-agent     running    /agent_id/28d41cfe-994c-4931-b71f-e573daf28298  /service_id/50045767-883b-48c9-9b35-f9eaa3d9d837
      qan-mysql-slowlog-agent     running    /agent_id/3978bfcc-1ad8-4b5f-8395-523384eaca07  /service_id/4d91d36a-0e54-4604-aeb9-022129006295
      qan-mysql-slowlog-agent     running    /agent_id/3a2ed849-a2cf-45df-b9cd-1c3a3cea70e0  /service_id/d52814e2-055a-4abf-a7a6-cb2364b68775
      qan-mysql-slowlog-agent     running    /agent_id/b9340588-a607-49df-b3a0-cfffc5dac4c1  /service_id/f61a5868-3745-4ab7-a3a3-7564df16b16d
      

      Queries in QAN

       

       

        Smart Checklist

          Attachments

            Activity

              People

              Assignee:
              Unassigned
              Reporter:
              schneiderdba@gmail.com Chris Schneider
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

                Dates

                Created:
                Updated: