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

QAN Explain and Table information

dalomandaloman EntrantCurrent User Role Beginner
Hi!

First of all, thanks to Percona for PMM, it's very useful instrument!

If there any possibility to fill database and table name fields automatically if they are already in query example?
pmm_qan_explain_demo.png

pmm_qan_explain_local.png
[root@localhost ~]# pmm-admin info
pmm-admin 1.0.4-dev20160819.01df25a

PMM Server      | 10.1.10.132
Client Name     | localhost.localdomain
Client Address  | 127.0.0.1
Service manager | linux-systemd
[root@localhost ~]# docker ps
CONTAINER ID        IMAGE                                          COMMAND                CREATED             STATUS              PORTS                         NAMES
1f13b37b77bd        percona/pmm-server:1.0.4-dev20160819.2fe41fe   "/opt/entrypoint.sh"   56 minutes ago      Up 56 minutes       0.0.0.0:80->80/tcp, 443/tcp   pmm-server

Comments

  • carlos.salguerocarlos.salguero Percona Toolkit Developer Percona Staff Role
    Hi,

    DB and table names comes from parsing the slow log, not he queries itself.
    There is an option to not so send query examples at all, so we cannot parse queries and even if we could, for simple queries it might be doable for for queries having sub-queries it is not reliable.
This discussion has been closed.

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