Hi, we’re using percona management and monitoring 2.35.0 version. The problem is that QAN dashboard does not show the SQL queries examples and explains.
for query examples pmm we are got this msg “Sorry, no examples found for this query”
and for explain “no explain found”
mysql> select * from performance_schema.setup_consumers;
±---------------------------------±--------+
| NAME | ENABLED |
±---------------------------------±--------+
| events_stages_current | NO |
| events_stages_history | NO |
| events_stages_history_long | NO |
| events_statements_cpu | NO |
| events_statements_current | YES |
| events_statements_history | YES |
| events_statements_history_long | NO |
| events_transactions_current | YES |
| events_transactions_history | YES |
| events_transactions_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 |
±---------------------------------±--------+
16 rows in set (0.07 sec)
mysql>
mysql> show variables like “%performance_schema%”;
±---------------------------------------------------------±------+
| Variable_name | Value |
±---------------------------------------------------------±------+
| performance_schema | ON |
±---------------------------------------------------------±------+
mysql configuration
max_digest_length = 20240
performance_schema_max_digest_length = 20240
performance_schema_max_sql_text_length = 20240
Data Source: Amazon RDS
Database engine: mysql 8