Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

MySQL Exporter with PostgreSQL Queries in QAN

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

 

 

How to test

None

How to document

None

Attachments

3
  • 11 May 2021, 02:58 PM
  • 15 Jan 2020, 09:35 AM
  • 07 Jan 2020, 02:59 AM

Smart Checklist

Activity

Zoriana Stefanyshyn May 19, 2021 at 8:03 AM

Closing as fixed.

Zoriana Stefanyshyn May 11, 2021 at 2:58 PM

Verified on pmm-latest (2.17.0).

The issue is not reproducing.

Lalit Choudhary January 15, 2020 at 9:35 AM
Edited

Verified the same as described with PMM 2.2.0

Step to reproduce:

Install pmmm 2.2.0

add mysql instance 

selecting QAN via MySQL dashboard show  PostgreSQL queries on the QAN dashboard. 

Expected behavior: It should filter and show queries for mysql instances only 

 

Roma Novikov January 7, 2020 at 8:27 PM

, the PG queries are from PMM Server. We use PG inside and monitoring PG inside PMM.
The bug here is about filtering - there is the wrong behavior when you pass some hidden parameters. (And this is some problem with dashboards and parameters )

Chris Schneider January 7, 2020 at 3:48 PM

I did go direct from the MySQL Dashboard to QAN.  After I removed the filters there are no queries that come up in QAN.  With that said, I don't have PostgreSQL in my environment and found it odd to see in QAN given my setup.

Done

Details

Assignee

Reporter

Priority

Components

Labels

Story Points

Affects versions

Smart Checklist

Created January 7, 2020 at 3:00 AM
Updated November 13, 2024 at 9:48 AM
Resolved May 19, 2021 at 8:04 AM

Flag notifications