PDF (US Ltr)
- 43.1Mb
PDF (A4)
- 43.2Mb
Man Pages (TGZ)
- 296.0Kb
Man Pages (Zip)
- 401.3Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/engine-condition-pushdown-optimization.html
This optimization improves the efficiency of direct comparisons between a nonindexed column and a constant. In such cases, the condition is “pushed down” to the storage engine for evaluation. This optimization can be used only by the NDB ...
https://dev.mysql.com/doc/refman/8.0/en/error-log-format.html
Each error log sink (writer) component has a characteristic output format it uses to write messages to its destination, but other factors may influence the content of the messages: The information available to the log sink. If a log filter ...
https://dev.mysql.com/doc/refman/8.0/en/explain-for-connection.html
To obtain the execution plan for an explainable statement executing in a named connection, use this statement: EXPLAIN [options] FOR CONNECTION connection_id; EXPLAIN FOR CONNECTION returns the EXPLAIN information that is currently being used to ...
https://dev.mysql.com/doc/refman/8.0/en/expressions.html
This section lists the grammar rules that expressions must follow in MySQL and provides additional information about the types of terms that may appear in expressions. Expression Syntax Expression Term Notes Temporal Intervals Expression Syntax The ...
https://dev.mysql.com/doc/refman/8.0/en/extensions-to-ansi.html
MySQL Server supports some extensions that you are not likely to find in other SQL DBMSs. Be warned that if you use them, your code is most likely not portable to other SQL servers. For example, MySQL Server recognizes the STRAIGHT_JOIN keyword in ...
https://dev.mysql.com/doc/refman/8.0/en/federated-usagenotes.html
The following items indicate features that the FEDERATED storage engine does and does not support: The remote server must be a MySQL server. The remote table that a FEDERATED table points to must exist before you try to access the table through the ...
https://dev.mysql.com/doc/refman/8.0/en/general-thread-states.html
The following list describes thread State values that are associated with general query processing and not more specialized activities such as replication. Many of these are useful only for finding bugs in the server. After create This occurs when ...
https://dev.mysql.com/doc/refman/8.0/en/group-by-modifiers.html
The GROUP BY clause permits a WITH ROLLUP modifier that causes summary output to include extra rows that represent higher-level (that is, super-aggregate) summary operations. ROLLUP thus enables you to answer questions at multiple levels of ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-frequently-asked-questions.html
What is the maximum number of MySQL servers in a group? A group can consist of maximum 9 servers. Attempting to add another server to a group with 9 members causes the request to join to be refused. This limit has been identified from testing and ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-secure-user.html
State transfer from the binary log requires a replication user with the correct permissions so that Group Replication can establish direct member-to-member replication channels. The same replication user is used for distributed recovery on all the ...