Search Results
https://dev.mysql.com/doc/mysql-ai/9.4/en/mys-ai-bulk-load-mysql-server.html
Bulk Ingest Data Type Support LOAD DATA with ALGORITHM=BULK supports tables with at least one column with the VECTOR data type. MySQL includes a bulk load extension to the LOAD DATA statement. It can do the following: Optimize the loading of data ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/backup-compression-options.html
--compress-method=ALGORITHM Command-Line Format --compress-method=ALGORITHM Type Enumeration Default Value lz4 Valid Values zliblz4lzmapunch-holenone Specifies the algorithm for backup compression, or enables support for InnoDB transparent page ...
https://dev.mysql.com/doc/refman/8.4/en/create-table.html
IGNORE | REPLACE The IGNORE and REPLACE options indicate how to handle rows that duplicate unique key values when copying a table using a SELECT statement. Keep in mind that a table comment used with ALTER TABLE replaces any existing comment which ...| {FULLTEXT | SPATIAL} [INDEX | KEY] [index_name] (key_part,...) [index_option] ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-bulk-load-mysql-server.html
Bulk Ingest Data Type Support LOAD DATA with ALGORITHM=BULK supports the following data types. MySQL includes a bulk load extension to the LOAD DATA statement that is only available in MySQL HeatWave on AWS. It can do the following: Optimize the ...
https://dev.mysql.com/doc/refman/8.4/en/enterprise-encryption-usage.html
The following general considerations apply when choosing key lengths and encryption algorithms: The strength of encryption for private and public keys increases with the key size, but the time for key generation increases as well. The digest type in ... To use MySQL Enterprise Encryption in applications, invoke the functions that are appropriate for the operations you wish to ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-online-ddl.html
You can control aspects of a DDL operation using the ALGORITHM and LOCK clauses of the ALTER TABLE statement. For example: ALTER TABLE tbl_name ADD PRIMARY KEY (column), ALGORITHM=INPLACE; The LOCK clause may be used for operations that are ... The ...
https://dev.mysql.com/doc/refman/8.4/en/alter-user.html
For josh, IDENTIFIED BY establishes a new password ('josh_new_password'), REPLACE is specified to verify that the user issuing the ALTER USER statement knows the current password ('josh_current_password'), and that current password is also retained ... ALTER USER [IF EXISTS] user [auth_option] [, user [auth_option]] ...
https://dev.mysql.com/doc/refman/8.4/en/mysqlimport.html
--compression-algorithms=value Command-Line Format --compression-algorithms=value Type Set Default Value uncompressed Valid Values zlibzstduncompressed The permitted compression algorithms for connections to the server. The available algorithms are ... The mysqlimport client provides a command-line interface to the LOAD DATA SQL ...
https://dev.mysql.com/doc/mysql-ai/9.4/en/mys-ai-genai-rag.html
To specify the table for retrieving the vector embeddings to use as context, set the @options variable: mysql> SET @options = JSON_OBJECT( "vector_store", JSON_ARRAY("DBName.VectorStoreTableName"), "model_options", JSON_OBJECT("language", ... The ...
https://dev.mysql.com/doc/refman/8.4/en/innochecksum.html
Example usage: innochecksum --page=701 ../data/test/tab1.ibd --strict-check, -C Command-Line Format --strict-check=algorithm Type Enumeration Default Value crc32 Valid Values innodbcrc32none Specify a strict checksum algorithm. In this example, the ...This tool reads an InnoDB tablespace file, calculates the checksum for each page, compares the calculated checksum to the stored checksum, and reports mismatches, which indicate damaged ...