Search Results
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-created-users.html
The Repository user: This user is the only user in the user table in the mysql database in the bundled MySQL server. The repository user can log in from localhost using the password specified during installation and has all privileges on all ...To ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-deployment-backup.html
The following is an example of how to use mysqldump to export all databases in the repository instance to a dump file named mem.dump: Note This example assumes you are using the MySQL instance solely as the repository for MySQL Enterprise Service ...To restore the dump file, run the following mysql command on a clean instance: $> mysql -u <user> -p -P13306 -h127.0.0.1 < mem.dump You should also backup the following files: apache-tomcat/conf/Keystore apache-tomcat/conf/server.xml java/lib/security/cacerts apache-tomcat/webapps/ROOT/WEB-INF/config.properties apache-tomcat/webapps/ROOT/WEB-INF/configArea/mem.keystore You can also use MySQL Enterprise Backup to manage your repository backup ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-introduction-server.html
Query Analyzer The Query Analyzer enables you to monitor all SQL statements executed on the monitored MySQL databases. MySQL Enterprise Service Manager is the central hub of the MySQL Enterprise Monitor installation and is responsible for the ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-post-install-general.html
I/O and Lock Contention: If you are using MySQL 5.6 or later consider deploying the sys schema, and making use of the Database File I/O and Lock Waits reports from the Reports & Graphs menu. See Section 30.2, “Database File I/O and Lock Waits” ... This section describes some of the general tasks which may be required after installation or ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-ui-settings-customize-name-ref.html
For example: dx521\.example\.com=Staging dx984[.]example[.]com=Production database-server-(.*?)\.example\.com=$1 ^database-server-="", [.]example[.]com$="",dx521="Staging DB" More complex substitutions are possible by using a regular expression.
https://dev.mysql.com/doc/mysql-secure-deployment-guide/8.0/en/secure-deployment-install.html
This section covers installation prerequisites, creating the mysql user and group, and unpacking the distribution. Installation Prerequisites Creating the mysql User and Group Unpacking the Distribution Installation Prerequisites The installation ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-js/en/collection-find.html
The find(SearchConditionStr) function is for searching documents in a collection, similar to the SELECT statement for an SQL database. It takes a search condition string (SearchConditionStr) as a parameter to specify the documents that should be ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-js/en/crud-operations-overview.html
Operation Document Relational Create Section 4.3.1, “Collection.add()” Table.insert() Read Section 4.3.2, “Collection.find()” Table.select() Update Section 4.3.3, “Collection.modify()” Table.update() Delete Section 4.3.4, ... CRUD ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-js/en/shell-automatic-code-execution-results.html
For example: var result = mySession.sql('show databases').execute() var result2 = myColl.find().execute() The call of the execute() function above causes the operation to be executed and returns a Result object. mysql-js> mySession.sql('show ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/collection-find.html
The find(SearchConditionStr) function is for searching documents in a collection, similar to the SELECT statement for an SQL database. It takes a search condition string (SearchConditionStr) as a parameter to specify the documents that should be ...