Search Results
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/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 ...
https://dev.mysql.com/doc/refman/8.4/en/archive-storage-engine.html
When you create an ARCHIVE table, the storage engine creates files with names that begin with the table name. Attempting to create an index on any other column results in an error. The ARCHIVE engine also supports the AUTO_INCREMENT table option in ... The ARCHIVE storage engine produces special-purpose tables that store large amounts of unindexed data in a very small ...
https://dev.mysql.com/doc/refman/8.4/en/change-replication-filter.html
Multiple replication filtering rules can be created in a single CHANGE REPLICATION FILTER statement by separating the rules with commas, as shown here: CHANGE REPLICATION FILTER REPLICATE_DO_DB = (d1), REPLICATE_IGNORE_DB = (d2); Issuing the ...
https://dev.mysql.com/doc/refman/8.4/en/declare-handler.html
statement handler_action: { CONTINUE | EXIT | UNDO } condition_value: { mysql_error_code | SQLSTATE [VALUE] sqlstate_value | condition_name | SQLWARNING | NOT FOUND | SQLEXCEPTION } The DECLARE ... HANDLER statement specifies a handler that deals ...