MySQL :: MySQL 8.0 Reference Manual

Search Results

Displaying 81 to 86 of 86 total results

« Previous
7
8
9
Next »

25.2.7.1 Noncompliance with SQL Syntax in NDB Cluster

https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-limitations-syntax.html

Some SQL statements relating to certain MySQL features produce errors when used with NDB tables, as described in the following list: Temporary tables. Trying either to create a temporary table that uses the NDB storage engine or to alter an ...

10.3.1 How MySQL Uses Indexes

https://dev.mysql.com/doc/refman/8.0/en/mysql-indexes.html

Exceptions: Indexes on spatial data types use R-trees; MEMORY tables also support hash indexes; InnoDB uses inverted lists for FULLTEXT indexes. Indexes are used to find rows with specific column values quickly. Without an index, MySQL must begin ...

10.9.6 Optimizer Statistics

https://dev.mysql.com/doc/refman/8.0/en/optimizer-statistics.html

The column_statistics table has these characteristics: The table contains statistics for columns of all data types except geometry types (spatial data) and JSON. The column_statistics data dictionary table stores histogram statistics about column ...

15.7.3.4 OPTIMIZE TABLE Statement

https://dev.mysql.com/doc/refman/8.0/en/optimize-table.html

OPTIMIZE TABLE does not sort R-tree indexes, such as spatial indexes on POINT columns. OPTIMIZE TABLE reorganizes the physical storage of table data and associated index data, to reduce storage space and improve I/O efficiency when accessing the ...

13.4.2 The OpenGIS Geometry Model

https://dev.mysql.com/doc/refman/8.0/en/opengis-geometry-model.html

In this model, each geometric object has the following general properties: It is associated with a spatial reference system, which describes the coordinate space in which the object is defined. The set of geometry types proposed by OGC's SQL with ...

6.5.4 mysqldump — A Database Backup Program

https://dev.mysql.com/doc/refman/8.0/en/mysqldump.html

The affected data types are BINARY, VARBINARY, BLOB types, BIT, all spatial data types, and other non-binary data types when used with the binary character set. The mysqldump client utility performs logical backups, producing a set of SQL ...