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_usage_get() function returns a value similar to the following: mysql> SELECT option_tracker_usage_get('Berry Picker'); +----------------------------------------------------+ | option_tracker_usage_get('Berry Picker') | ... The ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-performance-monitoring.html
For MySQL HeatWave for Azure, select Metrics on the details page for the MySQL HeatWave Cluster to access Microsoft Azure Application Insights. The MySQL Performance Schema collects statistics on the usage of MySQL HeatWave. Use SQL queries to ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-silos.html
Similarly, generating predictions only requires a single CALL or SELECT statement, which can be easily integrated into your applications. Figure 1.3 MySQL HeatWave Features MySQL HeatWave MySQL HeatWave is ideal for data warehousing, real-time ...
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
See the following to learn more: Load Partitions Partition Selection Limitations When an unload operation successfully unloads the last partition, it unloads the whole table. Before You Begin Load structured data using Lakehouse Auto Parallel Load ...
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
mysql> SELECT model_id, model_handle, train_table_name FROM ML_SCHEMA_user1.MODEL_CATALOG WHERE model_handle = 'classification_use_case'; +----------+----------------------------------------------+-------------------------------------+ | model_id | ... After preparing the data for a classification model, you can train the ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-ease-of-use.html
For example, the following call to the ML_PREDICT_TABLE routine generates predictions for a table of input data: CALL sys.ML_PREDICT_TABLE('heatwaveml_bench.census_test', @census_model, 'heatwaveml_bench.census_predictions', NULL); All MySQL ...With ...