PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.6Kb
Man Pages (Zip)
- 402.0Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-events-waits-current-table.html
The job of the Performance Schema instrumentation is to provide row count and accumulated execution time per table in the join. Assume a join query of the following form that is executed using a table join order of t1, t2, t3: SELECT ... Table ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-adding-instances.html
Start Group Replication and s2 starts the process of joining the group. Tip When Group Replication starts successfully and the server joins the group it checks the super_read_only variable. If the server should join the group as a read/write ... At ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-secure-socket-layer-support-ssl.html
A joining member that is configured to use only TLSv1.3 (tls_version=TLSv1.3) cannot join a replication group where any existing member does not support TLSv1.3, because the group members in that case are using a lower TLS protocol version. To join ... Secure sockets can be used for group communication connections between members of a ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-secure-user.html
In this situation, you can either copy the public key of the rpl_user to the joining member, or configure the donors to provide the public key when requested. The more secure approach is to copy the public key of the replication user account to the ... 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 ...
https://dev.mysql.com/doc/refman/8.0/en/myisampack.html
--join=big_tbl_name, -j big_tbl_name Command-Line Format --join=big_tbl_name Type String Join all tables named on the command line into a single packed table big_tbl_name. The source tables are read for the join operation but not modified. After ...
https://dev.mysql.com/doc/refman/8.0/en/explain.html
That is, MySQL explains how it would process the statement, including information about how tables are joined and in which order. In MySQL 8.0.16 and later, TREE provides tree-like output with more precise descriptions of query handling than the ...
https://dev.mysql.com/doc/refman/8.0/en/index-statistics.html
For a join based on the <=> comparison operator, NULL is not treated differently from any other value: NULL <=> NULL, just as N <=> N for any other N. However, for a join based on the = operator, NULL is different from non-NULL values: expr1 = expr2 ... Storage engines collect statistics about tables for use by the ...
https://dev.mysql.com/doc/refman/8.0/en/tracing-example.html
row *************************** QUERY: SELECT SUM(alias2.col_varchar_nokey) AS c1, alias2.pk AS c2 FROM t1 AS alias1 STRAIGHT_JOIN t2 AS alias2 ON alias2.pk = alias1.col_int_key WHERE alias1.pk GROUP BY c2 ORDER BY alias1.col_int_key, alias2.pk This ...Now we can examine the trace, whose first column (QUERY), containing the original statement to be traced, is shown here: SELECT * FROM INFORMATION_SCHEMA.OPTIMIZER_TRACE\G ...
https://dev.mysql.com/doc/refman/8.0/en/where-optimization.html
See Section 10.2.1.9, “Outer Join Optimization”, for further information and examples. For each table in a join, a simpler WHERE is constructed to get a fast WHERE evaluation for the table and also to skip rows as soon as possible. All of the ...
https://dev.mysql.com/doc/refman/8.0/en/correlated-subqueries.html
This reflects the cardinality check that the optimizer performs as part of evaluating the JOIN or WHERE clause, prior to evaluating any lifted predicate, which is done only if the subquery does not return more than one row. This type of ... A ...