PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.5Kb
Man Pages (Zip)
- 401.8Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/grant.html
This is also true in MySQL if you use DROP USER. [WITH GRANT OPTION] [AS user [WITH ROLE DEFAULT | NONE | ALL | ALL EXCEPT role [, role ] ... ] ] } GRANT PROXY ON user_or_role TO user_or_role [, user_or_role] ... These syntax restrictions apply: ...
https://dev.mysql.com/doc/refman/8.0/en/group-by-optimization.html
The most important preconditions for using indexes for GROUP BY are that all GROUP BY columns reference attributes from the same index, and that the index stores its keys in order (as is true, for example, for a BTREE index, but not for a HASH ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-communication-protocol.html
Versions from MySQL 8.0.27 also allow the group communication engine to operate with a single consensus leader when the group is in single-primary mode and group_replication_paxos_single_leader is set to true (see Section 20.7.3, “Single Consensus ... From MySQL 8.0.16, Group Replication has the concept of a communication protocol for the ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-failure-detection.html
If the group’s consensus is that the suspicion is probably true, the group takes a coordinated decision to expel the member. Group Replication’s failure detection mechanism is a distributed service which is able to identify that a server in the ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-functions-for-communication-protocol.html
Versions from MySQL 8.0.27 also allow the group communication engine to operate with a single consensus leader when the group is in single-primary mode and group_replication_paxos_single_leader is set to true (see Section 20.7.3, “Single Consensus ... The following functions enable you to inspect and configure the Group Replication communication protocol version that is used by a replication ...
https://dev.mysql.com/doc/refman/8.0/en/handler.html
This occurs when both of the following circumstances are true: Any session executes FLUSH TABLES or DDL statements on the handler's table. HANDLER tbl_name OPEN [ [AS] alias] HANDLER tbl_name READ index_name { = | <= | >= | < | > } ...
https://dev.mysql.com/doc/refman/8.0/en/identifier-mapping.html
The same is true for any use of $ (dollar sign) in a schema or table name; it is replaced with @0024 on the filesystem. There is a correspondence between database and table identifiers and names in the file system. For the basic structure, MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/if.html
If a given search_condition evaluates to true, the corresponding THEN or ELSEIF clause statement_list executes. [ELSE statement_list] END IF The IF statement for stored programs implements a basic conditional construct. Note There is also an IF() ...
https://dev.mysql.com/doc/refman/8.0/en/index-hints.html
This is true even if the hint is given for a non-FULLTEXT index. Index hints give the optimizer information about how to choose indexes during query processing. Index hints, described here, differ from optimizer hints, described in Section 10.9.3, ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-parameters-table.html
The return value is not a true parameter, so the row that describes it has these unique characteristics: The ORDINAL_POSITION value is 0. The PARAMETERS table provides information about parameters for stored routines (stored procedures and stored ...