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
