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-online-ddl.html
Note ALGORITHM=INSTANT support is available for ADD COLUMN and other operations in MySQL 8.0.12. 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 ...
https://dev.mysql.com/doc/refman/8.0/en/mysqlimport.html
--compression-algorithms=value Command-Line Format --compression-algorithms=value Introduced 8.0.18 Type Set Default Value uncompressed Valid Values zlibzstduncompressed The permitted compression algorithms for connections to the server. The ... The ...
https://dev.mysql.com/doc/refman/8.0/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.0/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 ...
https://dev.mysql.com/doc/refman/8.0/en/mysqldump.html
--compression-algorithms=value Command-Line Format --compression-algorithms=value Introduced 8.0.18 Type Set Default Value uncompressed Valid Values zlibzstduncompressed The permitted compression algorithms for connections to the server. The ... The ...
https://dev.mysql.com/doc/refman/8.0/en/encryption-functions.html
Note Exploits for the MD5 and SHA-1 algorithms have become known. AES_DECRYPT(crypt_str,key_str[,init_vector][,kdf_name][,salt][,info | iterations]) This function decrypts data using the official AES (Advanced Encryption Standard) algorithm. If you ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-transaction-scheduling.html
InnoDB uses the Contention-Aware Transaction Scheduling (CATS) algorithm to prioritize transactions that are waiting for locks. When multiple transactions are waiting for a lock on the same object, the CATS algorithm determines which transaction ...
https://dev.mysql.com/doc/refman/8.0/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/refman/8.0/en/create-view.html
If the view does not exist, CREATE OR REPLACE VIEW is the same as CREATE VIEW. If the view does exist, CREATE OR REPLACE VIEW replaces it. Beginning with MySQL 8.0.19, the SELECT statement can use a VALUES statement as its source, or can be replaced ...For information about restrictions on view use, see Section 27.9, “Restrictions on ...
https://dev.mysql.com/doc/refman/8.0/en/data-masking-component-functions.html
mask_canada_sin(str [, mask_char]) Masks a Canada Social Insurance Number (SIN) and returns the number with all meaningful digits replaced by 'X' characters. mask_iban(str [, mask_char]) Masks an International Bank Account Number (IBAN) and returns ...Nine digits grouped in pattern: xxx-xxx-xxx ('-' is any separator ...