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/partitioning-selection.html
Whereas partition pruning applies only to queries, explicit selection of partitions is supported for both queries and a number of DML statements. Explicit selection of partitions and subpartitions for rows matching a given WHERE condition is ...
https://dev.mysql.com/doc/refman/8.0/en/sql-mode.html
ONLY_FULL_GROUP_BY Reject queries for which the select list, HAVING condition, or ORDER BY list refer to nonaggregated columns that are neither named in the GROUP BY clause nor are functionally dependent on (uniquely determined by) GROUP BY columns.
https://dev.mysql.com/doc/refman/8.0/en/switchable-optimizations.html
The default value for this flag is off, since, in most cases, enabling this optimization does not produce any noticeable improvement in performance (and in many cases can even make queries run more slowly), but you can enable the optimization by ...
https://dev.mysql.com/doc/refman/8.0/en/json-search-functions.html
Starting with MySQL 8.0.17, queries using JSON_CONTAINS() on InnoDB tables can be optimized using multi-valued indexes; see Multi-Valued Indexes, for more information. Queries on JSON columns of InnoDB tables using JSON_OVERLAPS() in the WHERE ...
https://dev.mysql.com/doc/refman/8.0/en/semijoins.html
Beginning with MySQL 8.0.17, the following subqueries are transformed into antijoins: NOT IN (SELECT ... For more information about materialization, see Section 10.2.2.2, “Optimizing Subqueries with Materialization”. This affects queries that ...
https://dev.mysql.com/doc/refman/8.0/en/audit-log-filter-definitions.html
From MySQL 8.0.28, the AUDIT_ABORT_EXEMPT privilege is available to permit a user account’s queries to always be executed even if an abort item would block them. Table 8.41 audit_log_policy_value Values Value Corresponding audit_log_policy Value 0 ...For information about using JSON data in MySQL, see Section 13.5, “The JSON Data ...
https://dev.mysql.com/doc/refman/8.0/en/cost-model.html
To generate execution plans, the optimizer uses a cost model that is based on estimates of the cost of various operations that occur during query execution. The optimizer has a set of compiled-in default “cost constants” available to it to make ...
https://dev.mysql.com/doc/refman/8.0/en/derived-condition-pushdown-optimization.html
MySQL 8.0.22 and later supports derived condition pushdown for eligible subqueries. When a derived table cannot be merged into the outer query (for example, if the derived table uses aggregation), pushing the outer WHERE condition down to the ...
https://dev.mysql.com/doc/refman/8.0/en/json-utility-functions.html
This section documents utility functions that act on JSON values, or strings that can be parsed as JSON values. JSON_PRETTY() prints out a JSON value in a format that is easy to read. JSON_STORAGE_SIZE() and JSON_STORAGE_FREE() show, respectively, ...
https://dev.mysql.com/doc/refman/8.0/en/fulltext-natural-language.html
For MyISAM tables, a boolean search can be done in the absence of an index (albeit more slowly), in which case it is possible to name columns from multiple tables. By default or with the IN NATURAL LANGUAGE MODE modifier, the MATCH() function ...