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/group-replication-distributed-recovery-basics.html
Whenever a member joins a replication group, it connects to an existing member to carry out state transfer. The server joining the group transfers all the transactions that took place in the group before it joined, which are provided by the ...When ...
https://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html
Normally, the best way to get fast joins is to add indexes. Increase the value of join_buffer_size to get a faster full join when adding indexes is not possible. One join buffer is allocated for each full join between two tables. For a complex join ... The MySQL server maintains many system variables that affect its ...
https://dev.mysql.com/doc/refman/5.7/en/group-by-functional-dependence.html
If in the join result co.Code is NULL-complemented, co.Name is as well. Functional dependence in outer joins is thus linked to whether determinant columns belong to the left or right side of the LEFT JOIN. Determination of functional dependence ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-view-changes.html
Figure 17.10 Stable Group View Change: a Member Joins Whenever a new member joins the group and therefore a view change is performed, every online server queues a view change log event for execution. Meanwhile, the server joining the group selects ... This section explains the process which controls how the view change identifier is incorporated into a binary log event and written to the log, The following steps are taken: Begin: Stable Group All servers are online and processing incoming transactions from the ...
https://dev.mysql.com/doc/refman/5.7/en/glossary.html
denormalized A data storage strategy that duplicates data across different tables, rather than linking the tables with foreign keys and join queries. One of the stages in designing a normalized database is to identify data that is duplicated, ...
https://dev.mysql.com/doc/refman/5.7/en/optimizer-hints.html
Table-Level Optimizer Hints Table-level hints affect use of the Block Nested-Loop (BNL) and Batched Key Access (BKA) join-processing algorithms (see Section 8.2.1.11, “Block Nested-Loop and Batched Key Access Joins”). Note To use a BNL or BKA ...
https://dev.mysql.com/doc/refman/5.7/en/semijoins.html
A semijoin is a preparation-time transformation that enables multiple execution strategies such as table pullout, duplicate weedout, first match, loose scan, and materialization. The optimizer uses semijoin strategies to improve subquery execution, ...But for some questions, the only information that matters is whether there is a match, not the number of ...
https://dev.mysql.com/doc/refman/5.7/en/delete.html
The table_references clause lists the tables involved in the join, as described in Section 13.2.9.2, “JOIN Clause”. The preceding examples use INNER JOIN, but multiple-table DELETE statements can use other types of join permitted in SELECT ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-what-is-new-7-6.html
When executing a scan as a pushed join (that is, the root of the query is a scan), the DBTC block sends an SPJ request to a DBSPJ instance on the same node as the fragment to be scanned. Since DBSPJ consumes a relatively small amount of the total ...
https://dev.mysql.com/doc/refman/5.7/en/view-updatability.html
For this to work, the view must use an inner join (not an outer join or a UNION). If the view is a join view, all components of the view must be updatable (not materialized). If a view is a join view, at least one component of the view must be ...