PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/fulltext-search.html
For large data sets, it is much faster to load your data into a table that has no FULLTEXT index and then create the index after that, than to load data into a table that has an existing FULLTEXT index. MATCH (col1,col2,...) AGAINST (expr ...
https://dev.mysql.com/doc/refman/5.7/en/general-information-schema-tables.html
The following sections describe what may be denoted as the “general” set of INFORMATION_SCHEMA tables. These are the tables not associated with particular storage engines, components, or plugins.
https://dev.mysql.com/doc/refman/5.7/en/gis-class-point.html
A Point is a geometry that represents a single location in coordinate space. Point Examples Imagine a large-scale map of the world with many cities. On a city map, a Point object could represent a bus stop.
https://dev.mysql.com/doc/refman/5.7/en/gis-class-surface.html
Polyhedral surfaces are formed by “stitching” together simple surfaces along their boundaries, polyhedral surfaces in three-dimensional space may not be planar as a whole. The boundary of a simple Surface is the set of closed curves ...The ...
https://dev.mysql.com/doc/refman/5.7/en/gis-wkt-functions.html
Other functions provide type-specific construction functions for construction of geometry values of each geometry type. For a description of WKT format, see Well-Known Text (WKT) Format. If the geometry argument is NULL or not a syntactically ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-distributed-recovery.html
Distributed recovery can be summarized as the process through which a server gets missing transactions from the group so that it can then join the group having processed the same set of transactions as the other group members. This section ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-multi-primary-mode.html
Figure 17.6 Client Failover All servers are set to read-write mode when joining the group. In multi-primary mode, there is no notion of a single primary. There is no need to engage an election procedure because there is no server playing any ...
https://dev.mysql.com/doc/refman/5.7/en/index-merge-optimization.html
In this case, the key column contains a list of indexes used, and key_len contains a list of the longest key parts for those indexes. To enable only certain algorithms, set index_merge to off, and enable only such of the others as should be ... The ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-ft-default-stopword-table.html
This is not used if you override the default stopword processing with either the innodb_ft_server_stopword_table or the innodb_ft_user_stopword_table system variable. For information about the default InnoDB stopword list and how to define your own ... The INNODB_FT_DEFAULT_STOPWORD table holds a list of stopwords that are used by default when creating a FULLTEXT index on InnoDB ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-trx-table.html
The INNODB_TRX table provides information about every transaction currently executing inside InnoDB, including whether the transaction is waiting for a lock, when the transaction started, and the SQL statement the transaction is executing, if any.