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/mysql-cluster-replication-pitr.html
Point-in-time recovery—that is, recovery of data changes made since a given point in time—is performed after restoring a full backup that returns the server to its state when the backup was made. Performing point-in-time recovery of NDB Cluster ...This backup should be updated regularly—perhaps even hourly—depending on your ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-floatvalues.html
Because conversions between decimal and binary representations of them may be approximate, comparisons involving floating-point values are inexact. This is true for operations that use floating-point values explicitly, or that use values that are ...
https://dev.mysql.com/doc/refman/8.0/en/built-in-function-reference.html
The following table lists each built-in (native) function and operator and provides a short description of each one. For a table listing functions that are loadable at runtime, see Section 14.2, “Loadable Function Reference”. ->> Return value ...
https://dev.mysql.com/doc/refman/8.0/en/spatial-relation-functions-object-shapes.html
mysql> SET @g1 = ST_GeomFromText('Polygon((0 0,0 3,3 3,3 0,0 0))'), -> @p1 = ST_GeomFromText('Point(1 1)'), -> @p2 = ST_GeomFromText('Point(3 3)'), -> @p3 = ST_GeomFromText('Point(5 5)'); Query OK, 0 rows affected (0.00 sec) mysql> SELECT -> ... The ...
https://dev.mysql.com/doc/refman/8.0/en/spatial-function-reference.html
The following table lists each spatial function and provides a short description of each one.
https://dev.mysql.com/doc/refman/8.0/en/gis-data-formats.html
Examples of WKT representations of geometry objects: A Point: POINT(15 20) The point coordinates are specified with no separating comma. This differs from the syntax for the SQL Point() function, which requires a comma between the coordinates. For ... Two standard spatial data formats are used to represent geometry objects in queries: Well-Known Text (WKT) format Well-Known Binary (WKB) format Internally, MySQL stores geometry values in a format that is not identical to either WKT or WKB ...
https://dev.mysql.com/doc/refman/8.0/en/spatial-convenience-functions.html
These convenience functions are available: ST_Distance_Sphere(g1, g2 [, radius]) Returns the minimum spherical distance between Point or MultiPoint arguments on a sphere, in meters. If both geometry parameters are valid Cartesian Point or MultiPoint ... The functions in this section provide convenience operations on geometry ...
https://dev.mysql.com/doc/refman/8.0/en/spatial-relation-functions-mbr.html
The bounding box of a point is interpreted as a point that is both boundary and interior. MySQL provides several MySQL-specific functions that test the relationship between minimum bounding rectangles (MBRs) of two geometries g1 and g2. The return ...
https://dev.mysql.com/doc/refman/8.0/en/glossary.html
adaptive flushing An algorithm for InnoDB tables that smooths out the I/O overhead introduced by checkpoints. See Also buffer pool, checkpoint, data files, flush, InnoDB, page, redo log. InnoDB does not use the beta designation, preferring an early ... These terms are commonly used in information about the MySQL database ...
https://dev.mysql.com/doc/refman/8.0/en/mysqlbinlog.html
For other usage examples, see the discussion later in this section and in Section 9.5, “Point-in-Time (Incremental) Recovery”. For example: mysqlbinlog --start-datetime="2005-12-25 11:25:56" binlog.000003 This option is useful for point-in-time ... The server's binary log consists of files containing “events” that describe modifications to database ...