23.3.2 MySQL Instances

Grants access to the monitored instances. This permission must be used with the Server Group permission. If Server Group is set to Read-Only, or higher, it is impossible to set MySQL Instances to None. That is, if Server Group is set to Read-Only, or higher, MySQL Instances must be set to Read-Only at least.

• MySQL Instances: grants access to the data collected on the monitored MySQL Instances. Possible values are:

  • None: No access to MySQL Instances or the data collected on them.

  • Read-Only: access to the MySQL instances, but no rights to create, modify, or delete connections to those instances.

  • Administer: access to the MySQL instances, and can create, modify, and delete connections to those servers.

    Administer is also required to access the bad connections, unreachable agents, and unmonitored instance lists on the MySQL Instances dashboard.

    Administer is also required by the Database File I/O, which requires the sys schema. To install SYS schema from the MySQL Enterprise Monitor User Interface, the user must be assigned to a role with the Administer permission.

    Warning

    It is not possible to add, or start monitoring, a new instance without setting the MySQL Enterprise Monitor permission to Administer.

Query Analysis Permissions

The Query Analysis permissions define access to the Query Analysis page.

• Query Analysis Aggregate Data: access the data collected for the Query Analyzer. This permission also defines access to events which contain Query Analyzer data. Possible values are:

  • None: No access to the aggregated data collected for the Query Analyzer. If this permission is set, the user can open the Query Analyzer page, but the page does not load any aggregated data. This also affects the Query Analyzer graphs.

    Events containing query analysis data are not displayed. Currently, this is limited to events generated by the SQL Statement Generates Warnings or Errors and Average Statement Execution Time advisors.

  • Read-Only: Aggregated data is presented to the user, and the Query Analyzer page is populated.

  • Administer: grants the right to close events containing Query Analysis aggregated data.

• Query Analysis Example and Explain Data: access the data for example and explain plans in the Query Analyzer. This permission depends on the Query Analysis Aggregate Data permission. This permission also defines access to events which contain EXAMPLE and EXPLAIN data. Possible values are:

  • None: no access is granted to the Query Analyzer EXAMPLE and EXPLAIN data.

  • Read-Only: EXAMPLE and EXPLAIN data is accessible. If Query Analysis Aggregate Data is not set to Read-Only, EXAMPLE and EXPLAIN data cannot be accessed.

  • Administer: grants the right to close events containing Query Analysis EXAMPLE and EXPLAIN data.

  Note

  The Query Analyzer permissions depend on the MySQL Instances permission. If MySQL Instances is set to Read-Only, both Query Analyzer permissions are also set to Read-Only. It is possible to set MySQL Instances to Read-Only, or higher, and manually set both Query Analyzer permissions to None, if required.