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?
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?
hello yes I checked on the left and in my table I see requests that come from my mysql server.
@venomania,
Yes, the queries you are seeing from your mysql server are PMM queries, like @Ivan_Groenewold said. PMM will execute certain queries every couple of seconds to collect data. If you could screenshot the queries, we can confirm.
@matthewb @Ivan_Groenewold
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.
If you see data in QAN, that means MySQL processed it. Plain and simple. The data in PMM comes directly from MySQL.
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
You can look in your slow query log manually and verify how many times the query executed. PMM reads data from this log.
I don’t have the slow_query to activate what can I do in this case?
Did you set up PMM to scrape the performance_schema?
yes 'I configured pmm with performance_schema
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.