My pmm server records requests that do not exist?

I have a pmm server in 2.27.0 and I noticed that on my query Analytics I see paired requests while the server was not receiving any requests. What’s wrong with that?

image

1 Like

Hello, it is hard to say without looking at the full picture. Those might be queries on the internal PMM database. Did you check the filters on the left side?

1 Like

hello yes I checked on the left and in my table I see requests that come from my mysql server.

1 Like

@venomania,
Yes, the queries you are seeing from your mysql server are PMM queries, like @igroene said. PMM will execute certain queries every couple of seconds to collect data. If you could screenshot the queries, we can confirm.

1 Like

@matthewb @igroene
Hello, unfortunately I can’t screnn because the requests that come out are not pmm requests but my company’s requests and they are confidential.
I know that they are mine because I have a list of the requests that I play on the mysql server and it is those that appear.

I also have pmm requests but I have filtered them.

1 Like

If you see data in QAN, that means MySQL processed it. Plain and simple. The data in PMM comes directly from MySQL.

1 Like

ok but then it’s normal that my sum is too much example I have a query that runs 200 times but on the sum of pmm it runs + 912 times in 5 minutes with the mysql server that does not run any query

1 Like

You can look in your slow query log manually and verify how many times the query executed. PMM reads data from this log.

1 Like

I don’t have the slow_query to activate what can I do in this case?

1 Like

Did you set up PMM to scrape the performance_schema?

1 Like

yes 'I configured pmm with performance_schema

1 Like

Then you can examine the p_s tables yourself and verify the data that PMM is scraping. If PMM queries the p_s tables and that table says ‘955 executions’, then that’s the value PMM shows and that’s the value MySQL recorded. PMM doesn’t make anything up; the data comes from MySQL.

1 Like