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-tuning-recovery.html
Whenever a new member joins a replication group, it connects to a suitable donor and fetches the data that it has missed up until the point it is declared online. Duplicated data - If a server joining the group already contains some data that ...
https://dev.mysql.com/doc/refman/5.7/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/5.7/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/5.7/en/data-size.html
You can get better performance for a table and minimize storage space by using the techniques listed here: Table Columns Row Format Indexes Joins Normalization Table Columns Use the most efficient (smallest) data types possible. Joins In some ...
https://dev.mysql.com/doc/refman/5.7/en/example-maximum-column-group-row.html
Other possibilities for solving the problem are to use an uncorrelated subquery in the FROM clause or a LEFT JOIN. Task: For each article, find the dealer or dealers with the most expensive price.
https://dev.mysql.com/doc/refman/5.7/en/group-replication-group-membership.html
The group is dynamic and servers can leave (either voluntarily or involuntarily) and join it at any time. If a server joins the group, it automatically brings itself up to date by fetching the missing state from an existing server. It is possible ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-selection.html
MySQL 5.7 supports explicit selection of partitions and subpartitions that, when executing a statement, should be checked for rows matching a given WHERE condition. Partition selection is similar to partition pruning, in that only specific ...
https://dev.mysql.com/doc/refman/5.7/en/server-status-variables.html
You probably have a lot of queries that require MySQL to scan entire tables or you have joins that do not use keys properly. Select_full_join The number of joins that perform table scans because they do not use indexes. Select_full_range_join The ...
https://dev.mysql.com/doc/refman/5.7/en/trace-general-structure.html
A trace follows the actual execution path very closely; for each join, there is a join preparation object, a join optimization object, and a join execution object. Query transformations (IN to EXISTS, outer join to inner join, and so on), ...Calls ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-frequently-asked-questions.html
Attempting to add another server to a group with 9 members causes the request to join to be refused. The second member joining the group needs to ask the member that bootstrapped the group to dynamically change the configuration in order for it to ...What is the maximum number of MySQL servers in a group? A group can consist of maximum 9 ...