Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hw-advisor-data-placement.html
Partitioning table data by JOIN and GROUP BY key columns can improve query performance by avoiding costs associated with redistributing data among MySQL HeatWave nodes at query execution time. A query is counted if it includes a JOIN on tables ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-debugging-queries.html
mysql> EXPLAIN SELECT COUNT(*) FROM orders o, (SELECT o_custkey, AVG(o_totalprice) a_totalprice FROM orders GROUP BY o_custkey)a WHERE o.o_custkey=a.o_custkey AND o.o_totalprice>a.a_totalprice; The reason reported for a query offload failure depends ... This topic describes how to debug queries that fail to offload to MySQL HeatWave for ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-limitations-functions.html
As of MySQL 9.0.1-u1, the GROUP_CONCAT() function supports CUBE and ROLLUP non-primitive GROUP BY transformation options. A CASE control flow operator or IF() function that contains columns not within an aggregation function and not part of the ...
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. Auto Data Placement recommends data ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-training-an-anomaly-detection-model.html
IP DATETIME TIME HEX IPPORT OCID window_size: Specifies the maximum number of log lines to be grouped for anomaly detection. Log lines are grouped according to their respective source (for example, logs from multiple MySQL databases that are in the ... After preparing the data for an anomaly detection model, you can train the ...
https://dev.mysql.com/doc/relnotes/heatwave/en/news-8-2-0-u1.html
This is only available in MySQL HeatWave, see: GROUP BY Modifiers . MySQL HeatWave Lakehouse Functionality Added or Changed MySQL HeatWave Lakehouse MySQL HeatWave Lakehouse now uses Auto Parallel Load to load Avro files. (WL #15778) MySQL HeatWave ...
https://dev.mysql.com/doc/relnotes/heatwave/en/news-9-1-2.html
(WL #16530) MySQL HeatWave Lakehouse now supports efficient loading of Parquet files with large row groups (larger than 500MB and upto 10GB) using large shapes. This enhancement also introduces row group sharing, caching, and synchronization ...
https://dev.mysql.com/doc/heatwave-aws/en/ha-prerequisites.html
As the DB system high availability feature uses MySQL Group Replication, for which each table must have a primary key. Prerequisites 12.2 Prerequisites Here are some prerequisites for creating a high availability DB System. A high availability DB ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-iam-role-cloudwatch.html
Creating an IAM Role and Policy for CloudWatch Monitoring 21.5.5 Creating an IAM Role and Policy for CloudWatch Monitoring Use the AWS Management Console to create an IAM role for using CloudWatch to monitor your DB Systems and MySQL HeatWave ...
https://dev.mysql.com/doc/heatwave-aws/en/mysql-server-error-logging.html
Server Error Logging 3.1.2.3 Server Error Logging MySQL HeatWave on AWS logs MySQL Server diagnostic information such as errors, warnings, and status updates to the Performance Schema error_log table. You can use a command-line client such as MySQL ...