Search Results
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 ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-run-query.html
This topic describes how to use the EXPLAIN statement to analyze query execution and verify whether a query is offloaded to MySQL HeatWave for accelerated processing. Execute EXPLAIN Statement Before running a query, you can use EXPLAIN to ...To ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-troubleshooting-query-privatelink.html
Note:The error messages might read differently, as MySQL HeatWave on AWS gets updated. Connect to Private Hostname Application cannot connect, returning MySQL error like Error 2003: Can't connect to MySQL server Validate that your account allows ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-gr-memory-monitoring-ps-sample-queries.html
This section describes sample queries using the instruments and events for monitoring Group Replication memory usage. The memory data can be queried for individual events, for example: SELECT * FROM ...row *************************** EVENT_NAME: ...
https://dev.mysql.com/doc/refman/8.4/en/rewriter-query-rewrite-plugin-installation.html
To install or uninstall the Rewriter query rewrite plugin, choose the appropriate script located in the share directory of your MySQL installation: install_rewriter.sql: Choose this script to install the Rewriter plugin and its associated elements.
https://dev.mysql.com/doc/heatwave/en/mys-hw-auto-query-plan-improvement.html
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 new query shares query execution plan nodes with previously executed queries, the statistics ...Each entry in the cache corresponds to a query execution plan ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-query-analyzer-ref.html
The Query Analyzer provides a point-in-time snapshot of queries on the monitored database, enabling you to monitor SQL statements executed on a MySQL server and see details of each query, number of executions, and execution times. If the sys ...
https://dev.mysql.com/doc/workbench/en/wb-performance-query-statistics.html
The Query Stats SQL editor results tab (see the next two figures) uses Performance Schema data to gather key statistics collected for executed query, such as timing, temporary tables, indexes, joins, and more. Figure 7.5 SQL Editor: Query Stats ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-export-query-overview.html
AWS S3 URL: For MySQL HeatWave on AWS, you must use AWS S3 URLs. See Manage AWS Access from the MySQL HeatWave on AWS Service Guide to learn more. Supported File Formats You can export the query results in the following file formats: CSV (As of ...
https://dev.mysql.com/doc/connector-python/en/connector-python-api-cext-query.html
ccnx.query('DROP TABLE IF EXISTS t') ccnx.query('CREATE TABLE t (i INT NOT NULL AUTO_INCREMENT PRIMARY KEY)') ccnx.query('INSERT INTO t (i) VALUES (NULL),(NULL),(NULL)') ccnx.query('SELECT LAST_INSERT_ID()') row = ccnx.fetch_row() ...raw_as_string ...