Search Results
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-hw-queries.html
Running MySQL HeatWave Queries 10.1 Running MySQL HeatWave Queries When a MySQL HeatWave Cluster is enabled and the data you want to query is loaded in MySQL HeatWave, queries that qualify are automatically offloaded from the MySQL DB System to the ...Simply run the query from the Query Editor, as described above, or from a MySQL client that is connected to the DB ...
https://dev.mysql.com/doc/connectors/en/connector-j-query-attributes.html
Connector/J supports Query Attributes when it has been enabled on the server by installing the query_attributes component (see Prerequisites for Using Query Attributes for details). Attributes are set for a query by using the setAttribute() method ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-dynamic-query-offload.html
As of MySQL 9.0.0, MySQL HeatWave uses dynamic query offload to choose the optimal execution engine for queries based on query and execution engine characteristics, which achieves improved performance. The overhead for more complex queries is also ... Before MySQL 9.0.0, MySQL HeatWave uses a query cost threshold to choose either INNODB or MySQL HeatWave as the execution engine for the ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-export-query-results-Parquet-non-json.html
This topic shows the different ways to export query results as a Parquet file with SQL syntax. Before You Begin Review the following: Overview of Exporting Query Results Requirements to Export Query Results Syntax Use the following SQL SELECT INTO ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-run-query.html
| | +------------+-----------+ 113 rows in set (0.4476 sec) Note Concurrently issued queries are prioritized for execution. This topic describes how to use the EXPLAIN statement to analyze query execution and verify whether a query is offloaded to ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-troubleshooting-query-privatelink.html
Troubleshooting a Query PrivateLink 6.1.5 Troubleshooting a Query PrivateLink Table 6-1 lists some common issues and their resolutions when setting up a Query PrivateLink, and Troubleshooting Connectivity in your AWS Account Using the AWS ...
https://dev.mysql.com/doc/connector-j/en/connector-j-query-attributes.html
Connector/J supports Query Attributes when it has been enabled on the server by installing the query_attributes component (see Prerequisites for Using Query Attributes for details). Attributes are set for a query by using the setAttribute() method ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-auto-query-plan-improvement.html
When a new query shares query execution plan nodes with previously executed queries, the statistics collected from previously executed queries are used instead of estimated statistics, which improves query execution plans, cost estimations, ... The ...
https://dev.mysql.com/doc/refman/8.4/en/rewriter-query-rewrite-plugin-reference.html
Rewriter_number_rewritten_queries The number of queries rewritten by the Rewriter query rewrite plugin since it was loaded. Users communicate with the plugin by modifying the set of rules stored in this table. The plugin communicates information to ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-export-query-results-json-non-json.html
The option to export query results as an ND-JSON file is available as of MySQL 9.3.1. This topic contains the following sections: Before You Begin Syntax Parameter Descriptions Examples What's Next Before You Begin Review the following: Overview of ...