Search Results
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/transaction-handling.html
Transactions can be used to group operations into an atomic unit. Either all operations of a transaction succeed when they are committed, or none. It is possible to roll back a transaction as long as it has not been committed. Transactions can be ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-auto-query-plan-improvement.html
A query execution plan may have nodes for table scans, JOIN, GROUP BY and other operations. The Auto Query Plan Improvement feature collects and stores query plan statistics in a statistics cache when a query is executed in MySQL HeatWave. When a ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-dictionary-encoding.html
Dictionary encoding (SORTED) has the following characteristics: Best suited to string columns with a low number of distinct values relative to the cardinality of the table. Dictionary encoding reduces the space required for column values on the ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-encoding-string-columns.html
Columns with a high number of distinct values MySQL HeatWave nodes Dictionary (SORTED) Supports GROUP BY and ORDER BY operations on string columns Columns with a low number of distinct values DB System node For additional information about string ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-limitations-parquet.html
As of MySQL 9.1.2, you can load Parquet files with row groups that total up to 10GB with large MySQL HeatWave Cluster shapes. MySQL HeatWave Lakehouse has the following limitations for Parquet files. Consider the following limitations: To load ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-rpd-query-stats-table.html
Includes prepart data, which can be queried to determine if a JOIN or GROUP BY query used data placement partitions. The rpd_query_stats table stores query compilation and execution statistics produced by the MySQL HeatWave plugin in JSON format.
https://dev.mysql.com/doc/heatwave/en/mys-hw-varlen-encoding.html
VARLEN Supported Relational Operators GROUP BY JOIN LIMIT ORDER BY VARLEN Encoding and Performance The presence of VARLEN encoded VARCHAR or CHAR columns does not affect table load performance. Variable-length encoding is automatically applied when ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-anomaly-detection-logs.html
MySQL 9.2.2 introduces the ability to detect anomalies in log data. To perform anomaly detection on logs, log data is cleaned, segemented, and encoded before running anomaly detection. The input table can only have the following columns: The column ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-ml-metrics.html
The ML_TRAIN routine includes the optimization_metric option, and the ML_SCORE routine includes the metric option. Both of these options define a metric that must be compatible with the task type and the target data. precision_k: An Oracle ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-topic-modeling-train.html
The output is an array of word groups that best characterize the text. After preparing the data for topic modeling, you can train the model. Before You Begin Review and complete all the tasks to Prepare Data for Topic Modeling. Requirements for ...