Search Results
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-workspace-running-queries.html
Running Queries 10 Running Queries The Workspace tab in the MySQL HeatWave Console provides a Query Editor for running MySQL and MySQL HeatWave queries. Results from queries with SQL code comments might not be displayed accurately. Select the ...To ...
https://dev.mysql.com/doc/refman/8.4/en/controlling-query-plan-evaluation.html
For join queries, the number of possible plans investigated by the MySQL optimizer grows exponentially with the number of tables referenced in a query. The task of the query optimizer is to find an optimal plan for executing an SQL query. Because ...For small numbers of tables (typically less than 7 to 10) this is not a ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-deploying-query-privatelink.html
Figure 6-1 illustrates the different components that make up a Query PrivateLink connection from your AWS VPC to your MySQL HeatWave on AWS DB System. (Optional) For security purposes, remove public connectivity to your MySQL HeatWave on AWS DB ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-query-prerequisites.html
Ensure that the following requirements are met before offloading queries to MySQL HeatWave: Use a SELECT statement. To check the autocommit setting: mysql> SHOW VARIABLES LIKE 'autocommit'; +---------------+-------+ | Variable_name | Value | ...
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/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/refman/8.4/en/performance-schema-query-profiling.html
mysql> UPDATE performance_schema.setup_instruments SET ENABLED = 'YES', TIMED = 'YES' WHERE NAME LIKE '%statement/%'; mysql> UPDATE performance_schema.setup_instruments SET ENABLED = 'YES', TIMED = 'YES' WHERE NAME LIKE '%stage/%'; Ensure that ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/main-queries-reference.html
The main queries enable you to retrieve data from the monitored server. When defining queries, the following restrictions apply: The query must be defined within a <![CDATA[]]> container. Do not define queries which take longer to run than the ...
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/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. Before MySQL 9.0.0, MySQL HeatWave uses a ...