PDF (US Ltr)
- 41.8Mb
PDF (A4)
- 41.9Mb
Man Pages (TGZ)
- 272.4Kb
Man Pages (Zip)
- 378.4Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/en/non-typed-operators.html
->> Return value from JSON column after evaluating path and unquoting the result; equivalent to JSON_UNQUOTE(JSON_EXTRACT()). / Division operator := Assign a value = Assign a value (as part of a SET statement, or as part of the SET clause in an ...
https://dev.mysql.com/doc/refman/9.7/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/9.7/en/option-tracker-component-functions.html
The Option Tracker provides the functions shown in the next table. More detailed information about each function is provided in the list following the table. These functions provide safe interfaces for reading and updating the ...
https://dev.mysql.com/doc/refman/9.7/en/option-tracker-component-tables.html
This table, like other Performance Schema tables, is read-only, and thus cannot be updated or truncated by users. See Section 29.12.22.7, “The mysql_option Table”, for more detailed information about this table, such as columns and their ...
https://dev.mysql.com/doc/refman/9.7/en/partitioning-key.html
Partitioning by key is similar to partitioning by hash, except that where hash partitioning employs a user-defined expression, the hashing function for key partitioning is supplied by the MySQL server. NDB Cluster uses MD5() for this purpose; for ...
https://dev.mysql.com/doc/refman/9.7/en/partitioning-limitations-functions.html
This section discusses limitations in MySQL Partitioning relating specifically to functions used in partitioning expressions. Each of these functions returns an integer only if it is passed an argument of an exact numeric type, such as one of the ...
https://dev.mysql.com/doc/refman/9.7/en/partitioning-pruning.html
The optimization known as partition pruning is based on a relatively simple concept which can be described as “Do not scan partitions where there can be no matching values”. By limiting the search, it is possible to expend much less time and ...
https://dev.mysql.com/doc/refman/9.7/en/password-management.html
MySQL supports these password-management capabilities: Password expiration, to require passwords to be changed periodically. Password reuse restrictions, to prevent old passwords from being chosen again. Password verification, to require that ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-stage-tables.html
The Performance Schema instruments stages, which are steps during the statement-execution process, such as parsing a statement, opening a table, or performing a filesort operation. Stages correspond to the thread states displayed by SHOW ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-timing.html
Events are collected by means of instrumentation added to the server source code. Instruments time events, which is how the Performance Schema provides an idea of how long events take. It is also possible to configure instruments not to collect ...