Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hw-rpd-nodes-table.html
The rpd_nodes read-only table provides information about MySQL HeatWave nodes. The rpd_nodes table has the following columns: ID A unique identifier for the MySQL HeatWave node. CORES The number of cores used by the MySQL HeatWave node. The table ...
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 ...The rpd_query_stats table has these columns: CONNECTION_ID The ID of the ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-model-handles.html
You must use model handles to run MySQL HeatWave AutoML routines. In the following example, @census_model is defined as the model handle session variable with no set model handle name: mysql> CALL sys.ML_TRAIN('heatwaveml_bench.census_train', ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-training-a-recommendation-model.html
Recommendation Training Models As of MySQL 9.5.0: The default recommendation training model is the TwoTower model with Pytorch. In earlier versions, MySQL HeatWave AutoML selects the best model for the task based on the available models. After ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-using-an-anomaly-detection-model.html
To detect anomalies in log data (MySQL 9.2.2 and later), you can only run the ML_PREDICT_TABLE routine. Requirements for Generating Predictions As of MySQL 9.4.1, if you run ML_PREDICT_TABLE with the log_anomaly_detection task, at least one column ...To generate predictions, use the sample data from the two anomaly detection datasets: credit_card_train and ...
https://dev.mysql.com/doc/heatwave/en/mys-hwgenai-ml-rag.html
As of MySQL 9.3.1, default value is '{"model_id": "llama3.2-3b-instruct-v1"}', in previous versions, default value is '{"model_id": "mistral-7b-instruct-v1"}'. This column can be of any data type supported by MySQL HeatWave. In earlier versions of ... The ML_RAG routine performs retrieval-augmented generation (RAG) by: Taking a natural-language ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-supported-shapes.html
Supported Shapes 3.1.1 Supported Shapes MySQL HeatWave on AWS supports the following MySQL and MySQL HeatWave node shapes. The MySQL HeatWave.16GB node shape may not have enough memory for training on large data sets. Lakehouse is supported on the ...If you see error messages about this (such as ML003024), use the larger shape ...
https://dev.mysql.com/doc/refman/8.4/en/case-sensitivity.html
This example shows that VERSION() returns a string that has a case-insensitive collation, so comparisons are case-insensitive: mysql> SELECT COLLATION(VERSION()); +----------------------+ | COLLATION(VERSION()) | +----------------------+ | ... For ...
https://dev.mysql.com/doc/refman/8.4/en/flow-control-functions.html
mysql> SELECT IF(1>2,2,3); -> 3 mysql> SELECT IF(1<2,'yes','no'); -> 'yes' mysql> SELECT IF(STRCMP('test','test1'),'no','yes'); -> 'no' IFNULL(expr1,expr2) If expr1 is not NULL, IFNULL() returns expr1; otherwise it returns expr2. mysql> SELECT ...
https://dev.mysql.com/doc/refman/8.4/en/general-tablespaces.html
General tablespace data files can be placed in a directory relative to or independent of the MySQL data directory, which provides you with many of the data file and storage management capabilities of file-per-table tablespaces. As with ... A general ...