PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/innodb-row-format.html
Table-rebuilding operations include ALTER TABLE operations that use ALGORITHM=COPY or ALGORITHM=INPLACE where table rebuilding is required. The row format of a table determines how its rows are physically stored, which in turn can affect the ...
https://dev.mysql.com/doc/refman/8.0/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.0/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.0/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.0/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.0/en/performance-schema-replication-connection-configuration-table.html
(CHANGE REPLICATION SOURCE TO option: SOURCE_COMPRESSION_ALGORITHMS, CHANGE MASTER TO option: MASTER_COMPRESSION_ALGORITHMS) For more information, see Section 6.2.8, “Connection Compression Control”. ZSTD_COMPRESSION_LEVEL The compression level ... This table shows the configuration parameters used by the replica for connecting to the ...
https://dev.mysql.com/doc/refman/8.0/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.0/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/refman/8.0/en/binary-installation.html
For information about replacing third-party packages with official MySQL packages, see the related APT guide or Yum guide. Note The compression algorithm changed from Gzip to XZ in MySQL Server 8.0.12; and the generic binary's file extension changed ...These include generic binary distributions in the form of compressed tar files (files with a .tar.xz extension) for a number of platforms, and binaries in platform-specific package formats for selected ...
https://dev.mysql.com/doc/refman/8.0/en/extensions-to-ansi.html
The LOW_PRIORITY clause of the INSERT, REPLACE, DELETE, and UPDATE statements. MySQL Server supports some extensions that you are not likely to find in other SQL DBMSs. Be warned that if you use them, your code is most likely not portable to other ...