Search Results
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-importing-data-bulk-ingesting.html
The files are named, booking.tsv1, booking.tsv2, ..., booking.tsv25:LOAD DATA FROM S3 's3-us-east-1://mysql-heatwave-data-us-east-1/airportdb/booking.tsv.' COUNT 25 IN PRIMARY KEY ORDER INTO TABLE booking COLUMNS TERMINATED BY '\t' LINES TERMINATED ... Importing Data Using the Bulk Ingest Feature 7.2.2.2 Importing Data Using the Bulk Ingest Feature Connect to a DB System and bulk ingest data from an Amazon S3 bucket to a DB System in the same ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-relnotes.html
It has the following improvements: Revamped with key information presented in a dashboard-like layout. 2024-01-17: Inbound Replication Support Now Further Enhanced MySQL HeatWave on AWS supports inbound replication that does not use GTID ... Release ...
https://dev.mysql.com/doc/heatwave-aws/en/hw-aws-ha-enabling-stand-alone-db-systems.html
See Prerequisites on how to check if this is satisfied, and how to add primary keys to your tables if needed. If it does not, update the MySQL configuration and select a configuration that supports high availability. If they are not, see Editing a ...
https://dev.mysql.com/doc/heatwave-aws/en/mysql-server-plugins-components.html
MySQL Enterprise Encryption Provides built-in, server-side asymmetric encryption, key generation, digital signatures, and other cryptographic features to help protect confidential data using public and private keys. Plugins and Components 3.1.2.6 ...
https://dev.mysql.com/doc/connector-j/en/connector-j-connp-props-blob-clob-processing.html
blobSendChunkSize Chunk size to use when sending BLOB/CLOBs via server-prepared statements. Note that this value cannot exceed the value of 'maxAllowedPacket' and, if that is the case, then this value will be corrected automatically. Since Version ...
https://dev.mysql.com/doc/connector-j/en/connector-j-WebAuthn-authentication.html
Web Authentication (WebAuthn) enables user authentication for MySQL Server using devices such as smart cards, security keys, and biometric readers. WebAuthn enables passwordless authentication, and can be used for MySQL accounts that use ...
https://dev.mysql.com/doc/refman/8.4/en/alter-table-problems.html
If you get a duplicate-key error when using ALTER TABLE to change the character set or collation of a character column, the cause is either that the new column collation maps two keys to the same value or that the table is corrupted. In the latter ...
https://dev.mysql.com/doc/refman/8.4/en/binary-varbinary.html
For those cases where trailing pad bytes are stripped or comparisons ignore them, if a column has an index that requires unique values, inserting values into the column that differ only in number of trailing pad bytes results in a duplicate-key ...
https://dev.mysql.com/doc/refman/8.4/en/blob.html
This means that, if the index requires unique values, duplicate-key errors occur for values that differ only in the number of trailing spaces. For example, if a table contains 'a', an attempt to store 'a ' causes a duplicate-key error. A BLOB is a ...
https://dev.mysql.com/doc/refman/8.4/en/can-not-connect-to-server.html
If you get the error message Can't connect to MySQL server on some_host, you can try the following things to find out what the problem is: Check whether the server is running on that host by executing telnet some_host 3306 and pressing the Enter key ... A MySQL client on Unix can connect to the mysqld server in two different ways: By using a Unix socket file to connect through a file in the file system (default /tmp/mysql.sock), or by using TCP/IP, which connects through a port ...