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/generated-column-index-optimizations.html
For example: CREATE TABLE t1 (f1 INT, gc INT AS (f1 + 1) STORED, INDEX (gc)); The generated column, gc, is defined as the expression f1 + 1. The column is also indexed and the optimizer can take that index into account during execution plan ...
https://dev.mysql.com/doc/refman/8.0/en/gis-class-linestring.html
A LineString is a LinearRing if it is both closed and simple. A LineString is a Curve with linear interpolation between points. LineString Examples On a world map, LineString objects could represent rivers. LineString Properties A LineString has ...
https://dev.mysql.com/doc/refman/8.0/en/gis-class-multicurve.html
A MultiCurve is simple if and only if all of its elements are simple; the only intersections between any two elements occur at points that are on the boundaries of both elements. A MultiCurve is a geometry collection composed of Curve elements. A ...
https://dev.mysql.com/doc/refman/8.0/en/gis-class-polygon.html
Polygon Assertions The boundary of a Polygon consists of a set of LinearRing objects (that is, LineString objects that are both simple and closed) that make up its exterior and interior boundaries. A Polygon is a planar Surface representing a ...
https://dev.mysql.com/doc/refman/8.0/en/gis-format-conversion-functions.html
Functions such as ST_GeomFromText() that accept WKT geometry collection arguments understand both OpenGIS 'GEOMETRYCOLLECTION EMPTY' standard syntax and MySQL 'GEOMETRYCOLLECTION()' nonstandard syntax. MySQL supports the functions listed in this ...
https://dev.mysql.com/doc/refman/8.0/en/group-by-functional-dependence.html
The following discussion provides several examples of the ways in which MySQL detects functional dependencies. The examples use this notation: {X} -> {Y} Understand this as “X uniquely determines Y,” which also means that Y is functionally ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-cloning.html
Prior to MySQL 8.0.37, cloning required that donors and recipients used the same point release; this restriction still applies if the donor, recipient, or both use MySQL 8.0.36 or earlier. If you want to use remote cloning operations for distributed ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-communication-protocol.html
If two members attempt to join in the same membership change event, they can only join if the communication protocol version for both members is already compatible with the group's communication protocol version. From MySQL 8.0.16, Group ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-configuring-ssl-for-recovery.html
The group members involved in each distributed recovery connection as the client (joining member) and server (donor) negotiate the highest protocol version that they are both set up to support. Important When using the MySQL communication stack ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-frequently-asked-questions.html
However, if the network drops packets, leading to re-transmissions and higher end-to-end latency, throughput and latency are both negatively affected. What is the maximum number of MySQL servers in a group? A group can consist of maximum 9 servers.