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/engine-condition-pushdown-optimization.html
This is also true for a semijoin, provided the optimization strategy employed is firstMatch (see Section 10.2.2.1, “Optimizing IN and EXISTS Subquery Predicates with Semijoin Transformations”). This optimization improves the efficiency of ...
https://dev.mysql.com/doc/refman/8.0/en/error-log-destination-configuration.html
This is true even for sinks such as log_sink_json that can be enabled multiple times; all instances write to the console. This section describes which server options configure the default error log destination, which can be the console or a named ...
https://dev.mysql.com/doc/refman/8.0/en/error-log-rule-based-filtering.html
In subsequent rules, EXISTS tests against the field name are true, and the new value can be tested by comparison conditions. The log_filter_dragnet log filter component enables log filtering based on user-defined rules. To enable the ...
https://dev.mysql.com/doc/refman/8.0/en/explain-extended.html
<if>(condition, expr1, expr2) If the condition is true, evaluate to expr1, otherwise expr2. The EXPLAIN statement produces extra (“extended”) information that is not part of EXPLAIN output but can be viewed by issuing a SHOW WARNINGS statement ...
https://dev.mysql.com/doc/refman/8.0/en/expressions.html
This section lists the grammar rules that expressions must follow in MySQL and provides additional information about the types of terms that may appear in expressions. Expression Syntax Expression Term Notes Temporal Intervals Expression Syntax The ...
https://dev.mysql.com/doc/refman/8.0/en/external-locking.html
The same is true for use of myisampack to pack MyISAM tables. External locking is the use of file system locking to manage contention for MyISAM database tables by multiple processes. External locking is used in situations where a single process ...
https://dev.mysql.com/doc/refman/8.0/en/fulltext-natural-language.html
The MySQL FULLTEXT implementation regards any sequence of true word characters (letters, digits, and underscores) as a word. By default or with the IN NATURAL LANGUAGE MODE modifier, the MATCH() function performs a natural language search for a ...
https://dev.mysql.com/doc/refman/8.0/en/function-optimization.html
A function is nondeterministic if, given fixed values for its arguments, it can return different results for different invocations. If a function is tagged nondeterministic, a reference to it in a WHERE clause is evaluated for every row (when ...
https://dev.mysql.com/doc/refman/8.0/en/general-thread-states.html
Waiting on cond A generic state in which the thread is waiting for a condition to become true. The following list describes thread State values that are associated with general query processing and not more specialized activities such as ...
https://dev.mysql.com/doc/refman/8.0/en/glossary.html
When this assumption is true, the database does little unnecessary work; when requests do fail, extra work must be done to clean up and undo changes. These terms are commonly used in information about the MySQL database server. Files with this ...