Search Results
https://dev.mysql.com/doc/refman/8.4/en/insert-on-duplicate.html
If you specify an ON DUPLICATE KEY UPDATE clause and a row to be inserted would cause a duplicate value in a UNIQUE index or PRIMARY KEY, an UPDATE of the old row occurs. In general, you should try to avoid using an ON DUPLICATE KEY UPDATE clause ...If column b is also unique, the INSERT is equivalent to this UPDATE statement instead: UPDATE t1 SET c=c+1 WHERE a=1 OR b=2 LIMIT 1; If a=1 OR b=2 matches several rows, only one row is ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-partitioning.html
When data is loaded into MySQL HeatWave, it is partitioned by the table primary key and sliced horizontally for distribution among MySQL HeatWave nodes by default. To use this feature, define data placement keys on the most frequently used JOIN ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-migrate-keyring.html
The mysql_migrate_keyring utility migrates keys between one keyring component and another. Invoke mysql_migrate_keyring like this (enter the command on a single line): mysql_migrate_keyring --component-dir=dir_name --source-keyring=name ...For ...
https://dev.mysql.com/doc/refman/8.4/en/bnl-bka-optimization.html
In MySQL, a Batched Key Access (BKA) Join algorithm is available that uses both index access to the joined table and a join buffer. The batched_key_access flag controls how the optimizer uses the Batched Key Access join algorithms. Optimizer hints ...The BKA algorithm supports inner join, outer join, and semijoin operations, including nested outer ...
https://dev.mysql.com/doc/refman/8.4/en/create-table-gipks.html
MySQL 8.4 supports generated invisible primary keys for any InnoDB table that is created without an explicit primary key. When the sql_generate_invisible_primary_key server system variable is set to ON, the MySQL server automatically adds a ...This ...
https://dev.mysql.com/doc/refman/8.4/en/creating-ssl-rsa-files-using-mysql.html
MySQL provides these ways to create the SSL certificate and key files and RSA key-pair files required to support encrypted connections using SSL and secure password exchange using RSA over unencrypted connections, if those files are missing: The ...
https://dev.mysql.com/doc/refman/8.4/en/keyring-functions-plugin-specific.html
For each keyring plugin-specific function, this section describes its purpose, calling sequence, and return value. For information about general-purpose keyring functions, see Section 8.4.4.12, “General-Purpose Keyring Key-Management Functions”. keyring_aws_rotate_cmk() Associated keyring plugin: keyring_aws keyring_aws_rotate_cmk() rotates the AWS KMS ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-reset-server-public-key.html
void mysql_reset_server_public_key(void) Description Clears from the client library any cached copy of the public key required by the server for RSA key pair-based password exchange. This might be necessary when the server has been restarted with a ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-keyring-keys-table.html
MySQL Server supports a keyring that enables internal server components and plugins to securely store sensitive information for later retrieval. Key metadata includes key IDs, key owners, and backend key IDs. The keyring_keys table does not expose ...
https://dev.mysql.com/doc/refman/8.4/en/creating-rsa-files-using-openssl.html
This section describes how to use the openssl command to set up the RSA key files that enable MySQL to support secure password exchange over unencrypted connections for accounts authenticated by the sha256_password (deprecated) and ...