PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.5Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/null-values.html
For sorting with ORDER BY, NULL values sort before other values for ascending sorts, after other values for descending sorts. The NULL value means “no data.” NULL can be written in any lettercase. Be aware that the NULL value is different from ...
https://dev.mysql.com/doc/refman/8.0/en/optimizer-statistics.html
The column_statistics data dictionary table stores histogram statistics about column values, for use by the optimizer in constructing query execution plans. The column_statistics table has these characteristics: The table contains statistics for ...
https://dev.mysql.com/doc/refman/8.0/en/option-file-options.html
(For information about the order in which option files are used, see Section 6.2.2.2, “Using Option Files”.) If the file does not exist or is otherwise inaccessible, an error occurs. Most MySQL programs that support option files handle the ...
https://dev.mysql.com/doc/refman/8.0/en/outer-join-optimization.html
To provide a hint about the table join order, use optimizer hints; see Section 10.9.3, “Optimizer Hints”. MySQL implements an A LEFT JOIN B join_specification as follows: Table B is set to depend on table A and all tables on which A depends.
https://dev.mysql.com/doc/refman/8.0/en/partitioning-handling-nulls.html
MySQL's partitioning implementation treats NULL as being less than any non-NULL value, just as ORDER BY does. Partitioning in MySQL does nothing to disallow NULL as the value of a partitioning expression, whether it is a column value or the value ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-list.html
Unlike the case with partitions defined by range, list partitions do not need to be declared in any particular order. List partitioning in MySQL is similar to range partitioning in many ways. As in partitioning by RANGE, each partition must be ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-management-exchange.html
Table nt contains no foreign key references, and no other table has any foreign keys that refer to nt. There are no rows in nt that lie outside the boundaries of the partition definition for p. For InnoDB tables, both tables must use the same row ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-pruning.html
When the optimizer can make use of partition pruning in performing this query, execution of the query can be an order of magnitude faster than the same query against a nonpartitioned table containing the same column definitions and data. The ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-range.html
A table that is partitioned by range is partitioned in such a way that each partition contains rows for which the partitioning expression value lies within a given range. Ranges should be contiguous but not overlapping, and are defined using the ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-connection-tables.html
When a client connects to the MySQL server, it does so under a particular user name and from a particular host. They differ in that, for grant tables, the host part of an account can be a pattern, whereas for Performance Schema tables, the host ...