Search Results
https://dev.mysql.com/doc/x-devapi-userguide/en/error-handling.html
When writing scripts for MySQL Shell you can often simply rely on the exception handling done by MySQL Shell. The default error handling can be changed by creating a custom SessionContext and passing it to the mysqlx.getSession() function. For all ...
https://dev.mysql.com/doc/x-devapi-userguide/en/parameter-binding.html
MySQL Shell and Node.js JavaScript Code // Collection.find() function with fixed values var myColl = db.getCollection('my_collection'); var myRes1 = myColl.find('age = 18').execute(); // Using the .bind() function to bind parameters var myRes2 = ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/agenthealth-advisor-ref.html
The default values are: Notice = 70 Warning = 85 Critical = 90 Communication The Communication section defines the thresholds for latency and HTTP errors between agent and MySQL Enterprise Service Manager. Figure 21.2 Agent Health - General Agent ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/group-management.html
There are two types of group in MySQL Enterprise Monitor: user-defined and replication. User-defined groups are those created and managed in MySQL Enterprise Service Manager's Manage Groups page. Note You can also define groups and add instances to ...For example, you can create groups for development and production ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-advisors-wiki-format.html
Replication can be very useful for solving problems in the following areas: <ul> <li>Data distribution</li> <li>Load Balancing</li> <li>Backup and recovery</li> </ul>You can check replication status and start a slave with the following commands: ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-deployment-change-ssh-host-key.html
It is not required on any version of MySQL 5.6, or higher. On the monitored MySQL instance, edit the hostid value: mysql> UPDATE mysql.inventory SET VALUE = 'ssh:{New SSH Fingerprint}' WHERE name = 'hostId'; Restart the monitoring agent. The SSH ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-install-server.html
This chapter describes the installation of MySQL Enterprise Service Manager. MySQL Enterprise Service Manager installer installs the following components: Apache Tomcat: mandatory component. Servlet container and web server which hosts MySQL ...
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 ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-ui-named-filters-ref.html
Named filters are available on the following pages: MySQL Instances: contains the following system filters: All MySQL Instances: this is the default selection. MySQL Instances Monitored By Old Agents: only displays MySQL instances monitored by ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-users-created-first-login.html
The Manager user: This user is the administrator of MySQL Enterprise Service Manager. The Agent user: MySQL Enterprise Monitor Agent broadcasts the status of the assets it is monitoring and requires access to MySQL Enterprise Service Manager. Note ...These credentials must also be provided for the agent installation ...