Hi, we have setup pmm queries analytics in order to track down and fix slow queries on our app but it seem that the load, count and latency graphs are not working as expected.
We getting the data from the mysql slow-queries.log and can confirm that the queries in the slow-queries.log are happening at various times during the day but the graph are showing the all the queries happened just at certain point in time.
What could be causing this issue?
Your help will be truly appreciated.
Hi Guys, I’m still experiencing this issue.
Hello webbox.eric welcome to the forum and thanks for your question. I wonder if I could get you to run through the information in this blog post about troubleshooting PMM :
[LIST]
[]https://www.percona.com/blog/2018/01…t-pmm-metrics/
[/LIST] Also could you just run through this too, to make sure everything is set up as expected:
[LIST]
[]https://www.percona.com/doc/percona-…onf-mysql.html
[/LIST] If you are still struggling could you provide this information:
[LIST]
[]versions of all software (PMM, database)
[]details of environment (versions etc)
[]if there are any error logs being recorded
[]configuration file for MySQL
[/LIST] Once we have that I will alert the PMM team to your question to see if they can help you through.
THANKS!
Hi Lorraine.pocklington,
Thanks for getting back to me on this.
I’ve gone through the suggested post and the metrics seems to work as expected. The issue is not much with the metrics but only with the Query Analytics.
We have a remote server(freebsd 10) where pmm client cannot be installed so we have setup the pmm client and server on a local ubuntu server.
The idea is to copy the slow-queries.log from our production server to this local setup in other to analyse it and fix slow queries.
The my.cnf of the mysql server on the remote freebsd machine set the slow-queries.log to /var/db/mysql/slow-queries.log so i have copied the file to the local machine in the same location and set correct file permissions.
The file is parsed anytime it is updated: [TABLE]
[TR]
[TD]2018-05-31T13:11:00.029555814Z[/TD]
[TD]qan-analyzer-mysql-6788256a-worker[/TD]
[TD]info[/TD]
[TD]Parsed /var/db/mysql/slow-queries.log 22100859-22201653: 100.0% 22201401/22201653 100794 0.0s[/TD]
[/TR]
[/TABLE]
but the graph shows show a few picks where to which it they attribute all the queries and show zero slow query elsewhere. So the issue is the distribution of queries in time.
Please give me your feedback on this
Hi Lorraine,
we’re still having this issue and have attached more details about our setup as you’ve requested.
Please alert the PMM team about this question as you promised to do.
Sorry for the delay.
Unfortunately what you are trying to do isn’t going to work.
qan-agent reads data as it shows up in the slow log file, so for this reason you can’t just copy it from other server.
If you aren’t able to install pmm-client on that system then your best option would be to use performance schema and connect the pmm-client remotely.
There’s information here on configuring performance schema https://www.percona.com/doc/percona-monitoring-and-management/conf-mysql.html
MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright © 2006 - 2021 Percona LLC. All rights reserved.
