PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.5Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/encryption-functions.html
One way to make collisions detectable is to make the hash column a primary key. AES_DECRYPT(crypt_str,key_str[,init_vector][,kdf_name][,salt][,info | iterations]) This function decrypts data using the official AES (Advanced Encryption Standard) ...
https://dev.mysql.com/doc/refman/8.0/en/checking-gpg-signature.html
To verify the signature for a specific package, you first need to obtain a copy of our public GPG build key, which you can download from http://pgp.mit.edu/. The keyID for MySQL 8.0.44 packages and higher, MySQL 8.4.7 and higher, and MySQL 9.5.0 and ... Another method of verifying the integrity and authenticity of a package is to use cryptographic ...
https://dev.mysql.com/doc/refman/8.0/en/myisamchk-table-info.html
Possible values are crashed, open, changed, analyzed, optimized keys, and sorted index pages. Auto increment key, Last value The key number associated the table's AUTO_INCREMENT column, and the most recently generated value for this column. Keyfile ... To obtain a description of a MyISAM table or statistics about it, use the commands shown ...
https://dev.mysql.com/doc/refman/8.0/en/range-optimization.html
Additionally, for BTREE indexes, comparison of a key part with a constant value is a range condition when using the >, <, >=, <=, BETWEEN, !=, or <> operators, or LIKE comparisons if the argument to LIKE is a constant string that does not start with ... The range access method uses a single index to retrieve a subset of table rows that are contained within one or several index value ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-information-schema-system-tables.html
INNODB_FIELDS provides metadata about the key columns (fields) of InnoDB indexes. INNODB_FOREIGN_COLS provides metadata about the columns of foreign keys that are defined on InnoDB tables. The MODIFIED_COUNTER value shows the number of rows modified ... You can extract metadata about schema objects managed by InnoDB using InnoDB INFORMATION_SCHEMA ...
https://dev.mysql.com/doc/refman/8.0/en/faqs-tablespace-encryption.html
How do I change (rotate, re-key) the master encryption key? A.17.15. It uses Electronic Codebook (ECB) block encryption mode for tablespace key encryption and Cipher Block Chaining (CBC) block encryption mode for data encryption. However, the ...Is ...
https://dev.mysql.com/doc/refman/8.0/en/upgrading-from-previous-series.html
Clients that use an account that authenticates with caching_sha2_password must use either a secure connection (made using TCP using TLS/SSL credentials, a Unix socket file, or shared memory), or an unencrypted connection that supports password ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-replication-mta.html
Transaction Dependency and Writeset Handling Transaction dependencies are detected using analysis of each transaction's writeset, that is, the set of rows (table, key values) written by the transaction. Where a table has secondary unique keys, these ...To use this functionality with NDB Cluster, it is necessary that the following three conditions be met: Binary log transaction dependencies are determined at the ...
https://dev.mysql.com/doc/refman/8.0/en/create-table-select.html
For example: mysql> CREATE TABLE test (a INT NOT NULL AUTO_INCREMENT, -> PRIMARY KEY (a), KEY(b)) -> ENGINE=InnoDB SELECT b,c FROM test2; This creates an InnoDB table with three columns, a, b, and c. As of MySQL 8.0.21, on storage engines that ...
https://dev.mysql.com/doc/refman/8.0/en/index-page-merge-threshold.html
row *************************** Table: t2 Create Table: CREATE TABLE `t2` ( `id` int(11) DEFAULT NULL, KEY `id_index` (`id`) COMMENT 'MERGE_THRESHOLD=40' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci Note A MERGE_THRESHOLD value ...If the “page-full” percentage for an index page falls below the MERGE_THRESHOLD value when a row is deleted or when a row is shortened by an UPDATE operation, InnoDB attempts to merge the index page with a neighboring index ...