Search Results
https://dev.mysql.com/doc/refman/8.4/en/innodb-page-compression.html
For example, a maximum InnoDB page size of 64KB with a 4KB file system block size may improve compression but may also increase demand on the buffer pool, leading to increased I/O and potential write amplification. InnoDB supports page-level ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-performance-optimizer-statistics.html
As a result, different estimates could be produced when recomputing statistics, leading to different choices in execution plans and variations in query performance. This section describes how to configure persistent and non-persistent optimizer ...
https://dev.mysql.com/doc/refman/8.4/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.4/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.4/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.4/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.4/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.4/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.4/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.4/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, ...