PDF (US Ltr)
- 41.9Mb
PDF (A4)
- 42.0Mb
Man Pages (TGZ)
- 272.3Kb
Man Pages (Zip)
- 378.3Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/en/innodb-performance-compression-oltp.html
Traditionally, the InnoDB compression feature was recommended primarily for read-only or read-mostly workloads, such as in a data warehouse configuration. The rise of SSD storage devices, which are fast but relatively small and expensive, makes ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-row-format.html
The row format of a table determines how its rows are physically stored, which in turn can affect the performance of queries and DML operations. As more rows fit into a single disk page, queries and index lookups can work faster, less cache memory ...
https://dev.mysql.com/doc/refman/9.7/en/internal-temporary-tables.html
In some cases, the server creates internal temporary tables while processing statements. The server creates temporary tables under conditions such as these: Evaluation of UNION statements, with some exceptions described later. Evaluation of some ...
https://dev.mysql.com/doc/refman/9.7/en/jdv-concurrency.html
DML operations for JSON duality views support lockless optimistic concurrency control (LOCC). The use of LOCC safeguards against conflicts and data inconsistencies for concurrent operations. This is especially important for read and write ...
https://dev.mysql.com/doc/refman/9.7/en/json-function-reference.html
Table 14.22 JSON Functions Name Description Deprecated -> Return value from JSON column after evaluating path; equivalent to JSON_EXTRACT(). ->> Return value from JSON column after evaluating path and unquoting the result; equivalent to ...
https://dev.mysql.com/doc/refman/9.7/en/json-search-functions.html
The functions in this section perform search or comparison operations on JSON values to extract data from them, report whether data exists at a location within them, or report the path to data within them. JSON_CONTAINS(target, candidate[, path]) ...
https://dev.mysql.com/doc/refman/9.7/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/9.7/en/json-validation-functions.html
MySQL supports validation of JSON documents against JSON schemas conforming to Draft 4 of the JSON Schema specification. This can be done using either of the functions detailed in this section, both of which take two arguments, a JSON schema, and a ...
https://dev.mysql.com/doc/refman/9.7/en/keyring-aws-plugin.html
Note The keyring_aws plugin is an extension included in MySQL Enterprise Edition, a commercial product. Important The keyring_aws keyring plugin is deprecated, and is being replaced by the AWS Keyring component (component_aws_keyring). Deprecation ...
https://dev.mysql.com/doc/refman/9.7/en/keyring-okv-component.html
Note component_keyring_kmip is an extension included in MySQL Enterprise Edition, a commercial product. The Key Management Interoperability Protocol (KMIP) Keyring component is intended to replace the keyring_okv Keyring plugin, which is now ...