PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/fulltext-query-expansion.html
Note Because blind query expansion tends to increase noise significantly by returning nonrelevant documents, use it only when a search phrase is short. Full-text search supports query expansion (and in particular, its variant “blind query ...
https://dev.mysql.com/doc/refman/8.0/en/fulltext-stopwords.html
Note By default, words less than 3 characters in length or greater than 84 characters in length do not appear in an InnoDB full-text search index. The stopword list is loaded and searched for full-text queries using the server character set and ...
https://dev.mysql.com/doc/refman/8.0/en/functions.html
Note By default, there must be no whitespace between a function name and the parenthesis following it. Expressions can be used at several points in SQL statements, such as in the ORDER BY or HAVING clauses of SELECT statements, in the WHERE clause ...
https://dev.mysql.com/doc/refman/8.0/en/generated-column-index-optimizations.html
For example: CREATE TABLE t1 (f1 INT, gc INT AS (f1 + 1) STORED, INDEX (gc)); The generated column, gc, is defined as the expression f1 + 1. The column is also indexed and the optimizer can take that index into account during execution plan ...
https://dev.mysql.com/doc/refman/8.0/en/glossary.html
Often denotes a class of applications with relatively simple database usage (basic DDL, DML and query statements in SQL) that can be implemented quickly in any language. Note: MySQL 8.0 is a Bugfix series that preceded the LTS release model. These ...
https://dev.mysql.com/doc/refman/8.0/en/grant.html
Note MySQL automatically assigns all privileges granted to 'username'@'%' to the 'username'@'localhost' account as well. [WITH GRANT OPTION] [AS user [WITH ROLE DEFAULT | NONE | ALL | ALL EXCEPT role [, role ] ... ] ] } GRANT PROXY ON user_or_role ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-communication-protocol.html
From MySQL 8.0.16, Group Replication has the concept of a communication protocol for the group. The Group Replication communication protocol version can be managed explicitly, and set to accommodate the oldest MySQL Server version that you want the ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-compatibility-communication.html
Note that the group_replication_get_communication_protocol() function returns the minimum MySQL version that the group supports, which might differ from the version number that was passed to the group_replication_set_communication_protocol() ... A ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-compatibility-upgrade.html
Note that if you require the primary to remain the same throughout (except when it is being upgraded itself), you must first upgrade all of the secondaries to a version higher than or equal to the target primary member version, then upgrade the ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-configuring-consistency-guarantees.html
Note that the higher consistency levels BEFORE, AFTER, and BEFORE_AND_AFTER also include the consistency guarantees provided by BEFORE_ON_PRIMARY_FAILOVER. Although the Transaction Synchronization Points section explains that conceptually there are ...