Search Results
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-query-analyzer-ref.html
If the query is normalized and needs to be de-normalized, then you can edit it in the Query Text box. The Query Analyzer provides a point-in-time snapshot of queries on the monitored database, enabling you to monitor SQL statements executed on a ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/glossary.html
EXPLAIN plan A textual report showing the internal mechanisms used by a query, and estimates for the “cost”, such as amount of data to process, involved in each step. normalized query A condensed form of the query text used to treat similar ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-advisor-scripting-blackouts.html
You can run the commands from the command line or add to a text file and save it as *.sh or *.bat depending on your platform. It is also possible to manage blackouts from the command line, or a script. Note On Unix systems, use the chmod +x ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-events.html
Document the resolution using the Notes text area and choose the Close Events button. Advisors generate events if one, or more, of the defined thresholds are crossed by the monitored value. The notification group or groups associated with a ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-grahs-timeseries-controls.html
Table 30.1 Timeseries Graph Filter Name Description Graph Name Opens a drop-down menu listing the available search types: Contains Doesn't Contain Regex Negative Regex Value Free text field for the search term or regular expression. This section ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-query-analyzer-queries.html
Note If you change the context, by selecting another MySQL instance from the All Targets menu, and the selected instance does not contain the statement digest of the originally selected query, an error is displayed. Clicking on a circle or square ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-unattended-execution.html
The basic process for performing an unattended installation is the same for both MySQL Enterprise Monitor Agent and MySQL Enterprise Service Manager installers, with the only difference being the options supported by each installer. For information ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-unattended-installation.html
For convenient scripting, you can save these options in a text file and run the installer using the optionfile option. This section explains how to automate the install and upgrade procedures for MySQL Enterprise Service Manager and MySQL ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/performance-advisors-ref.html
Also, tables that have TEXT or BLOB columns are automatically placed on disk. Stalled statements generate a lot of extra overhead since they involve extra context switches and in some cases even extra thread creations. For optimal performance, ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/replication-advisor-ref.html
You can determine whether full or minimal rows are logged by setting the binlog_row_image server system variable to one of minimal (log required columns only), full (log all columns), or noblob (log all columns except for unneeded BLOB or TEXT ...By ...