Search Results
https://dev.mysql.com/doc/mysql-shell/9.4/en/mysql-shell-sessions-after.html
If you started MySQL Shell without connecting to a MySQL Server instance, you can use MySQL Shell's \connect command or the shell.connect() method to initiate a connection and create the session global object. For example: mysql-js> \connect ...
https://dev.mysql.com/doc/refman/8.4/en/sys-create-synonym-db.html
Given a schema name, this procedure creates a synonym schema containing views that refer to all the tables and views in the original schema. This can be used, for example, to create a shorter name by which to refer to a schema with a long name ...
https://dev.mysql.com/doc/refman/8.4/en/replication-howto-repuser.html
You can choose to create a different account for each replica, or connect to the source using the same account for each replica. Although you do not have to create an account specifically for replication, you should be aware that the replication ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-creating-advisors-overview.html
To create a new Advisor, click the Create Advisor button on the Advisors page. To create an Advisor based on an existing one, select Copy Advisor menu item from the Advisor menu. For a complete list of the built-in variables used to create ...You ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/mysql-shell-sessions-startup.html
When you use this connection method, you can add one of these options to choose the type of session object to create at startup to be the session global object: --mysqlx (--mx) creates a Session object, which connects to the MySQL Server instance ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-shell-tutorial-javascript-collections-operations.html
In MySQL Shell, you can create new collections, get a list of the existing collections in a schema, and remove an existing collection from a schema. The following example creates a collection called flags in the world_x schema. For example, to drop ...Collection names are case-sensitive and each collection name must be ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-shell-tutorial-python-collections-operations.html
In MySQL Shell, you can create new collections, get a list of the existing collections in a schema, and remove an existing collection from a schema. The following example creates a collection called flags in the world_x schema. For example, to drop ...Collection names are case-sensitive and each collection name must be ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-shell-tutorial-python-documents-index.html
If a collection is large and queries on a specific field are common, then consider creating an index on a specific field inside a document. For example, the following query performs better with an index on the Population field: mysql-py> ... Indexes ...
https://dev.mysql.com/doc/refman/8.4/en/error-creating-innodb.html
Initialization Problems If something goes wrong when InnoDB attempts to initialize its tablespace or its log files, delete all files created by InnoDB: all ibdata files and all redo log files (#ib_redoN files). If you created any InnoDB tables, also ...Make sure mysqld has access rights to create files in those ... The troubleshooting steps for InnoDB I/O problems depend on when the problem occurs: during startup of the MySQL server, or during normal operations when a ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-backup-using-management-client.html
START BACKUP supports the creation of encrypted backups using ENCRYPT PASSWORD=password. Cluster backups are created by default in the BACKUP subdirectory of the DataDir on each data node. The backup files created for a backup with a given backup_id ... Before starting a backup, make sure that the cluster is properly configured for performing ...