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/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/8.0/en/example-maximum-column-group-row.html
Other possibilities for solving the problem are to use an uncorrelated subquery in the FROM clause, a LEFT JOIN, or a common table expression with a window function. Task: For each article, find the dealer or dealers with the most expensive price.
https://dev.mysql.com/doc/refman/8.0/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 ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-gtids.html
View change events (View_change_log_event), which are generated by the group itself when a new member joins, are given GTIDs when they are recorded in the binary log. Extra Transactions If a joining member has transactions in its GTID set that are ... Group Replication uses GTIDs (global transaction identifiers) to track exactly which transactions have been committed on every server ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-selection.html
Explicit selection of partitions and subpartitions for rows matching a given WHERE condition is supported. Partition selection is similar to partition pruning, in that only specific partitions are checked for matches, but differs in two key ...
https://dev.mysql.com/doc/refman/8.0/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/8.0/en/spatial-operator-functions.html
These arguments are byte string values produced by the ST_Buffer_Strategy() function, to be used for point, join, and end strategies: Point strategies apply to Point and MultiPoint geometries. If no join strategy is specified, the default is ...
https://dev.mysql.com/doc/refman/8.0/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/8.0/en/union.html
Compared to MySQL 5.7, several user-visible effects resulted from this work, which may require rewriting of certain statements: NATURAL JOIN permits an optional INNER keyword (NATURAL INNER JOIN), in compliance with standard SQL. STRAIGHT_JOIN now ... query_expression_body UNION [ALL | DISTINCT] query_block [UNION [ALL | DISTINCT] query_expression_body] [...] query_expression_body: See Section 15.2.14, “Set Operations with UNION, INTERSECT, and EXCEPT” UNION combines the result from multiple query blocks into a single result ...
https://dev.mysql.com/doc/refman/8.0/en/encrypted-connection-protocols-ciphers.html
For Group Replication distributed recovery connections where this server instance is the joining member that initiates distributed recovery (that is, the client), the group_replication_recovery_tls_version system variable specifies which protocols ... MySQL supports multiple TLS protocols and ciphers, and enables configuring which protocols and ciphers to permit for encrypted ...