PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/create-index.html
When the innodb_stats_persistent setting is enabled, run the ANALYZE TABLE statement for an InnoDB table after creating an index on that table. Take this into account when specifying a prefix length for a nonbinary string column that uses a ...This ... CREATE [UNIQUE | FULLTEXT | SPATIAL] INDEX index_name [index_type] ON tbl_name (key_part,...) [index_option] [algorithm_option | lock_option] ...
https://dev.mysql.com/doc/refman/5.7/en/data-masking-usage.html
A similar technique may be needed for other data masking functions when string arguments do not have a single-byte character set. Before using MySQL Enterprise Data Masking and De-Identification, install it according to the instructions provided at ...This section demonstrates how to use the functions to carry out some representative ...
https://dev.mysql.com/doc/refman/5.7/en/example-auto-increment.html
For example: INSERT INTO animals (id,name) VALUES(NULL,'squirrel'); When you insert any other value into an AUTO_INCREMENT column, the column is set to that value and the sequence is reset so that the next automatically generated value follows ...
https://dev.mysql.com/doc/refman/5.7/en/gis-data-formats.html
Two standard spatial data formats are used to represent geometry objects in queries: Well-Known Text (WKT) format Well-Known Binary (WKB) format Internally, MySQL stores geometry values in a format that is not identical to either WKT or WKB format.
https://dev.mysql.com/doc/refman/5.7/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. This would be the case, for example, were custid a primary key of ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-fulltext-index.html
To support proximity search, position information for each word is also stored, as a byte offset. Unlike the inverted index tables, which are created for each full-text index, this set of tables is common to all full-text indexes created on a ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-physical-structure.html
An innodb_fill_factor setting of 100 leaves 1/16 of the space in clustered index pages free for future index growth. Spatial indexes use R-trees, which are specialized data structures for indexing multi-dimensional data. The page size is determined ... With the exception of spatial indexes, InnoDB indexes are B-tree data ...
https://dev.mysql.com/doc/refman/5.7/en/multiple-windows-services.html
Based on the preceding information, you have several ways to set up multiple services. The procedures for installing, controlling, and removing a single MySQL service are described in Section 2.3.4.8, “Starting MySQL as a Windows Service”. To ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-added-deprecated-removed-7-5.html
ndb-cluster-connection-pool-nodeids: Comma-separated list of node IDs for connections to cluster used by MySQL; number of nodes in list must match value set for --ndb-cluster-connection-pool. ndb_default_column_format: Sets default row format and ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-connection-strings.html
(See the documentation for the respective executable.) It is also possible to set the connection string for all nodes in the cluster at once by placing it in a [mysql_cluster] section in the management server's my.cnf file. For backward ...This ...