Search Results
https://dev.mysql.com/doc/x-devapi-userguide/en/dynamic-sql.html
A quoting function exists to escape SQL names and identifiers. Session.quoteName() escapes the identifier given in accordance to the settings of the current connection. Note The quoting function must not be used to escape values. Use the value ...
https://dev.mysql.com/doc/x-devapi-userguide/en/setting-the-current-schema.html
*/ C# Code // Direct connect with no client-side default schema specified var mySession = MySQLX.GetSession("server=localhost;port=33060;user=user;password=password;"); mySession.SetCurrentSchema("test"); Python Code # Connector/Python from mysqlsh ... A default schema for a session can be specified using the schema attribute in the URI-like connection string or key-value pairs when opening a connection ...
https://dev.mysql.com/doc/x-devapi-userguide/en/working-with-collections-basic-crud.html
Working with collections of documents is straightforward when using X DevAPI. The following example shows the basic usage of CRUD operations (see Section 4.3, “Collection CRUD Function Overview” for more details) when working with documents: ...
https://dev.mysql.com/doc/relnotes/mysql-monitor/8.0/en/news-8-0-16.html
Bugs Fixed Important Change: It was not possible to validate the MONITOR.MIB file, it was not standards compliant. Important If you have configured a 3rd-party trap receiver to use the MONITOR.MIB, you must upgrade the configured MONITOR.MIB to use ...Functionality Added or Changed Bugs Fixed Functionality Added or Changed The OpenSSL libraries used by MySQL Enterprise Monitor installers have been upgraded to ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/admin-advisors-reference.html
However, the number of log files and the space they use can grow rapidly, especially on a busy server, so it is important to remove these files on a regular basis when they are no longer needed, as long as appropriate backups have been made. This is ...However, for performance reasons, it is recommended to run 64-bit binaries on 64-bit platforms, and 32-bit binaries on 32-bit ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/group-management.html
Creating Groups Important To create groups, the user must be assigned to a role with the New Group Creation permission set to Administer. For example, you can create groups for development and production instances. Instances added to each group ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-acl-monitoring-mem-permissions.html
Important Overriding an Advisor at the top-level, not on an individual asset, overrides that Advisor globally, for all users, regardless of their roles. Important Settings this permission to Administer does not grant access to the External ... The ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-advanced-inventory-using.html
Important If a current asset, that is one which is actively monitored, is deleted, MySQL Enterprise Monitor rediscovers it as part of the monitoring process. Important To delete a host which is currently monitored, you must first, in the MySQL ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-advisors-intro-advisor-page-ref.html
Important If a host, Host1 for example, exists in multiple groups and a configuration override is applied to one of those groups, it does not affect Host1. To display the Advisors page, select Advisors from the Configuration menu. Figure 19.1 Manage ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-agent-rights.html
Important If you are monitoring MySQL 5.1.63, or earlier, you must grant the SUPER privilege to the General user. Important If running MySQL 5.6, or later, it is not necessary to grant select on mysql.inventory because the master_uuid is used from ... MySQL Enterprise Monitor Agent requires a user configured within each MySQL instance that is being monitored with suitable privileges to collect information about the server, including variable names, replication, and storage engine status ...