Search Results
https://dev.mysql.com/doc/refman/8.4/en/floating-point-types.html
MySQL uses four bytes for single-precision values and eight bytes for double-precision values. MySQL also supports this optional precision specification, but the precision value in FLOAT(p) is used only to determine storage size. MySQL permits a ...
https://dev.mysql.com/doc/refman/8.4/en/gis-wkt-functions.html
For example, both of the following function calls are valid: ST_MPointFromText('MULTIPOINT (1 1, 2 2, 3 3)') ST_MPointFromText('MULTIPOINT ((1 1), (2 2), (3 3))') Functions such as ST_GeomFromText() that accept WKT geometry collection arguments ...
https://dev.mysql.com/doc/refman/8.4/en/group-by-functional-dependence.html
The following discussion provides several examples of the ways in which MySQL detects functional dependencies. The examples use the world database, which can be downloaded from https://dev.mysql.com/doc/index-other.html. The examples use this ...
https://dev.mysql.com/doc/refman/8.4/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/8.4/en/group-replication-distributed-recovery-connections.html
Important Distributed recovery can fail if a joining member cannot correctly identify the other members using the host name as defined by MySQL Server's hostname system variable. It is recommended that operating systems running MySQL have a properly ... When a joining member connects to an online existing member for state transfer during distributed recovery, the joining member acts as a client on the connection and the existing member acts as a ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-online-upgrade-methods.html
The primary cannot remain as the primary unless it is running the lowest MySQL Server version in the group. The group elects a new primary whenever necessary from among the members running the lowest MySQL Server version, following the election ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-requirements.html
MySQL Group Replication is designed to be deployed in a cluster environment where server instances are very close to each other. (In MySQL 8.4, this is the default.) Group members need to log transactions that are received from their donors at ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-upgrade.html
The basic process of upgrading members of a group is the same as upgrading stand-alone instances, see Chapter 3, Upgrading MySQL for the actual process of doing upgrade and types available. Note Before MySQL 8.4, a server would not join a group if ... This section explains how to upgrade a Group Replication ...
https://dev.mysql.com/doc/refman/8.4/en/index-btree-hash.html
LIKE '%string%' and string is longer than three characters, MySQL uses the Turbo Boyer-Moore algorithm to initialize the pattern for the string and then uses this pattern to perform the search more quickly. WHERE index_part1=1 OR index_part2=10 ...
https://dev.mysql.com/doc/refman/8.4/en/index-condition-pushdown-optimization.html
Index Condition Pushdown (ICP) is an optimization for the case where MySQL retrieves rows from a table using an index. Without ICP, the storage engine traverses the index to locate rows in the base table and returns them to the MySQL server which ...The storage engine then evaluates the pushed index condition by using the index entry and only if this is satisfied is the row read from the ...