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/explain-extended.html
For results consisting of multiple values, a temporary table may be created and <temporary table> is shown instead. <temporary table> This represents an internal temporary table created to cache an intermediate result. The EXPLAIN statement ...
https://dev.mysql.com/doc/refman/8.0/en/faqs-storage-engines.html
An attempt to create partitioned tables in MySQL 8.0 using any other storage engine fails. The disabled_storage_engines configuration option defines which storage engines cannot be used to create tables or tablespaces. Where can I obtain complete ...
https://dev.mysql.com/doc/refman/8.0/en/federated-description.html
When you create a table using one of the standard storage engines (such as MyISAM, CSV or InnoDB), the table consists of the table definition and the associated data. When you create a FEDERATED table, the table definition is the same, but the ...A ...
https://dev.mysql.com/doc/refman/8.0/en/full-disk.html
Exceptions to the preceding behavior are when you use REPAIR TABLE or OPTIMIZE TABLE or when the indexes are created in a batch after LOAD DATA or after an ALTER TABLE statement. All of these statements may create large temporary files that, if left ... This section describes how MySQL responds to disk-full errors (such as “no space left on device”), and to quota-exceeded errors (such as “write failed” or “user block limit ...
https://dev.mysql.com/doc/refman/8.0/en/fulltext-fine-tuning.html
Note Minimum and maximum word length full-text parameters do not apply to FULLTEXT indexes created using the ngram parser. To rebuild FULLTEXT indexes for an InnoDB table, use ALTER TABLE with the DROP INDEX and ADD INDEX options to drop and ...You ...
https://dev.mysql.com/doc/refman/8.0/en/gis-class-geometry.html
It is a noninstantiable class but has a number of properties, described in the following list, that are common to all geometry values created from any of the Geometry subclasses. To ensure SRID 0 behavior, create geometry values using SRID 0.
https://dev.mysql.com/doc/refman/8.0/en/gis-format-conversion-functions.html
See Section 14.16.3, “Functions That Create Geometry Values from WKT Values”, and Section 14.16.4, “Functions That Create Geometry Values from WKB Values”. MySQL supports the functions listed in this section for converting geometry values ...
https://dev.mysql.com/doc/refman/8.0/en/gis-geometry-class-hierarchy.html
The geometry classes define a hierarchy as follows: Geometry (noninstantiable) Point (instantiable) Curve (noninstantiable) LineString (instantiable) Line LinearRing Surface (noninstantiable) Polygon (instantiable) GeometryCollection (instantiable) ...All classes have properties, and instantiable classes may also have assertions (rules that define valid class ...
https://dev.mysql.com/doc/refman/8.0/en/group-by-handling.html
SQL-92 and earlier does not permit queries for which the select list, HAVING condition, or ORDER BY list refer to nonaggregated columns that are not named in the GROUP BY clause. SQL:1999 and later permits such nonaggregates per optional feature ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-deploying-in-single-primary-mode.html
This section explains how to create a replication group with three MySQL Server instances, each running on a different host machine. Figure 20.7 Group Architecture This tutorial explains how to get and deploy MySQL Server with the Group Replication ... Each of the MySQL server instances in a group can run on an independent physical host machine, which is the recommended way to deploy Group ...