MySQL :: MySQL 9.7 Reference Manual

Search Results

Displaying 71 to 80 of 85 total results

https://dev.mysql.com/doc/refman/9.7/en/innodb-page-compression.html

R-tree pages, which are used for spatial indexes, are not compressed. InnoDB supports page-level compression for tables that reside in file-per-table tablespaces. Page compression is enabled by specifying the COMPRESSION attribute with CREATE TABLE ...

Chapter 13 Data Types

https://dev.mysql.com/doc/refman/9.7/en/data-types.html

MySQL supports SQL data types in several categories: numeric types, date and time types, string (character and byte) types, spatial types, and the JSON data type. This chapter provides an overview and more detailed description of the properties of ...

14.19 Aggregate Functions

https://dev.mysql.com/doc/refman/9.7/en/aggregate-functions-and-modifiers.html

For information about aggregate functions that operate on geometry values, see Section 14.16.12, “Spatial Aggregate Functions”. They are often used with a GROUP BY clause to group values into subsets.

A.16 MySQL 9.7 FAQ: InnoDB Change Buffer

https://dev.mysql.com/doc/refman/9.7/en/faqs-innodb-change-buffer.html

What types of operations modify secondary indexes and result in change buffering? A.16.2. How much space does InnoDB use for the change buffer? A.16.5. How do I determine the current size of the change buffer? A.16.6. Where can I find additional ...

13.4.2 The OpenGIS Geometry Model

https://dev.mysql.com/doc/refman/9.7/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 ...

1.2.2 The Main Features of MySQL

https://dev.mysql.com/doc/refman/9.7/en/features.html

Data Types Many data types: signed/unsigned integers 1, 2, 3, 4, and 8 bytes long, FLOAT, DOUBLE, CHAR, VARCHAR, BINARY, VARBINARY, TEXT, BLOB, DATE, TIME, DATETIME, TIMESTAMP, YEAR, SET, ENUM, and OpenGIS spatial types. This section describes some ...

11.3 Keywords and Reserved Words

https://dev.mysql.com/doc/refman/9.7/en/keywords.html

Certain keywords, such as SELECT, DELETE, or BIGINT, are reserved and require special treatment for use as identifiers such as table and column names. This may also be true for the names of built-in functions. Some keywords which are otherwise ...

17.6.2.3 Sorted Index Builds

https://dev.mysql.com/doc/refman/9.7/en/sorted-index-builds.html

InnoDB performs a bulk load instead of inserting one index record at a time when creating or rebuilding indexes. This method of index creation is also known as a sorted index build. In the first phase, the clustered index is scanned, and index ...

17.16.1 Monitoring ALTER TABLE Progress for InnoDB Tables Using Performance Schema

https://dev.mysql.com/doc/refman/9.7/en/monitor-alter-table-performance-schema.html

Note InnoDB ALTER TABLE stage events do not currently account for the addition of spatial indexes. You can monitor ALTER TABLE progress for InnoDB tables using Performance Schema. There are seven stage events that represent different phases of ...

25.2.7.1 Noncompliance with SQL Syntax in NDB Cluster

https://dev.mysql.com/doc/refman/9.7/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 ...

Displaying 71 to 80 of 85 total results