Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hw-modifying-tables.html
When an InnoDB table is loaded into MySQL HeatWave Cluster, DDL operations such as ALTER TABLE, RENAME TABLE, TRUNCATE TABLE, and DROP TABLE are permitted. While any of these operations are being executed, queries involving the modified table are ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-option-tracker.html
The Option Tracker component provides usage information about different features and components of MySQL HeatWave. As of MySQL 9.2.1, the boolean flag used has been replaced with an integer flag usedCounter in the option_tracker_usage_get() and ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-performance-monitoring.html
The MySQL Performance Schema collects statistics on the usage of MySQL HeatWave. Use SQL queries to access this data and check the system status and performance. The Auto Shape Prediction feature in MySQL HeatWave Autopilot uses MySQL statistics ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-silos.html
Figure 1.3 MySQL HeatWave Features MySQL HeatWave MySQL HeatWave is ideal for data warehousing, real-time analytics, mixed workloads, transactional processing, and machine learning workloads when the main data source is the DB System without needing ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-supported-cloud-platforms.html
This means that all the layers and components of MySQL HeatWave are deployed and fully managed on selected cloud platforms. MySQL HeatWave also supports hybrid deployments; it is fully compatible with MySQL on-premise. This provides you with the ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-unload-tables.html
Before You Begin Load structured data using Lakehouse Auto Parallel Load or manually. Unload Tables Unloading a table from MySQL HeatWave may be necessary to replace an existing table, to reload a table, to free up memory, or simply to remove a ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-vector-functions.html
It accepts the following arguments: A column of VECTOR data type.
https://dev.mysql.com/doc/heatwave/en/mys-hw-workload-optimization-olap.html
Workload optimization for online analytical processing, OLAP, includes using dictionary encoding for certain string columns and defining data placement keys to optimize for JOIN and GROUP BY query performance. Apply these optimizations manually, or ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-classification-train.html
After preparing the data for a classification model, you can train the model. Before You Begin Review and complete all the tasks to Prepare Data for a Classification Model. Train Model Train the model with the ML_TRAIN routine and use the ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-ease-of-use.html
With MySQL HeatWave AutoML and a set of training data in a MySQL HeatWave DB system, you can train a predictive machine learning model with a single call to the ML_TRAIN SQL routine. For example: CALL sys.ML_TRAIN('heatwaveml_bench.census_train', ...