Search Results
https://dev.mysql.com/doc/refman/9.7/en/adding-collation.html
The MySQL 9.7 server issues a warning for any use of COLLATE user_defined_collation in an SQL statement; a warning is also issued when the server is started with --collation-server set equal to the name of a user-defined collation. Warning ...
https://dev.mysql.com/doc/refman/9.7/en/alter-table-partition-operations.html
ALGORITHM=1 causes the server to use the same key-hashing functions as MySQL 5.1 when computing the placement of rows in partitions; ALGORITHM=2 means that the server employs the key-hashing functions implemented and used by default for new KEY ...
https://dev.mysql.com/doc/refman/9.7/en/downgrading.html
A replication topology is downgraded by following the rolling downgrade scheme described at Section 19.5.3, “Upgrading or Downgrading a Replication Topology”, which uses one of the supported single-server methods for each individual server ...
https://dev.mysql.com/doc/refman/9.7/en/group-replication-deploying-instances.html
The first step is to deploy at least three instances of MySQL Server, this procedure demonstrates using multiple hosts for the instances, named s1, s2, and s3. It is assumed that MySQL Server is installed on each host (see Chapter 2, Installing ...
https://dev.mysql.com/doc/refman/9.7/en/group-replication-upgrade.html
Note Before MySQL 8.4, a server would not join a group if it was running a lower MySQL Server version than the lowest group member's version. For example, an 8.4.0 server could join a group consisting of S1 (8.4.1) and S2 (8.4.2), and a 9.7.0 server ... This section explains how to upgrade a Group Replication ...
https://dev.mysql.com/doc/refman/9.7/en/information-schema-engines-table.html
SUPPORT The server's level of support for the storage engine, as shown in the following table. A value of DISABLED occurs either because the server was started with an option that disables the engine, or because not all options required to enable it ...This is particularly useful for checking whether a storage engine is supported, or to see what the default engine ...
https://dev.mysql.com/doc/refman/9.7/en/information-schema-ndb-transid-mysql-connection-map-table.html
The ndb_transid_mysql_connection_map table provides a mapping between NDB transactions, NDB transaction coordinators, and MySQL Servers attached to an NDB Cluster as API nodes. This information is used when populating the server_operations and ...
https://dev.mysql.com/doc/refman/9.7/en/myisampack.html
When the table is used later, the server reads into memory the information needed to decompress columns. Please note the following: If the mysqld server was invoked with external locking disabled, it is not a good idea to invoke myisampack if the ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-oci-marketplace-connecting.html
This section describes the various connection methods for connecting to the deployed MySQL server on the OCI Compute Instance. To find the temporary root password created for the root user, run the following command: sudo grep 'temporary password' ...Connecting with SSH This section gives some detail on connecting from a UNIX-like platform to the OCI ...
https://dev.mysql.com/doc/refman/9.7/en/replication-features-triggers.html
If you upgrade servers in a replication topology that use a version earlier than MySQL 5.7, upgrade the replicas first and then upgrade the source. If an upgraded replication source server still has old replicas using MySQL versions that do not ...