PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.6Kb
Man Pages (Zip)
- 402.0Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html
For a description of the Debug Sync facility and how to use synchronization points, see MySQL Server Doxygen Documentation. When Block Nested-Loop is used, a larger join buffer can be beneficial up to the point where all required columns from all ...
https://dev.mysql.com/doc/refman/8.0/en/ldml-rules.html
Character Representation Characters named in LDML rules can be written literally or in \unnnn format, where nnnn is the hexadecimal Unicode code point value. Orderings are given as a set of rules that begin with a reset rule that establishes an ...
https://dev.mysql.com/doc/refman/8.0/en/spatial-geohash-functions.html
If any point argument does not have SRID 0 or 4326, an ER_SRS_NOT_FOUND error occurs. These geohash functions are available: ST_GeoHash(longitude, latitude, max_length), ST_GeoHash(point, max_length) Returns a geohash string in the connection ...
https://dev.mysql.com/doc/refman/8.0/en/spatial-geojson-functions.html
mysql> SELECT ST_AsGeoJSON(ST_GeomFromText('POINT(11.11111 12.22222)'),2); +-------------------------------------------------------------+ | ST_AsGeoJSON(ST_GeomFromText('POINT(11.11111 12.22222)'),2) | ... This section describes functions for ...
https://dev.mysql.com/doc/refman/8.0/en/backup-types.html
These provide logical copies of the file system at a given point in time, without requiring a physical copy of the entire file system. Full Versus Incremental Backups A full backup includes all data managed by a MySQL server at a given point in time. An incremental backup consists of the changes made to the data during a given time span (from one point in time to ...
https://dev.mysql.com/doc/refman/8.0/en/binary-log.html
These events bring databases up to date from the point of the backup. For more information about the binary log and recovery operations, see Section 9.5, “Point-in-Time (Incremental) Recovery”. At that point, mysqld writes the entire transaction ... The binary log contains “events” that describe database changes such as table creation operations or changes to table ...
https://dev.mysql.com/doc/refman/8.0/en/gis-wkb-functions.html
To migrate calls from using geometry arguments to using WKB arguments, follow these guidelines: Rewrite constructs such as ST_GeomFromWKB(Point(0, 0)) as Point(0, 0). Rewrite constructs such as ST_GeomFromWKB(Point(0, 0), 4326) as ST_SRID(Point(0, ... These functions take as arguments a BLOB containing a Well-Known Binary (WKB) representation and, optionally, a spatial reference system identifier ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-understanding-consistency-guarantees.html
Transaction Synchronization Points You configure a group's consistency guarantee based on the point at which you want to synchronize transactions across the group. To help you understand the concept, this section simplifies the points of ... In ...
https://dev.mysql.com/doc/refman/8.0/en/number-literals.html
Number literals include exact-value (integer and DECIMAL) literals and approximate-value (floating-point) literals. For example, 2.34 is an exact-value (fixed-point) number, whereas 2.34E0 is an approximate-value (floating-point) number. The ...
https://dev.mysql.com/doc/refman/8.0/en/populating-spatial-columns.html
For example: Inserting a POINT(1 1) value with hex literal syntax: INSERT INTO geom VALUES (ST_GeomFromWKB(X'0101000000000000000000F03F000000000000F03F')); An ODBC application can send a WKB representation, binding it to a placeholder using an ...