Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-export-query-results-csv-non-json.html
You can create the following types of URIs: OCIFS Syntax: oci://bucket_name@namespace_name/object_path Example: oci://bucket_1@tenant_1/data_files/ PAR URI Syntax. Auto Parallel Load automatically gets the schema of the CSV files and creates the ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-limitations-other.html
The function definition must not contain CREATE, INSERT, ALTER, UPDATE, or DELETE statements. For a list of supported SQL modes, see Section 5.2, “Supported SQL Modes”. The WITH ROLLUP modifier in GROUP BY clauses in the following cases: In ...
https://dev.mysql.com/doc/heatwave/en/mys-hwgenai-ml-embed-table.html
Note In versions older than MySQL 9.2.1, to alter an existing table or create a new table, MySQL requires you to set the sql-require-primary-key system variable to 0. If the specified output table doesn't exist, then a new table is created. The ...
https://dev.mysql.com/doc/relnotes/heatwave/en/news-8-0-26.html
SELECT statements where the SELECT query is offloaded to MySQL HeatWave and the table is created on the MySQL Database Service instance. Advisor Auto Parallel Load Auto Scheduling Functionality Added or Changed Advisor The new MySQL HeatWave ...
https://dev.mysql.com/doc/relnotes/heatwave/en/news-9-3-0.html
Note These release notes were created with the assistance of MySQL HeatWave GenAI. This default value change impacts the following processes: New vector store tables are created using multilingual-e5-small by default. Retrieval augmented generation ...Important As of MySQL 9.3.0, to help you generate better quality embeddings, MySQL HeatWave GenAI uses multilingual-e5-small as the default embedding model for encoding documents in all supported languages including ...
https://dev.mysql.com/doc/heatwave-aws/en/ha-overview.html
Preferred and Current Primary Placement Preferred primary placement: While creating a high availability DB system, you can choose the AZ where you want to place the primary instance, which functions as a read/write endpoint. This is called the ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-backups.html
Backups 18 Backups This section describes how to create, restore, and manage MySQL DB System backups. If you reach the limit, remove the oldest backups before creating new ones. Creating a Backup Editing a Backup Viewing Backup Details Restoring a ...DB System backups are Amazon EBS snapshots which are automatically saved to Amazon Simple Storage Service (Amazon ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-cloudwatch-monitoring.html
Follow these steps to set up or reconfigure CloudWatch monitoring for your DB System (requires logging in to your AWS account): Create an AWS IAM role and policy in your AWS account for CloudWatch Monitoring. Enable CloudWatch monitoring for your DB ... CloudWatch Monitoring 17.1 CloudWatch Monitoring MySQL HeatWave on AWS supports AWS CloudWatch for detailed monitoring of your DB Systems and MySQL HeatWave ...
https://dev.mysql.com/doc/connector-j/en/connector-j-server-authentication.html
If the truststore file does not already exist, a new one will be created; otherwise the certificate will be added to the existing file. The next step is to configure Java or Connector/J to read the truststore you just created or modified. Setting ...
https://dev.mysql.com/doc/connector-j/en/connector-j-usagenotes-spring-config-connpooling.html
When this is the case, it usually makes sense to create a pool of database connections available for web requests as needed. Although MySQL does not spawn an extra process when a connection is made, there is still a small amount of overhead to ...