Bug #71857 Add more info about why there is no example query

• Submitted: 27 Feb 2014 8:03
• Modified: 27 Feb 2014 8:37
• Reporter: Daniël van Eeden (OCA)
• Status: Verified
• Category: MySQL Enterprise Monitor: Web
• Severity: S3 (Non-critical)
• Version: 3.0.6
• OS: Any
• CPU Architecture: Any

[27 Feb 2014 8:03] Daniël van Eeden

Description:
In the Query Analyzer the Example Query tab says there is no example query because:
- enable events_statements_history_long might not be enabled 
- performance_schema_events_statements_history_size might be set too low
- Enable example query might not be enabled for the Query analysis reporting advisor

But there is another possible reason why a example query might be missing:
- It might be filtered in setup_objects (SELECT SLEEP(5) FROM mysql.user)
- It might be filtered in setup_actors

How to repeat:
See description

Suggested fix:
Try to tell me exactly why there is no example query.

Is the schema disabled in setup_objects?
Is PFS not configured correctly?

[27 Feb 2014 8:37] MySQL Verification Team

Hello Daniel,

Thank you for the bug report!

Thanks,
Umesh