Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hw-metadata-queries-query-history.html
The rpd_query_stats table stores query compilation and execution statistics (the query history) for the last 1000 successfully executed queries. To view the MySQL HeatWave query history including query start time, end time, and wait time in the ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-query-analyzer-queries.html
Figure 32.2 Normalized Queries and Statistics Graphs The statement graph displays the average execution time, number of executions, and the number of rows affected. Click on an individual query to see more detailed information about the individual ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-metadata-queries-query-offload.html
The sys.processlist and sys.x$processlist views in the MySQL sys Schema also include an execution_engine column.
https://dev.mysql.com/doc/refman/8.4/en/mysql-command-options.html
mysql supports the following options, which can be specified on the command line or in the [mysql] and [client] groups of an option file. For information about option files used by MySQL programs, see Section 6.2.2.2, “Using Option Files”.
https://dev.mysql.com/doc/c-api/8.4/en/c-api-asynchronous-interface-usage.html
This section describes how to use the C API asynchronous interface. In this discussion, asynchronous and nonblocking are used as synonyms, as are synchronous and blocking. The asynchronous C API functions cover operations that might otherwise block ...
https://dev.mysql.com/doc/heatwave/en/heatwave-errors.html
Error number: 1037; Symbol: HW_ER_UNSUPPORTED_EXPR_IN_CORRELATED_SUBQUERIES Message: The expression, [%s], is not supported for correlated subqueries. Description: The specific functionality for correlated subqueries is absent in HeatWave. Error ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-advisor-auto-query-time-estimation.html
Auto Query Time Estimation provides: Runtimes for successfully executed queries Runtime estimates for EXPLAIN queries. Runtime estimates for queries that fail due to an out-of-memory error. Auto Query Time Estimation can provide runtime data for up ...Runtime data can be used for query optimization, troubleshooting, or to estimate the cost of running a particular query or workload on MySQL ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-debugging-queries.html
This topic describes how to debug queries that fail to offload to MySQL HeatWave for execution. Setting Secondary Engine Definition By default, SELECT queries are offloaded to MySQL HeatWave for execution and fall back to the DB System if that is ...To learn how to download the sample database, see AirportDB Analytics ...
https://dev.mysql.com/doc/refman/8.4/en/slow-query-log.html
The slow query log can be used to find queries that take a long time to execute and are therefore candidates for optimization. By default, administrative statements are not logged, nor are queries that do not use indexes for lookups. This behavior ... The slow query log consists of SQL statements that take more than long_query_time seconds to execute and require at least min_examined_row_limit rows to be ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-query-runtimes.html
This topic describes how you can view MySQL HeatWave query runtimes and runtime estimates using the MySQL HeatWave Autopilot Advisor Auto Query Time Estimation feature, or by querying the performance_schema.rpd_query_stats table. Runtime data is ...