Search Results
https://dev.mysql.com/doc/refman/8.4/en/gis-wkb-functions.html
By default, geographic coordinates (latitude, longitude) are interpreted as in the order specified by the spatial reference system of geometry arguments. An optional options argument may be given to override the default axis order. The only ...
https://dev.mysql.com/doc/refman/8.4/en/gis-wkt-functions.html
By default, geographic coordinates (latitude, longitude) are interpreted as in the order specified by the spatial reference system of geometry arguments. An optional options argument may be given to override the default axis order. The only ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-configuring-consistency-guarantees.html
The BEFORE consistency level, apart from being ordered on the transaction stream, only impacts on the local member. Although the Transaction Synchronization Points section explains that conceptually there are two synchronization points from which ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-distributed-recovery-connections.html
The joining member then attempts to connect to the donor using the donor's advertised distributed recovery endpoints, trying each in turn in the order they are specified in the list. Joining members try each of the endpoints in turn in the order ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-requirements.html
If there are conflicts, in order to maintain consistency across the group, some transactions are rolled back. For a multithreaded replica, the following is also required: replica_preserve_commit_order=ON This setting is required to ensure that the ... Infrastructure Server Instance Configuration Server instances that you want to use for Group Replication must satisfy the following ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-restarting-group.html
For each group member in turn, in any order: Connect a client to the group member. Group Replication is designed to ensure that the database service is continuously available, even if some of the servers that form the group are currently unable to ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-columns-table.html
ORDINAL_POSITION is necessary because you might want to say ORDER BY ORDINAL_POSITION. Unlike SHOW COLUMNS, SELECT from the COLUMNS table does not have automatic ordering. If more than one of the COLUMN_KEY values applies to a given column of a ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-index-types.html
The rows are ordered by the row ID that InnoDB assigns. Thus, the rows ordered by the row ID are physically in order of insertion. Each InnoDB table has a special index called the clustered index that stores row data. To get the best performance ...
https://dev.mysql.com/doc/refman/8.4/en/lateral-derived-tables.html
A derived table cannot normally refer to (depend on) columns of preceding tables in the same FROM clause. A derived table may be defined as a lateral derived table to specify that such references are permitted. Nonlateral derived tables are ...
https://dev.mysql.com/doc/refman/8.4/en/ldml-collation-example.html
The solution is to define a new collation that reorders punctuation characters, making them ignorable. Within the <collation> element, provide a <rules> element containing the ordering rules: <charset name="utf8mb4"> ... To add a UCA collation for ...