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/optimizing-spatial-analysis.html
For MyISAM and InnoDB tables, search operations in columns containing spatial data can be optimized using SPATIAL indexes. The most typical operations are: Point queries that search for all objects that contain a given point Region queries that ...
https://dev.mysql.com/doc/refman/8.0/en/precision-math-numbers.html
The scope of precision math for exact-value operations includes the exact-value data types (integer and DECIMAL types) and exact-value numeric literals. Approximate-value data types and numeric literals are handled as floating-point numbers.
https://dev.mysql.com/doc/refman/8.0/en/audit-log-logging-configuration.html
This section describes how to configure audit logging characteristics, such as the file to which the audit log plugin writes events, the format of written events, whether to enable log file compression and encryption, and space management. For ...
https://dev.mysql.com/doc/refman/8.0/en/faqs-stored-procs.html
Where can I find documentation for MySQL stored procedures and stored functions? A.4.3. Where can I find the ANSI SQL 2003 specification for stored procedures? A.4.5. Is there a way to view all stored procedures and stored functions in a given ...
https://dev.mysql.com/doc/refman/8.0/en/geometry-well-formedness-validity.html
For geometry values, MySQL distinguishes between the concepts of syntactically well-formed and geometrically valid. Spatial import functions that parse WKT or WKB values raise an error for attempts to create a geometry that is not syntactically ...
https://dev.mysql.com/doc/refman/8.0/en/gis-polygon-property-functions.html
Functions in this section return properties of Polygon or MultiPolygon values. Unless otherwise specified, functions in this section handle their geometry arguments as follows: If any argument is NULL or any geometry argument is an empty geometry, ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-view-changes.html
When Group Replication's distributed recovery process is carrying out state transfer from the binary log, to synchronize the joining member with the donor up to a specific point in time, the joining member and donor make use of GTIDs (see Section ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-migration.html
This section describes techniques for moving or copying some or all InnoDB tables to a different server or instance. For example, you might move an entire MySQL instance to a larger, faster server; you might clone an entire MySQL instance to a new ...
https://dev.mysql.com/doc/refman/8.0/en/string-functions.html
For functions that operate on string positions, the first position is numbered 1. For functions that take length arguments, noninteger arguments are rounded to the nearest integer. ASCII(str) Returns the numeric value of the leftmost character of ...
https://dev.mysql.com/doc/refman/8.0/en/window-function-optimization.html
Window functions affect the strategies the optimizer considers: Derived table merging for a subquery is disabled if the subquery has window functions. Semijoins are not applicable to window function optimization because semijoins apply to ...