PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/derived-table-optimization.html
The optimizer propagates an ORDER BY clause in a derived table or view reference to the outer query block if these conditions are all true: The outer query is not grouped or aggregated. The outer query does not specify DISTINCT, HAVING, or ORDER BY.
https://dev.mysql.com/doc/refman/8.0/en/encrypted-connection-protocols-ciphers.html
Negotiation order is independent of the order in which protocols are configured. For example, negotiation order is the same regardless of whether tls_version has a value of TLSv1,TLSv1.1,TLSv1.2,TLSv1.3 or TLSv1.3,TLSv1.2,TLSv1.1,TLSv1. MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/fulltext-search.html
SELECT 1 FROM t GROUP BY a WITH ROLLUP HAVING MATCH (a) AGAINST ('abc'); # ...and in ORDER BY clause SELECT 1 FROM t GROUP BY a WITH ROLLUP ORDER BY MATCH (a) AGAINST ('abc'); The use of MATCH() with a rollup column in the WHERE clause is permitted.
https://dev.mysql.com/doc/refman/8.0/en/general-thread-states.html
Copying to group table If a statement has different ORDER BY and GROUP BY criteria, the rows are sorted by group and copied to a temporary table. Sorting for order The thread is doing a sort to satisfy an ORDER BY. The following list describes ...
https://dev.mysql.com/doc/refman/8.0/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.0/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.0/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.0/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.0/en/group-replication-requirements.html
If there are conflicts, in order to maintain consistency across the group, some transactions are rolled back. Note When replica_preserve_commit_order is ON, setting binlog_transaction_dependency_tracking to WRITESET has the same effect as setting it ... 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.0/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 ...