PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/order-by-optimization.html
This section describes when MySQL can use an index to satisfy an ORDER BY clause, the filesort operation used when an index cannot be used, and execution plan information available from the optimizer about ORDER BY. An ORDER BY with and without ...
https://dev.mysql.com/doc/refman/8.0/en/lock-order-tool.html
As of MySQL 8.0.17, to enable detection of lock-acquisition deadlocks and enforcement that runtime execution is free of them, MySQL supports LOCK_ORDER tooling. This enables a lock-order dependency graph to be defined as part of server design, and ... The MySQL server is a multithreaded application that uses numerous internal locking and lock-related primitives, such as mutexes, rwlocks (including prlocks and sxlocks), conditions, and ...
https://dev.mysql.com/doc/refman/8.0/en/problems-with-alias.html
An alias can be used in a query select list to give a column a different name. This restriction is imposed because when the WHERE clause is evaluated, the column value may not yet have been determined. In the select list of a query, a quoted column ...
https://dev.mysql.com/doc/refman/8.0/en/set-operations.html
Result Set Column Names and Data Types Set Operations with TABLE and VALUES Statements Set Operations using DISTINCT and ALL Set Operations with ORDER BY and LIMIT Limitations of Set Operations SQL set operations combine the results of multiple ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndbd-definition.html
If no node IDs are provided, the order of the data nodes is the determining factor for the node group. There is also a reference to each copy in the ordered table indexes. Assume that table t1 has 1 million rows and an ordered index named ix1 on two ... The [ndbd] and [ndbd default] sections are used to configure the behavior of the cluster's data ...
https://dev.mysql.com/doc/refman/8.0/en/optimizer-hints.html
Join-Order Optimizer Hints Join-order hints affect the order in which the optimizer joins tables. Syntax of the JOIN_FIXED_ORDER hint: hint_name([@query_block_name]) Syntax of other join-order hints: hint_name([@query_block_name] tbl_name [, ... One ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-nutshell.html
Statement-based replication requires the consecutive auto-increment lock mode (the previous default) to ensure that auto-increment values are assigned in a predictable and repeatable order for a given sequence of SQL statements, whereas row-based ...
https://dev.mysql.com/doc/refman/8.0/en/window-function-descriptions.html
This represents the number of rows preceding or peer with the current row in the window ordering of the window partition divided by the total number of rows in the window partition. This function should be used with ORDER BY to sort partition rows ... This section describes nonaggregate window functions that, for each row from a query, perform a calculation using rows related to that ...
https://dev.mysql.com/doc/refman/8.0/en/charset-unicode-sets.html
These two binary collations have the same sort order but are distinguished by their pad attribute and collating weight characteristics. For questions about particular language orderings, http://unicode.org provides Common Locale Data Repository ...
https://dev.mysql.com/doc/refman/8.0/en/replication-options-replica.html
If you specify the relay_log system variable at server startup without specifying a value, unexpected behavior is likely to result; this behavior depends on the other options used, the order in which they are specified, and whether they are ... This ...