Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hw-reload-mysql-tables.html
As of MySQL 8.4.0, MySQL HeatWave lets you reload all tables using the HEATWAVE_RELOAD routine. Before You Begin Complete the steps to load data using Auto Parallel Load or manually. Learn how to use the Machine Learning capabilities of MySQL ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-rpd-query-stats-table.html
The rpd_query_stats table stores query compilation and execution statistics produced by the MySQL HeatWave plugin in JSON format. For MySQL HeatWave AutoML routines that include multiple sub-queries, such as ML_TRAIN, a new record is used for each ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-rpd-tables-table.html
The rpd_tables table provides the system change number (SCN) and load pool type for tables loaded in MySQL HeatWave. The rpd_tables table has these columns: ID A unique identifier for the table. The SCN is an internal number that represents a point ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-secondary-load.html
You can load tables into HeatWave using the SECONDARY_LOAD clause. Loading Tables Statement To load a table into MySQL HeatWave, specify the SECONDARY_LOAD clause in an ALTER TABLE statement and use the following syntax. ALTER TABLE table_name ...
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-string-column-encoding-reference.html
MySQL HeatWave supports two string column encoding types: Variable-length encoding: This is the default encoding type. It applies to string columns by default when tables are loaded with the exception of string columns defined explicitly as ...
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-using-views.html
This topic describes how to run queries on views using MySQL HeatWave and verify if those queries are offloaded to the MySQL HeatWave secondary engine for accelerated processing. Verify if the query is offloaded to MySQL HeatWave for processing. To ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-anomaly-detection.html
Anomaly detection, which is also known as outlier detection, is the machine learning task that finds unusual patterns in data. The following tasks use datasets generated by OCI GenAI using Meta Llama Models. The anomaly detection use-cases are to ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-classification-score.html
After generating predictions and explanations, you can score the model to assess its reliability. For a list of scoring metrics you can use with classification models, see Classification Metrics. For this use case, you use the test dataset for ...