Search Results
https://dev.mysql.com/doc/refman/8.4/en/alter-table-partition-operations.html
ALGORITHM=1 causes the server to use the same key-hashing functions as MySQL 5.1 when computing the placement of rows in partitions; ALGORITHM=2 means that the server employs the key-hashing functions implemented and used by default for new KEY ...
https://dev.mysql.com/doc/refman/8.4/en/create-index.html
CREATE [UNIQUE | FULLTEXT | SPATIAL] INDEX index_name [index_type] ON tbl_name (key_part,...) [index_option] [algorithm_option | lock_option] ... Online creation of a multi-value index is not supported, which means the operation uses ALGORITHM=COPY. As with other indexes on columns of InnoDB tables, a multi-valued index cannot be created with USING HASH; attempting to do so results in a warning: This storage engine does not support the HASH index algorithm, storage engine default was used ...
https://dev.mysql.com/doc/refman/8.4/en/derived-table-optimization.html
The derived_merge flag also applies to views that contain no ALGORITHM clause. Thus, if an ER_UPDATE_TABLE_USED error occurs for a view reference that uses an expression equivalent to the subquery, adding ALGORITHM=TEMPTABLE to the view definition ...The optimizer handles derived tables, view references, and common table expressions the same way: It avoids unnecessary materialization whenever possible, which enables pushing down conditions from the outer query to derived tables and produces more efficient execution ...
https://dev.mysql.com/doc/refman/8.4/en/ibd2sdi.html
--strict-check, -c Command-Line Format --strict-check=algorithm Type Enumeration Default Value crc32 Valid Values crc32innodbnone Specifies a strict checksum algorithm for validating the checksum of pages that are read. In this example, the strict ... ibd2sdi is a utility for extracting serialized dictionary information (SDI) from InnoDB tablespace ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-online-ddl-limitations.html
Tables created before MySQL 5.6 that include temporal columns (DATE, DATETIME or TIMESTAMP) and have not been rebuilt using ALGORITHM=COPY do not support ALGORITHM=INPLACE. ALGORITHM=INPLACE operation returns the following error: ERROR 1846 (0A000): ... The following limitations apply to online DDL operations: The table is copied when creating an index on a TEMPORARY ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-online-add-node-example.html
ALGORITHM=INPLACE, REORGANIZE PARTITION does not work on tables that were created with the MAX_ROWS option. In this section we provide a detailed example illustrating how to add new NDB Cluster data nodes online, starting with an NDB Cluster having ...
https://dev.mysql.com/doc/refman/8.4/en/server-status-variables.html
Compression_algorithm The name of the compression algorithm in use for the current connection to the server. The value can be any algorithm permitted in the value of the protocol_compression_algorithms system variable. For example, the value is ...
https://dev.mysql.com/doc/relnotes/connector-j/en/news-8-0-22.html
(WL #14096) X DevAPI: A new connection property, xdevapi.compression-algorithms, has been introduced for specifying the compression algorithms to use and the priority in which they will be negotiated for. Version 8.0.22 is the latest General ...
https://dev.mysql.com/doc/mysql-ai/9.4/en/mys-ai-bulk-load-limitations.html
LOAD DATA with ALGORITHM=BULK supports tables with at least one column with the VECTOR data type. LOAD DATA with ALGORITHM=BULK has the following limitations: It locks the target table exclusively and does not allow other operations on the table.
A Quick Guide to Using the MySQL SLES Repository :: A Quick Guide to Using the MySQL SLES Repository
https://dev.mysql.com/doc/mysql-sles-repo-quick-guide/en/index.html
If you have installed MySQL with RPMs from the MySQL Developer Zone or the native software repository of SLES and want to replace the installation using the RPM from the MySQL SLES repository, follow these steps: Back up your database to avoid data ... Abstract This is a quick guide for using the MySQL SLES repository to install and upgrade MySQL on SUSE Linux Enterprise Server ...