Search Results
https://dev.mysql.com/doc/mysql-monitor/8.0/en/main-queries-reference.html
That is, you must use the following format, where NAME is the name applied to the data collection: SELECT X AS NAME FROM Y The items are displayed in the Data Item drop-down menu on the Variable Assignment frame of the new Advisor page. The main ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-acl-creating-user-roles-tasks.html
If this role applies to a specific group only, select Group-Specific Permission, and select the required group from the drop-down list. Creating a Role Note It is not possible to save a new user without an assigned role. To create a role, do the ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-advisor-intro-thresholds-ref.html
These are used to monitor such values as system uptime and, if the value for uptime drops below a certain value, indicating a restart, trigger an event. If the monitored value breaches the defined threshold, an event is generated and displayed on ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-creating-advisors-overview.html
Variable names are associated with elements in the Data Item drop-down menu. To create a new Advisor, click the Create Advisor button on the Advisors page. To create an Advisor based on an existing one, select Copy Advisor menu item from the ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-customdata-collection.html
After defining the custom data collection, it is available to select in the Data Item drop-down menu on the Variable Assignment frame of the new Advisor page. This section describes how to configure custom data collections for the monitoring agent.
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-event-handlers-page-ref.html
To display the Event Handlers page, select Event Handlers from the Configuration drop-down menu. The Event Handler page is grouped in the following sections: Event Handlers: Lists the event handlers defined on the system. The Default Auto Close ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-event-handling-suspend-event-handler.html
To stop an event handler, select Suspend Event Handler from the event handler's drop-down menu. A prompt is displayed enabling you to enter notes on why the event handler was suspended, and confirm the suspension. Note The rights to suspend event ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-graphs-database-fileio-lock-wait.html
Note This graph is displayed only if a MySQL instance is selected in the All Targets drop-down menu. This chapter describes the Database File I/O and Lock Waits reports. These reports identify I/O hot spots and lock wait contention in your ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-graphs-innodb-buffer-pool.html
Running the InnoDB Buffer Pool Usage Report To run the usage report, do the following: Navigate to the Reports & Graphs drop-down menu. The InnoDB Buffer Pool Usage Report displays the amount of space used in the InnoDB buffer pool and how the ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-localization.html
If this is the first time launching the MySQL Enterprise Monitor User Interface, you must set your time zone and locale. Setting the time zone ensures that you have an accurate time reference for any notifications from the MySQL Enterprise Advisors. Warning Set the time zone (and the system clock) correctly because this setting affects how MySQL Enterprise Service Manager's graphs display ...