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) Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Enterprise Monitor: Web Severity:S3 (Non-critical)
Version:3.0.6 OS:Any
Assigned to: 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] Umesh Shastry
Hello Daniel,

Thank you for the bug report!

Thanks,
Umesh