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/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 ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndbinfo-config-values.html
The config_values table, implemented in NDB 7.5.0, provides information about the current state of node configuration parameter values. By joining the two tables on these columns, you can obtain detailed information about desired node configuration ...Each row in the table corresponds to the current value of a parameter on a given ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndbinfo-diskpagebuffer.html
If any of these values are less than 95%, this is a strong indicator that the setting for DiskPageBufferMemory needs to be increased in the config.ini file. Note A change in DiskPageBufferMemory requires a rolling restart of all of the cluster's ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndbinfo-memoryusage.html
Querying this table provides information similar to that provided by the ALL REPORT MemoryUsage command in the ndb_mgm client, or logged by ALL DUMP 1000. used Number of bytes currently used for data memory or index memory by this data node. The ...