PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.5Kb
Man Pages (Zip)
- 401.9Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/innodb-statistics-estimation.html
The default number of sampled pages is 8, which could be insufficient to produce an accurate estimate, leading to poor index choices by the query optimizer. Optimizer statistics are not persisted to disk when innodb_stats_persistent=OFF or when ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-transaction-scheduling.html
A single attempt may lead to zero or more record locks being released, as there may be zero or more record locks in a single structure. InnoDB uses the Contention-Aware Transaction Scheduling (CATS) algorithm to prioritize transactions that are ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-undo-tablespaces.html
An undo tablespace not found before recovery cannot be used, which can lead to database inconsistencies. Undo tablespaces contain undo logs, which are collections of records containing information about how to undo the latest change by a ...
https://dev.mysql.com/doc/refman/8.0/en/insert-select.html
This means that, when using replication, there is no guarantee that such a SELECT returns rows in the same order on the source and the replica, which can lead to inconsistencies between them. INSERT [LOW_PRIORITY | HIGH_PRIORITY] [IGNORE] [INTO] ...
https://dev.mysql.com/doc/refman/8.0/en/insert.html
If the string value has no leading numeric part, the column is set to 0. INSERT [LOW_PRIORITY | DELAYED | HIGH_PRIORITY] [IGNORE] [INTO] tbl_name [PARTITION (partition_name [, partition_name] ...)] [(col_name [, col_name] ...)] { {VALUES | VALUE} ...
https://dev.mysql.com/doc/refman/8.0/en/installation-layouts.html
The installation layout differs for different installation types (for example, native packages, binary tarballs, and source tarballs), which can lead to confusion when managing different systems or using different installation sources. The ...
https://dev.mysql.com/doc/refman/8.0/en/invoking-programs.html
Nonoption arguments (arguments with no leading dash) provide additional information to the program. To invoke a MySQL program from the command line (that is, from your shell or command prompt), enter the program name followed by any options or ...
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/manual-info.html
This is the Reference Manual for the MySQL Database System, version 8.0, through release 8.0.42. Differences between minor versions of MySQL 8.0 are noted in the present text with reference to release numbers (8.0.x). This manual is not intended ...
https://dev.mysql.com/doc/refman/8.0/en/miscellaneous-functions.html
The function return value and type are the same as the return value and type of its argument, but the function result is not checked for the ONLY_FULL_GROUP_BY SQL mode. As a result, the address value for rows within each name group is ...