Search Results
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-advisors-thresholds.html
For example, the expression for the performance advisor, “Thread Cache Size May Not Be Optimal”, is: 100-((%Threads_created% / %Connections%) * 100) < THRESHOLD The THRESHOLD is set at 95% for an Info level alert, 85% for a Warning alert, and ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-comparison.html
This information includes JVM configuration and status, details on all MySQL connections, processes, and instances, and detailed information on the host's operating system. This section provides a high-level overview of the differences between this ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-deployment-change-ssh-host-key.html
This operation requires you to add each of these hosts to your SSH keyring the next time you connect. The SSH Host key is used to distinguish monitored hosts, there should not be duplicate SSH keys. This section describes how to change the SSH host ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-event-handling-email-settings.html
Disable JavaMail TLS/SSL Select if the SMTP server does not require an encrypted connection. The Email Settings section enables you to define the email configuration, such as SMTP server, username and password to use for all outgoing emails. Figure ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-existing-users.html
The MySQL user: For Agents to report the status of a MySQL server, they connect to a MySQL user with privileges to read required data on that server: SHOW DATABASES, REPLICATION CLIENT, SUPER, CREATE, and SELECT. If you already have such a user on ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-install-agent-multiple.html
Make sure that the MySQL instance that you want to monitor has a suitable user to use for connecting to the host. You can monitor multiple MySQL servers (either on the same machine, or remotely across different machines) using a single Agent. For ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-install-agent-remote.html
This is especially true for remote monitoring, where a loss of connection means loss of monitoring data, whereas an Agent installed on the same server as the MySQL instance continues monitoring and transmits the backlog of data to the MySQL ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-mysql-instance-instance-details.html
The monitored instance section (untitled) lists all the instances currently monitored by this installation and enables you to delete and edit instance configuration. When editing an individual instance, the Instance Details tab enables you to edit ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-qanal-config-ui.html
from db_name.table_name) or if you issued a USE statement to switch databases after connecting. The Configuration View enables you to customize the data displayed on the Query Analyzer view. Figure 32.7 Configuration View Graph View Selector ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-ssh-tunnel.html
Use localhost for the host name, since the agent is connecting through an SSH tunnel. If you run an SSH server on the machine that hosts the MySQL Enterprise Service Manager and an SSH client on the machine that hosts the agent, you can create an ...