Not the answer you need?
Register and ask your own question!

PMM 2.0.1 qan does not shows mysql instances.

StaterosStateros ContributorCurrent User Role Advisor
Hello.
I have added few DB instances to monitoring:
pmm-admin add mysql slave3.db.com 127.0.0.1:3306 --debug --query-source=slowlog --username=pmm --password=pmm_password --environment=prod --cluster=db-prod

Response looks ok:
DEBUG 2019-11-08 13:04:32.167771799Z: Result: &management.addMySQLResult{Service:(*my_sql.AddMySQLOKBodyService)(0xc0001aa000)}
DEBUG 2019-11-08 13:04:32.167790319Z: Error: <nil>
MySQL Service added.
Service ID  : /service_id/301bcf55-eb8a-45ea-8fa7-ed501a331cdf
Service name: slave3.db.com
Service type  Service name         Address and port  Service ID
MySQL         slave3.db.com 127.0.0.1:3306    /service_id/301bcf55-eb8a-45ea-8fa7-ed501a331cdf

Agent type                  Status     Agent ID                                        Service ID
pmm-agent                   connected  /agent_id/052d4e27-919c-4767-a553-e2ccecd91b74
node_exporter               running    /agent_id/b388d1c2-cc12-4ef2-a2cf-8b1839185054
mysqld_exporter             running    /agent_id/9ba3cbbf-9497-421b-9e67-850f5abe0cf1  /service_id/301bcf55-eb8a-45ea-8fa7-ed501a331cdf
qan-mysql-slowlog-agent     running    /agent_id/94a8066d-9ec1-4146-a008-a360122afc4a  /service_id/301bcf55-eb8a-45ea-8fa7-ed501a331cdf

All mysql metrics works, but there are no any data in Query analyzer.



Is there any logs to understand what is going on? Slow-log - exists and worked in pmm 1.17.1

Comments

Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.