Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hw-modifying-tables.html
While any of these operations are being executed, queries involving the modified table are not offloaded to the MySQL HeatWave engine; they are processed by InnoDB. If you are explicitly trying to use the secondary engine, these queries generate an ... When an InnoDB table is loaded into MySQL HeatWave Cluster, DDL operations such as ALTER TABLE, RENAME TABLE, TRUNCATE TABLE, and DROP TABLE are ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-select.html
This topic provides information related to the SELECT statement clauses supported in MySQL HeatWave and describes how to use the GROUP BY and QUALIFY clauses to group or filter the processing results. Verify if the query is offloaded to MySQL ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-ml-score.html
ML_SCORE scores a model by generating predictions using the feature columns in a labeled dataset as input and comparing the predictions to ground truth values in the target column of the labeled dataset. The dataset used with ML_SCORE should have ...
https://dev.mysql.com/doc/heatwave/en/mys-hwgenai-ml-generate.html
As of MySQL 9.4.1, the ML_GENERATE lets you generate text-based responses for queries pertaining to an image. language: specifies the language to be used for writing queries, ingesting documents, and generating the output. The ML_GENERATE routine ...
https://dev.mysql.com/doc/relnotes/heatwave/en/news-8-0-30.html
Data masking and de-identification operations are performed on the server, and queries involving data masking and de-identification functions are accelerated by MySQL HeatWave. (WL #15143) Optimizations were implemented to improve performance for ...
https://dev.mysql.com/doc/relnotes/heatwave/en/news-8-1-0.html
(WL #15383, WL #15559) Functionality Added or Changed Memory-aware query optimization now automatically adjusts MySQL HeatWave to optimize query execution time or memory usage and reduce the likelihood of queries running out of memory without user ... MySQL HeatWave AutoML Functionality Added or Changed MySQL HeatWave AutoML MySQL HeatWave AutoML has enhanced recommendation systems that can now recommend new users who are similar to a specific user and new items that are similar to other ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-heatwave-clusters.html
When a MySQL HeatWave Cluster is enabled and data is loaded, queries that meet certain prerequisites are automatically offloaded from the MySQL DB System to the MySQL HeatWave Cluster for accelerated processing. MySQL HeatWave Clusters 4 MySQL ...
https://dev.mysql.com/doc/heatwave-aws/en/privatelink.html
MySQL HeatWave on AWS supports two types of PrivateLinks: Query PrivateLinks: For applications running in your AWS account to access a MySQL HeatWave on AWS DB System over a private connection in order to manage it or to run queries. PrivateLink 6 ...
https://dev.mysql.com/doc/connector-j/en/connector-j-usagenotes-spring-config-jdbctemplate.html
Spring makes extensive use of the Template method design pattern (see Template Method Pattern). Our immediate focus will be on the JdbcTemplate and related classes, specifically NamedParameterJdbcTemplate. The template classes handle obtaining and ...
https://dev.mysql.com/doc/refman/8.4/en/alter-table.html
That is, a table-copying operation always includes at least the concurrency restrictions of LOCK=SHARED (allow queries but not DML). You can further restrict concurrency for operations that support the LOCK clause by specifying LOCK=EXCLUSIVE, which ... ALTER TABLE tbl_name [alter_option [, alter_option] ...] [partition_options] alter_option: { table_options | ADD [COLUMN] col_name column_definition [FIRST | AFTER col_name] | ADD [COLUMN] (col_name column_definition,...) | ADD {INDEX | KEY} [index_name] [index_type] (key_part,...) [index_option] ...