Search Results
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/relnotes/heatwave/en/news-9-3-1.html
(WL #15994) MySQL HeatWave now supports creating asynchronous tasks for long-running queries and commands, allowing them to run in the background as separate tasks. This enhancement enables you to run complex queries without blocking other ... Note ...
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] ...
https://dev.mysql.com/doc/refman/8.4/en/batch-mode.html
You can generate new queries from existing ones that are similar by copying and editing script files. In the previous sections, you used mysql interactively to enter statements and view the results. If you want the script to continue even if some ...
https://dev.mysql.com/doc/refman/8.4/en/charset-collation-information-schema.html
The preceding behavior occurs because the utf8mb3_general_ci collation is not used for INFORMATION_SCHEMA queries when searching for values that correspond to objects represented in the file system. Consider whether a search should match all such ...
https://dev.mysql.com/doc/refman/8.4/en/create-table-generated-columns.html
Generated columns have several use cases, such as these: Virtual generated columns can be used as a way to simplify and unify queries. A complicated condition can be defined as a generated column and referred to from multiple queries on the table to ...Values of a generated column are computed from an expression included in the column ...