Bug #74652 "user has rights to non existing table rule data collection is not preconditione
Submitted: 31 Oct 2014 16:36 Modified: 9 Jan 2015 10:10
Reporter: Tony Holmes Email Updates:
Status: Closed Impact on me:
Category:MySQL Enterprise Monitor: Advisors/Rules Severity:S3 (Non-critical)
Version:3.0.X OS:Windows
Assigned to: CPU Architecture:Any

[31 Oct 2014 16:36] Tony Holmes
Advisor reports on table permissions, where tables are not preconditioned, this causes each event (run every five minutes) to take more than five minutes to run.  This inevitably causes a backlog of queries and leads to extensive use of swap and maxing the CPU.

How to repeat:
Install MEM without prerequisite tables

Suggested fix:
make tables preconditioned.