Search Results
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndbd-definition.html
Currently, the only partitioning algorithm is hashing and ordered indexes are local to each node. The NDB recovery algorithm uses a “fuzzy” checkpoint of the data together with the UNDO log, and then applies the REDO log to play back all changes ... The [ndbd] and [ndbd default] sections are used to configure the behavior of the cluster's data ...
https://dev.mysql.com/doc/refman/8.4/en/optimizing-innodb-diskio.html
Review settings for the following configuration options when using non-rotational storage: innodb_checksum_algorithm The crc32 option uses a faster checksum algorithm and is recommended for fast storage systems. This behavior is controlled by ... If ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-hash.html
See Section 26.2.4.1, “LINEAR HASH Partitioning”, for a description of this algorithm. Partitioning by HASH is used primarily to ensure an even distribution of data among a predetermined number of partitions. To partition a table using HASH ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-key.html
See Section 26.2.4.1, “LINEAR HASH Partitioning”, for a description of this algorithm and its implications. Partitioning by key is similar to partitioning by hash, except that where hash partitioning employs a user-defined expression, the ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-linear-hash.html
MySQL also supports linear hashing, which differs from regular hashing in that linear hashing utilizes a linear powers-of-two algorithm whereas regular hashing employs the modulus of the hashing function's value. We call this value V; it can be ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-replication-connection-configuration-table.html
(CHANGE REPLICATION SOURCE TO option: SOURCE_COMPRESSION_ALGORITHMS) For more information, see Section 6.2.8, “Connection Compression Control”. ZSTD_COMPRESSION_LEVEL The compression level to use for connections to the source that use the zstd ... This table shows the configuration parameters used by the replica for connecting to the ...
https://dev.mysql.com/doc/refman/8.4/en/view-updatability.html
It is sometimes possible for a multiple-table view to be updatable, assuming that it can be processed with the MERGE algorithm. Some views are updatable and references to them can be used to specify tables to be updated in data change statements.
https://dev.mysql.com/doc/refman/8.4/en/x-plugin-status-variables.html
Mysqlx_compression_algorithm (Session scope) The compression algorithm in use for the X Protocol connection for this session. The permitted compression algorithms are listed by the mysqlx_compression_algorithms system variable.
https://dev.mysql.com/doc/relnotes/mysql/8.4/en/news-8-4-5.html
(The replica's binary log and GTID records showed that the row required was committed, and had not been deleted or updated.) This occurred on the replica when the row-matching algorithm used was HASH_SCAN and two rows in the same table had the same ...(Bug #37570206) Audit Log Notes <COMMAND_CLASS> was not populated for ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/backup.compressed.html
You can also select the compression algorithm to use by the --compress-method option and, when using the ZLIB or LZMA compression algorithm, the level of compression by the --compress-level option. To save disk space, you can compress InnoDB backup ...