Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hw-advisor-auto-encoding.html
Encoding recommendations for the same table may differ after changes to data or data statistics. Using the right string column encodings can reduce the amount of memory required on MySQL HeatWave nodes and improve query performance. MySQL HeatWave ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-advisor-data-placement.html
The Data Placement Advisor generates data placement key recommendations by analyzing table statistics and MySQL HeatWave query history. Data placement keys are used to partition table data among MySQL HeatWave nodes when loading tables. Partitioning ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-advisor-syntax.html
exclude_query: Defines the IDs of queries to exclude when Advisor analyzes query statistics. Produces summarized output and sends it to stdout and to the heatwave_autopilot_report table. The silent output type is useful if human-readable output is ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-debugging-queries.html
Due to lack of quality statistics or non-optimal cost decisions, MySQL optimizer may introduce one or more Cartesian products in a query even if a query has predicates defined among all participating tables. This topic describes how to debug ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-generate-content.html
It's based on algorithms and statistical models that computer systems use to perform tasks without being explicitly programmed, learning from data instead.\n\n[END]", "error": null} As of MySQL 9.3.0, the output table generated using the ... The ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-summarize-content.html
The following sections in this topic describe how to summarize exiting content using MySQL HeatWave GenAI: Before You Begin Summarize Text Run Batch Queries What's Next Before You Begin Review the MySQL HeatWave GenAI requirements and privileges.
https://dev.mysql.com/doc/heatwave/en/mys-hw-partitioning.html
When data is loaded into MySQL HeatWave, it is partitioned by the table primary key and sliced horizontally for distribution among MySQL HeatWave nodes by default. To use this feature, define data placement keys on the most frequently used JOIN ...
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
ACE_MODEL Available as of MySQL 9.3.0, indicates whether an Advanced Cardinality Estimation (ACE) statistics model is currently associated with the given table in MySQL HeatWave. The rpd_tables table provides the system change number (SCN) and load ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-anomaly-detection-logs.html
For versions before MySQL 9.5.0, textual log data is transformed into numerical vectors using TF-IDF (Term Frequency-Inverse Document Frequency), which is a statistical feature extractor that assigns numerical weights to words according to their ...