https://dev.mysql.com/analyze-table.html
Histogram generation applies to columns of all data types except geometry types (spatial data) and JSON. ANALYZE [NO_WRITE_TO_BINLOG | LOCAL] TABLE tbl_name UPDATE HISTOGRAM ON col_name [, col_name] ... [WITH N BUCKETS] ANALYZE [NO_WRITE_TO_BINLOG | ...
https://dev.mysql.com/data-types.html
MySQL supports a number of 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 of these data types, a more detailed ...
https://dev.mysql.com/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. Reserved words are permitted as ...
https://dev.mysql.com/c-api-data-structures.html
This section describes C API data structures other than those used for prepared statements, the asychronous interface, or the replication stream interface. For information about those, see Section 28.7.9, “C API Prepared Statement Data ...
https://dev.mysql.com/innodb-indexes-table.html
0 = nonunique secondary index; 1 = automatically generated clustered index (GEN_CLUST_INDEX); 2 = unique nonclustered index; 3 = clustered index; 32 = full-text index; 64 = spatial index; 128 = secondary index on a virtual generated column. For ...
https://dev.mysql.com/user-variables.html
For example, a value having a temporal or spatial data type is converted to a binary string. You can store a value in a user-defined variable in one statement and refer to it later in another statement. This enables you to pass values from one ...
https://dev.mysql.com/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 ...
https://dev.mysql.com/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 ...
https://dev.mysql.com/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 ...
https://dev.mysql.com/mysqlpump.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. mysqlpump Invocation Syntax mysqlpump Option Summary mysqlpump Option Descriptions ...
