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/keyring-encrypted-file-component.html
Note component_keyring_encrypted_file is an extension included in MySQL Enterprise Edition, a commercial product. The component_keyring_encrypted_file keyring component stores keyring data in an encrypted, password-protected file local to the ...If ...
https://dev.mysql.com/doc/refman/8.0/en/keyring-file-component.html
The component_keyring_file keyring component stores keyring data in a file local to the server host. Warning For encryption key management, the component_keyring_file and component_keyring_encrypted_file components, and the keyring_file and ...If ...
https://dev.mysql.com/doc/refman/8.0/en/memory-storage-engine.html
MEMORY tables can have up to 64 indexes per table, 16 columns per index and a maximum key length of 3072 bytes. If a MEMORY table hash index has a high degree of key duplication (many index entries containing the same value), updates to the table ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-backup-using-management-client.html
If used, the backup_id must follow immediately after the START BACKUP keywords, before any other options are used. This function has the form shown here: key = KDF(random_salt, password) The key so generated is then used to encrypt the backup data ... Before starting a backup, make sure that the cluster is properly configured for performing ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-types.html
When partitioning by KEY or LINEAR KEY, you can use a DATE, TIME, or DATETIME column as the partitioning column without performing any modification of the column value. For KEY partitioning, this issue is taken care of automatically by the hashing ... This section discusses the types of partitioning which are available in MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/show-replica-status.html
Source_SSL_Allowed, Source_SSL_CA_File, Source_SSL_CA_Path, Source_SSL_Cert, Source_SSL_Cipher, Source_SSL_CRL_File, Source_SSL_CRL_Path, Source_SSL_Key, Source_SSL_Verify_Server_Cert These fields show the SSL parameters used by the replica to ...
https://dev.mysql.com/doc/refman/8.0/en/encrypted-connections.html
Certificates rely on asymmetric encryption algorithms that have two encryption keys (a public key and a secret key). Any data encrypted using this public key can be decrypted only using the corresponding secret key, which is held by the owner of the ... With an unencrypted connection between the MySQL client and the server, someone with access to the network could watch all your traffic and inspect the data being sent or received between client and ...
https://dev.mysql.com/doc/refman/8.0/en/federated-usagenotes.html
ON DUPLICATE KEY UPDATE statements, but if a duplicate-key violation occurs, the statement fails with an error. The following items indicate features that the FEDERATED storage engine does and does not support: The remote server must be a MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/general-thread-states.html
Analyzing The thread is calculating a MyISAM table key distributions (for example, for ANALYZE TABLE). manage keys The server is enabling or disabling a table index. Repair with keycache The repair code is using creating keys one by one through the ... The following list describes thread State values that are associated with general query processing and not more specialized activities such as ...
https://dev.mysql.com/doc/refman/8.0/en/index-preloading.html
If there are enough blocks in a key cache to hold blocks of an entire index, or at least the blocks corresponding to its nonleaf nodes, it makes sense to preload the key cache with index blocks before starting to use it. Preloading enables you to ...Although the blocks stay in the cache, because there are enough buffers for all of them, they are fetched from disk in random order, and not ...