MySQL Enterprise Monitor 8.0 Release Notes
Grants access to the monitored instances. This permission must be used with theServer Grouppermission. IfServer Groupis set to Read-Only, or higher, it is impossible to setMySQL Instancesto None. That is, ifServer Groupis set to Read-Only, or higher,MySQL Instancesmust 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 theMySQL Instancesdashboard.
Administeris also required by theDatabase File I/O, which requires the
sysschema. To install SYS schema from the MySQL Enterprise Monitor User Interface, the user must be assigned to a role with theAdministerpermission.WarningIt is not possible to add, or start monitoring, a new instance without setting theMySQL Enterprise Monitorpermission to Administer.
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 theSQL Statement Generates Warnings or ErrorsandAverage Statement Execution Timeadvisors.
Read-Only:聚合数据呈现给用户,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 theQuery Analysis Aggregate Datapermission. 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. IfQuery Analysis Aggregate Datais 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.
NoteThe 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.