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/foreign-key-optimization.html
That way, each small table can have a primary key for fast lookups of its data, and you can query just the set of columns that you need using a join operation. If a table has many columns, and you query many different combinations of columns, it ...
https://dev.mysql.com/doc/refman/8.0/en/function-optimization.html
If a function is tagged nondeterministic, a reference to it in a WHERE clause is evaluated for every row (when selecting from one table) or combination of rows (when selecting from a multiple-table join). A function is nondeterministic if, given ...
https://dev.mysql.com/doc/refman/8.0/en/group-by-handling.html
SQL-92 and earlier does not permit queries for which the select list, HAVING condition, or ORDER BY list refer to nonaggregated columns that are not named in the GROUP BY clause. SQL:1999 and later permits such nonaggregates per optional feature ...
https://dev.mysql.com/doc/refman/8.0/en/group-by-modifiers.html
You cannot test them as NULL values in join conditions or the WHERE clause to determine which rows to select. The GROUP BY clause permits a WITH ROLLUP modifier that causes summary output to include extra rows that represent higher-level (that is, ...
https://dev.mysql.com/doc/refman/8.0/en/group-by-optimization.html
If the WHERE clause contains range predicates (see the discussion of the range join type in Section 10.8.1, “Optimizing Queries with EXPLAIN”), a Loose Index Scan looks up the first key of each group that satisfies the range conditions, and ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-background.html
Servers can leave and join the group and the view is updated accordingly. The most common way to create a fault-tolerant system is to resort to making components redundant, in other words the component can be removed and the system should continue ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-deploying-locally.html
Usually you want all members to be able to serve as seeds for members that are joining the group and have not got the transactions processed by the group. The most common way to deploy Group Replication is using multiple server instances, to ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-limitations.html
If further members attempt to join the group, their request is refused. Limit on Group Size Limits on Transaction Size The following known limitations exist for Group Replication. Note that the limitations and issues described for multi-primary ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-message-compression.html
Compression for these messages, which are sent from a donor already in the group to a joining member, is controlled separately using the group_replication_recovery_compression_algorithms and group_replication_recovery_zstd_compression_level system ... For messages sent between online group members, Group Replication enables message compression by ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-plugin-architecture.html
The recovery component manages distributed recovery, and is responsible for getting a server that is joining the group up to date by selecting the donor, managing the catch up procedure and reacting to donor failures. MySQL Group Replication is a ...