Search Results
https://dev.mysql.com/doc/refman/9.7/en/mysqlslap.html
This option applies only if the server was started with the named_pipe system variable enabled to support named-pipe connections. This option applies only if the server was started with the shared_memory system variable enabled to support ...The ...
https://dev.mysql.com/doc/refman/9.7/en/charset-connection.html
Connection Character Set and Collation System Variables Impermissible Client Character Sets Client Program Connection Character Set Configuration SQL Statements for Connection Character Set Configuration Connection Character Set Error Handling ... A ...The client sends SQL statements, such as queries, over the session ...
https://dev.mysql.com/doc/refman/9.7/en/data-directory-initialization.html
If the init_file system variable was given to name a file of SQL statements, the server executes the statements in the file. Change location to the top-level directory of your MySQL installation, which is typically /usr/local/mysql (adjust the path ... After MySQL is installed, the data directory must be initialized, including the tables in the mysql system schema: For some MySQL installation methods, data directory initialization is automatic, as described in Section 2.9, “Postinstallation Setup and ...
https://dev.mysql.com/doc/mysql-shell/9.7/en/mysql-shell-utilities-load-dump.html
MySQL Shell's dump loading utility util.loadDump() supports the import into a MySQL HeatWave Service DB System or a MySQL Server instance of schemas or tables dumped using MySQL Shell's Section 12.5, “Instance Dump Utility, Schema Dump Utility, ...If the dump files are on your local system, you need to transfer them to the Oracle Cloud Infrastructure Compute instance using the copy utility of your choice, depending on the operating system you chose for your Compute ...The dump ...
https://dev.mysql.com/doc/refman/9.7/en/mysqlshow.html
This option applies only if the server was started with the named_pipe system variable enabled to support named-pipe connections. This option applies only if the server was started with the shared_memory system variable enabled to support ...The ...
https://dev.mysql.com/doc/refman/9.7/en/webauthn-pluggable-authentication.html
To be usable by the server, the plugin library file must be located in the MySQL plugin directory (the directory named by the plugin_dir system variable). The file must be located in the directory named by the plugin_dir system variable. Table 8.26 ...MySQL Enterprise Edition supports an authentication method that enables users to authenticate to MySQL Server using WebAuthn ...
https://dev.mysql.com/doc/refman/9.7/en/keyring-hashicorp-component.html
Configuration items supported in component_keyring_hashicorp.cnf are shown in the following table: Configuration Item Description Required Valid Values Default Corresponding System Variable auth_mode Whether to use AppRole or token-based ...No key ... Note The component_keyring_hashicorp component is an extension included in MySQL Enterprise Edition, a commercial ...
https://dev.mysql.com/doc/refman/9.7/en/replication-gtids-lifecycle.html
The gtid_next System Variable By default, for new transactions committed in user sessions, the server automatically generates and assigns a new GTID. You can change this behavior by setting the session value of the gtid_next system variable: When ...
https://dev.mysql.com/doc/mysql-shell/9.7/en/innodb-clusterset-requirements.html
For MySQL Server instances from version 8.0.27 to 8.2.0, for an InnoDB Cluster that is part of an InnoDB ClusterSet, the group_replication_view_change_uuid system variable must be set with the same value on all the member servers in the cluster to ...InnoDB Cluster created before MySQL 8.0.27 might not have the system variable set, but the InnoDB ClusterSet creation process checks for this and fails with a warning if it is ... The basis of an InnoDB ClusterSet deployment is an existing InnoDB ...
https://dev.mysql.com/doc/refman/9.7/en/clone-plugin-remote.html
To determine the MySQL server version, issue the following query: mysql> SHOW VARIABLES LIKE 'version'; +---------------+-------+ | Variable_name | Value | +---------------+-------+ | version | 9.7.0 | +---------------+-------+ The donor and ... The ...Use this option if you do not want to remove existing user-created data (schemas, tables, tablespaces) and binary logs from the recipient data ...