Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hw-bulk-load-mysql-server.html
It can do the following: Optimize the loading of data sorted by primary key. Stored generated columns can be part of secondary indexes and the primary key. IN PRIMARY KEY ORDER: Use when the data is already sorted. For a file series, the primary ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-tpch-quickstart.html
row *************************** id: 1 select_type: SIMPLE table: lineitem partitions: NULL type: ALL possible_keys: NULL key: NULL key_len: NULL ref: NULL rows: 56834662 filtered: 33.33 Extra: Using where; Using secondary engine RAPID If the query ... The tpch Analytics Quickstart shows how to import data into the DB System using the MySQL Shell Parallel Table Import Utility, manually loading data into MySQL HeatWave Cluster, and running ...
https://dev.mysql.com/doc/connector-j/en/connector-j-connp-props-x-protocol-and-x-devapi.html
Default Value 10000 Since Version 8.0.13 xdevapi.connection-attributes An X DevAPI-specific comma-delimited list of user-defined "key=value" pairs, in addition to standard X Protocol-defined "key=value" pairs, to be passed to MySQL Server for ...If ...
https://dev.mysql.com/doc/refman/8.4/en/check-table.html
This also calculates a key checksum for the rows and verifies this with a calculated checksum for the keys. EXTENDED Do a full key lookup for all keys for each row. In this case, the AUTO_INCREMENT column changes value according to the rules of ...
https://dev.mysql.com/doc/refman/8.4/en/checking-rpm-signature.html
RPM 4.1 no longer uses your personal GPG keyring (or GPG itself). Rather, RPM maintains a separate keyring because it is a system-wide application and a user's GPG public keyring is a user-specific file. To import the MySQL public key into the RPM ...
https://dev.mysql.com/doc/refman/8.4/en/create-user.html
Encrypted connections can be used, at the client's option, if the client has the proper certificate and key files. CREATE USER 'jeffrey'@'localhost' REQUIRE X509; For accounts with REQUIRE X509, clients must specify the --ssl-key and --ssl-cert ...
https://dev.mysql.com/doc/refman/8.4/en/enterprise-encryption-configuring.html
MySQL Enterprise Encryption lets you limit keys to a length that provides adequate security for your requirements while balancing this with resource usage. Key Length Limits The amount of CPU resources required by MySQL Enterprise Encryption's key ...You can also configure the functions provided by the component_enterprise_encryption component to support decryption and verification for content produced by the old openssl_udf shared library ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-secure-user.html
Also, if you are using caching SHA-2 authentication, you must set up RSA key-pairs on the group members. If the replication user you configure for distributed recovery uses the caching SHA-2 authentication plugin, and you are not using SSL for ...
https://dev.mysql.com/doc/refman/8.4/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 ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-auto-increment-handling.html
The index is not required to be a PRIMARY KEY or UNIQUE, but to avoid duplicate values in the AUTO_INCREMENT column, those index types are recommended. ON DUPLICATE KEY UPDATE, which in the worst case is in effect an INSERT followed by a UPDATE, ...