Pmm2 Query Analytics do not show all sql in mysql 5.7

Percona Monitoring and Management (PMM) PMM 2.x
1

Hi Guys,

I run the pmm2 with 2.3.0. When I use query Analytics, I can not found all sql from the output. Especially long running sql (over 10 mins). Any idea about this ? consumers table output like this.

mysql  > SELECT * FROM performance_schema.setup_consumers;
+--------------------------------+---------+
| NAME                           | ENABLED |
+--------------------------------+---------+
| events_stages_current          | NO      |
| events_stages_history          | NO      |
| events_stages_history_long     | NO      |
| events_statements_current      | YES     |
| events_statements_history      | YES     |
| events_statements_history_long | NO      |
| events_waits_current           | NO      |
| events_waits_history           | NO      |
| events_waits_history_long      | NO      |
| global_instrumentation         | YES     |
| thread_instrumentation         | YES     |
| statements_digest              | YES     |
+--------------------------------+---------+
12 rows in set (0.00 sec)

Thanks a lot~

1 Like
2

Hi James,

As I can see the statements_digest consumer is enabled.
Could you check if the mentioned long running sql is present in the table events_statements_summary_by_digest?

1 Like
3

Hi Adivinho,

I can not find the sql in this table. Any idea about this?

Regards,
James

1 Like
4

Maybe this sql is shown in the table performance_schema.prepared_statements_instances :thinking:

1 Like