https://dev.mysql.com/faqs-innodb-change-buffer.html
What types of operations modify secondary indexes and result in change buffering? A.15.2. How much space does InnoDB use for the change buffer? A.15.5. How do I determine the current size of the change buffer? A.15.6. Where can I find additional ...
https://dev.mysql.com/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 ...
https://dev.mysql.com/check-table.html
CHECK TABLE functionality for InnoDB SPATIAL indexes includes an R-tree validity check and a check to ensure that the R-tree row count matches the clustered index. option: { FOR UPGRADE | QUICK | FAST | MEDIUM | EXTENDED | CHANGED } CHECK TABLE ...
https://dev.mysql.com/string-functions.html
mysql> SELECT LENGTH('text'); -> 4 Note The Length() OpenGIS spatial function is named ST_Length() in MySQL. For functions that operate on string positions, the first position is numbered 1. For functions that take length arguments, noninteger ...
https://dev.mysql.com/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 ...
https://dev.mysql.com/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 ...
https://dev.mysql.com/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 ...
https://dev.mysql.com/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 ...
https://dev.mysql.com/func-op-summary-ref.html
GTID_SUBTRACT() Return all GTIDs in set that are not in subset. JSON_CONTAINS() Whether JSON document contains specific object at path JSON_CONTAINS_PATH() Whether JSON document contains any data at path JSON_DEPTH() Maximum depth of JSON document ...
https://dev.mysql.com/gis-geometrycollection-property-functions.html
If any geometry argument has an SRID value that refers to an undefined spatial reference system (SRS), an ER_SRS_NOT_FOUND error occurs. Unless otherwise specified, functions in this section handle their arguments as follows: If any argument is NULL ...
